Spectrum will not Sync with CA Performance Management (NetOps Portal) with DS_PRODUCT_ID_CHANGED error

Products

• CA Spectrum
• DX NetOps

Issue/Introduction

Upon enabling the Spectrum data source in NetOps Portal, it generates the following error in the /opt/CA/PerformanceCenter/DM/logs/DMService.log and remains disabled:

An error occurred during a sync request with data source Spectrum Infrastructure Manager: 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

Environment

DX NetOps CA Performance Management and CA Spectrum

Cause

Product ID does not match on both the source (Spectrum) and the destination (NetOps Portal).

Resolution

The following shows how to get the GUID from CA Spectrum and update it on CA Performance Management:

1. Open a bash shell (bash -login) on the Spectrum OneClick server
   
   

2. cd $SPECROOT/mysql/bin
   
   

3. Run:
   

   ./mysql --defaults-file=../my-spectrum.cnf -uroot -p<pass>
   
   

4. At the MySQL command prompt, run:
   

   use netqos_integ
   
   select * from registry; 

   
   For example :
   

   mysql> select * from registry; 
   +-----------+--------------------------------------+
   | attribute | value                                |
   +-----------+--------------------------------------+
   | guid      | 116ab9ed-3a11-435d-b841-16fa4da3f696 |
   +-----------+--------------------------------------+
   1 row in set (0.02 sec)
   
   \q 

5. On NetOps Portal, update the Spectrum GUID: 
   
   

6. cd /opt/CA/MySql/bin
   
   

7. Then run NetOps Portal MySQL netqosportal DB:
   

   ./mysql -unetqos -p<DB_PASSWORD> netqosportal
   
   

8. At the MySQL command prompt, run the following (NOTE: ConsoleName specifies the name of the datasource (DS), so we're looking for the DS with Spectrum in it):
   
   

   select * from data_sources2 where ConsoleName like '%Spectrum%'\G;

   
   The top part of the output should look like:
   
   

   *************************** 1. row ***************************

                              SourceID: 4

                            SourceType: 65536

                            SourceGUID: 34196c80-f136-48f8-9c53-cd6bd0799178

                           ConsoleName: [e-mail]

                           ConsoleHost: xx.xx.xx.xx

                           ConsolePort: 8080

                       ConsoleProtocol: http

   
   Note how the spectrum SourceGUID (34196c80-f136-48f8-9c53-cd6bd0799178 in the above example) is different to that on Spectrum itself (Step 4 above).
   
   
9. So now the SourceGUID for Spectrum in the NetOps Portal DB has to be changed to reflect the actual value from Spectrum itself, as obtained in Step 4. On the NetOps Portal MySQL netqosportal db, update the data_sources2 tables:
   
   

   update data_sources2 set sourceguid='GUID value from step 4' where sourceid=<spectrum SourceID>; 

   
   From the above example:

   update data_sources2 set sourceguid='116ab9ed-3a11-435d-b841-16fa4da3f696' where sourceid=4; 
   

    

10. Go back to the NetOps Portal -> Data Sources page and run a full synchronization of the CA Spectrum data source.