Spectrum will not Sync with CAPC with DS_PRODUCT_ID_CHANGED error

Document ID : KB000073145
Last Modified Date : 13/03/2018
Show Technical Document Details
Issue:

Upon enabling the Spectrum data source in CAPC, it gives the error "Data Source Product ID has changed. Create an new entry for this data source", and remains disabled. In the /opt/CA/PerformanceCenter/DM/logs/DMService.log we see the below DS_PRODUCT_ID_CHANGED errors for the Spectrum synchronizations:

 

An error occurred during a sync request with data source Spectrum @ <IP address of Spectrum>: additional info: enum.datasourceerror.DS_PRODUCT_ID_CHANGED. The following stack trace shows the context of the sync request:

Environment:
CA Performance Management and CA Spectrum
Cause:
Product ID does not match on both the source and the destination.
Resolution:

Following are the steps to fetch the GUID from CA Spectrum and update it on CA Performance Center:

Open a bash shell (bash -login)

Go to $SPECROOT/mysql/bin directory
Run:
./mysql --defaults-file=../my-spectrum.cnf -uroot -proot

use netqos_integ

select * from registry; 

Example :
mysql> select * from registry; 
+-----------+--------------------------------------+
| attribute | value                                |
+-----------+--------------------------------------+
| guid      | 116ab9ed-3a11-435d-b841-16fa4da3f696 |
+-----------+--------------------------------------+

1 row in set (0.02 sec)

\q 

 

From CAPC, update the Spectrum GUID: 

./mysql -unetqos -pnetqos

use netqosportal

select * from data_sources2\G;


Example 
*************************** 4. row ***************************
                   SourceID: 4
                 SourceType: 65536
                 SourceGUID: 116ab9ed-3a11-435d-b841-16fa4da3f696

make a note of the spectrum SourceID.

update data_sources2 set sourceguid='value from above' where sourceid=<spectrum sourceid from above>; 

\q


Go back to CAPC and run a full synchronization of the CA Spectrum data source.