Error when synchronizing CA Business Intelligence with CA Performance Management
Release : 8.0
Component : CABI JasperReports Server for CA Performance Management
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"
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;