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

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


Article ID: 73145


Updated On:


CA Spectrum DX NetOps


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


DX NetOps CA Performance Management and CA Spectrum


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


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)


  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: Spectrum@xx.xx.xx.xx

                            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.