Data Aggregator (DA) will not sync with CAPC

Products

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

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: