Data Aggregator (DA) will not sync with NetOps Portal

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The DA will not sync with NetOps Portal.  The following error is seen in the /opt/CA/PerformanceCenter/DM/logs/DMService.log: DS_PRODUCT_ID_CHANGED

The Data Aggregator Data Source fails to synchronize with the DX NetOps Performance Management Portal web UI. It began after migrating data from production to lab systems and starting the lab systems. Now the synchornization fails showing the DS_PRODUCT_ID_CHANGED error.

Environment

All supported DX NetOps Performance Management releases

Cause

Failure to run the update scripts post data migration can cause this problem.

Resolution

Ensure all services on test environment where data was migrated to are shut down until update scripts are run to update host names and/or IP addresses.

The following steps will resolve the DA synchronization failure in NetOps Portal.

1. Open the following URL to the DA:
   • http://<DA_HOST>:8581/rest/dataaggregator/
   • Note the <NpcConnectionUID> value listed. Set it aside for use later.
2. Open a terminal to the NetOps Portal server. Connect to the MySql database:
   1. Move to (default path) /opt/CA/MySql/bin
   2. Run:
      • ./mysql -unetqos -p<password> netqosportal
   3. Run:
      • select SourceID,SourceGUID,SourceType,ConsoleName from data_sources2;
3. Compare the <NpcConnectionUID> from the DA REST page and the SourceGUID ID value from the PC netqosportal DB.
4. If the IDs do not match run the following update to the Performance Center netqosportal database.
   1. Use the <NpcConnectionUID> value noted earlier from the DA REST page.
   2. In the MySql prompt run:
      • update data_sources2 set SourceGUID='<NpcConnectionUID>' where SourceType=262144;
5. In NetOps Portal go to Administration->Data Sources->Data Sources.
   1. Select the Data Aggregator Data Source
   2. Select the Sync button.
   3. Check the box for a Full Sync and run it.