Error when synchronizing CA Business Intelligence with CA Performance Management

Products

• CA Infrastructure Management
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

Error when synchronizing CA Business Intelligence with CA Performance Management

Cause

Error from DMService.log:

"An error occurred during a sync request with data source CA Business [email protected]: 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
 at com.ca.im.portal.api.services.datasource.DataSourcePoll.pollProductSyncWS(DataSourcePoll.java:157)
 at com.ca.im.portal.api.services.datasource.DataSourcePoll.poll(DataSourcePoll.java:98)
 at com.ca.im.portal.dm.productsync.PullSyncPhaseTask.pollDataSource(PullSyncPhaseTask"

Environment

Release : 8.0

Component : CABI JasperReports Server for CA Performance Management

Resolution

NOTE: As always, you should have a backup of all the DX Netops Performance Management components per the documentation before directly updating any database.

1) In $CABI_HOME there is a file named pcProperties, look for:

NpcConnectionUID=<NPC CONNECTION UID>

Example:

NpcConnectionUID=7d0d5419c7234560ae04217ab1843063

2) In CA Performance Center, find the SourceID of the CA Business Intelligence datasource and verify the SourceGUID does not match:

mysql netqosportal -u netqos -p<password> -e "select SourceID,SourceType,ConsoleName,ConsoleHost,SourceGUID from data_sources2 where ConsoleName like '%CA Business Intelligence%'"
    
Example output:

+----------+------------+----------------------------------------+--------------------------------+----------------------------------+
| SourceID | SourceType | ConsoleName                            | ConsoleHost                    | SourceGUID                       |
+----------+------------+----------------------------------------+--------------------------------+----------------------------------+
|        5 |          1 | CA Business [email protected]    | servername.domain.tld          | 10a8d55535c6497cb8b515a298b39301 |
+----------+------------+----------------------------------------+--------------------------------+----------------------------------+


3) Update the database with the correct SourceGUID:

mysql netqosportal -u netqos -p<password> -e "update data_sources2 set SourceGUID = '<NPC CONNECTION UID HERE>' where SourceID = <data_sources2 SOURCEID of CABI SOURCE HERE>;

Example:

mysql netqosportal -u netqos -p<password> -e "update data_sources2 set SourceGUID = '7d0d5419c7234560ae04217ab1843063' where SourceID = 5;