Data Aggregator (DA) will not sync with CAPC

Article Id: 37755
Status: Published
Updated On: 14-02-2018 07:36
Legacy Id: TEC1942066
Products:
CA Infrastructure Management , CA Infrastructure Management , CA Performance Management - Usage and Administration , CA Performance Management - Data Polling
Issue/Introduction:

Issue:

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

 

Environment:

2.x

 

Resolution:

  1. Go to http://<DA>:8581/rest/dataaggregator 
  2. Make note of value between <NpcConnectionUID> and </NpcConnectionUID> tags 
    • (ex) <NpcConnectionUID>ec605bcfa3644be4a1d716808e0948ae</NpcConnectionUID> 
  3. From a CAPC shell type the following: mysql netqosportal 
  4. Run the following commands from mysql prompt: 
  • select * from data_sources2 where ConsoleName like 'Data Aggregator%'\G; ---> this is to confirm the DA's SourceType. 
  • update data_sources2 set SourceGUID='NPC_ID_From_DA_Rest_output' where SourceType=262144; 
    • (ex) update data_sources2 set SourceGUID='ec605bcfa3644be4a1d716808e0948ae' where SourceType=262144; 
  • Now do a full resync of the Data Aggregator datasource and it should now work fine

Environment:

Release: IMDAGG99000-2.5-Infrastructure Management-Data Aggregator
Component: