Spectrum data source synchronization failed

Document ID : KB000092896
Last Modified Date : 24/12/2018
Show Technical Document Details
Issue:
When attempting to synchronize the Spectrum Data Source, a "Synchronization failed" error message is returned. 
Environment:
CAPM 3.x
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:
To resolve this: 

1. Get the GUI from the Spectrum server
Under Windows:
a. Run bash -login (command line prompt),

b. cd $SPECROOT/mysql/bin 

c. Run; ./mysql -uroot -proot 

d. When the MySQL command prompt appears, run the following;
mysql>use netqos_integ
myslq>select * from registry;
This should return something similar to;
+-----------+--------------------------------------+ 
| attribute | value                                | 
+-----------+--------------------------------------+ 
| guid      | 61982d30-9978-4a2e-9183-a0eb2ef8c3ce | 
+-----------+--------------------------------------+ 

mysql>quit

Under Linux:
e. cd $SPECROOT/mysql/bin 

f. Run the following: 
./mysql--defaults-file=../my-spectrum.cnf -uroot -proot  
mysql>use netqos_integ
mysql>select * from registry;
This should return something similar to;
+-----------+--------------------------------------+ 
| 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;

 
This will return something similar to;
+----------+--------------------------------------+-------------------------------------------------+
| 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 under Administration -> Data Sources, run a full Spectrum sync