search cancel

Data Aggregator (DA) will not sync with NetOps PC Portal

book

Article ID: 37755

calendar_today

Updated On:

Products

CA Performance Management - Usage and Administration DX NetOps

Issue/Introduction

The DA will not sync with CAPC.  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.

Cause

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

Environment

All supported DX NetOps Performance Management releases

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