Post reinstall of Data Aggregator sync fails in Performance Management

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The Synchronization between Performance Management and the Data Aggregator Data Sources fails.

The Device Manager DMService.log file shows an error referencing DS_PRODUCT_ID_CHANGED.

This is seen after having reinstalled the Data Aggregator without having deleted and re-added the Data Aggregator as a Data Source in Performance Management.

Environment

All supported Performance Management releases

Cause

Data Aggregator was removed and added again to Performance Management or Data Aggregator was re-installed.

Resolution

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 Performance Center 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 Performance Center 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.

Additional Information

If after resolving this issue you start getting error 503 attempting to use odata you may need to cycle Portal services:

https://knowledge.broadcom.com/external/article?articleId=259263