Spectrum data source synchronization failed

Document ID : KB000092896
Last Modified Date : 24/04/2018
Show Technical Document Details
Issue:
We get the error message on the CA PM, Data Source Synchronization failed. 
Cause:
When looking at the DMService.log file on the CAPC system we see the error: 
ERROR | pool-2-thread-2375 | 2018-01-31 00:02:16,831 | com.ca.im.portal.dm.productsync.DataSourcePoller | 
An error occurred during a sync request with data source Spectrum Infrastructure Manager@<SYSTEMNAME>: additional info: enum.datasourceerror.DS_PRODUCT_ID_CHANGED. The following stack trace shows the context of the sync request: 
com.ca.im.portal.api.services.interfaces.datasource.DataSourceOp$Exception: enum.datasourceerror.DS_PRODUCT_ID_CHANGED

This means the GUID in Spectrum is not matching the GUID in CAPC. Reinstalls and hardware swaps can cause this to occur.
 
Resolution:
This means the GUID in Spectrum is not matching the GUID in CAPC. Reinstalls and hardware swaps can cause this to occur. To resolve this: 

1. Get the GUI from the Spectrum server

Windows:
From command prompt, go to C:\win32app\Spectrum\mysql\bin 
From C:\...\bin> mysql -uroot -proot 
mysql>use netqos_integ
myslq> select * from registry;
+-----------+--------------------------------------+ 
| attribute | value | 
+-----------+--------------------------------------+ 
| guid | 61982d30-9978-4a2e-9183-a0eb2ef8c3ce | 
+-----------+--------------------------------------+ 
mysql>quit

Linux:
From the /usr/Spectrum/mysql/bin directory, type the following: 
./mysql--defaults-file=../my-spectrum.cnf -uroot -proot  
mysql>use netqos_integ
mysql> select * from registry;
+-----------+--------------------------------------+ 
| attribute | value | 
+-----------+--------------------------------------+ 
| guid             | 61982d30-9978-4a2e-9183-a0eb2ef8c3ce | 
+-----------+--------------------------------------+ 
mysql>quit


2. Update the SourceGUID on the CAPC system to the guid from the Spectrum system 

mysql -unetqos -pnetqos
mysql>use netqosportal
mysql> select SourceID,SourceGUID,ConsoleName from data_sources2;
+----------+--------------------------------------+-------------------------------------------------+
| SourceID | SourceGUID                           | ConsoleName                                     |
+----------+--------------------------------------+-------------------------------------------------+
|        0 | 7ad19999-af87-4cf4-a68c-0bf5c1e3f5f7 | CA Performance Center                           |
|        2 | 41e28329a7934bf48b8f4c32d2639b3e     | EventManager@verri01-F170346                    |
|        3 | 9f2dff7b6f5f43a2ac72f2cb24d1794f     | Data Aggregator@verri01-F170345                 |
|        4 | fea5625d-17a1-4229-a7f0-975040ecc3dd | Spectrum Infrastructure Manager@verri01-f165512 |
+----------+--------------------------------------+-------------------------------------------------+
4 rows in set (0.00 sec)

2. Note the SourceId for the Spectrum Infrastructure Manager Console and then update the SourceGUID to the guid you got from Spectrum. 
mysql>update data_sources2 set sourceguid='61982d30-9978-4a2e-9183-a0eb2ef8c3ce' where SourceID=4;
mysql>quit

3. In the CAPC GUI run a full Spectrum sync