CABI Data Source synchronization fails in Performance Management

book

Article ID: 205250

calendar_today

Updated On:

Products

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

Issue/Introduction

We have a data source between DX NetOps Performance Management and CABI and its not syncing.  I tried to restart CABI and its still failing.

CABI Jaspersoft synchronization fails with the following error from the (default path) /opt/CA/PerformanceCenter/DM/logs/DMService.log file.

ERROR | pool-2-thread-4          | 2020-12-16 08:09:58,176 | com.ca.im.portal.dm.productsync.DataSourcePoller                 
      | 
An error occurred during a sync request with data source CA Business [email protected]<CABI_HostName-or-IP_Address>: 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.java:88)
 at com.ca.im.portal.dm.productsync.PullSyncPhaseTask.execute(PullSyncPhaseTask.java:65)
 at com.ca.im.portal.dm.productsync.SyncPhaseExecutor$MakeDSSyncPhaseCallable$1.call(SyncPhaseExecutor.java:94)
 at com.ca.im.portal.dm.productsync.SyncPhaseExecutor$MakeDSSyncPhaseCallable$1.call(SyncPhaseExecutor.java:87)
 at java.util.concurrent.FutureTask.run(FutureTask.java:266)
 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
 at java.lang.Thread.run(Thread.java:748)

Cause

The SourceGUID for the CABI Data Source in the Performance Center MySql netqosportal database data_sources2 table no longer matches the NpcConnectionUID from the CABI pcProperties file.

Ways this is triggered and the NpcConnectionUID on CABI is changed:

  • CABI Data Source already integrated with Performance Center is re-installed or uninstalled and re-installed on the same server.
  • CABI Data Source is deleted from Performance Center and added again.

Environment

All supported DX NetOps Performance Management releases

Resolution

To resolve this issue complete the following steps.

  1. Find and open the pcProperties file from the home directory of the CABI installation. Note the NpcConnectionUID value. A sample pcProperties file contains:

    #Sat Dec 12 12:36:43 EST 2020
    NpcConnectionUID=1853837c80bb4184a045ca0a93cd6ffd
    ProductID=<value>

  2. Open a terminal on the Performance Center host server
    1. Enter the MySql prompt:
      1. Go to (default path) /opt/CA/MySql/bin
      2. Run the following and enter the password when prompted.
        • ./mysql -uroot -p netqosportal
      3. Confirm the SourceType for the CABI Data Source using the following command. In the instance that this was observed from it was SourceType=1.
        • select * from data_sources2 where ConsoleName like '%Business Intelligence%'\G;
      4. Run the following command:
        • Replace the NpcConnectionUID_from_pcProperties_file value with the NpcConnectionUID from the pcProperties file.
        • Replace the <value> for SourceType with the SourceType value identified in step 2.1.3 above.
          • update data_sources2 set SourceGUID='NpcConnectionUID_from_pcProperties_file' where SourceType=<value>;
        • Sample command might look like:
          • update data_sources2 set SourceGUID='1853837c80bb4184a045ca0a93cd6ffd' where SourceType=1;
      5. Log in to the Performance Center web UI.
        1. Go to Administration->Data Sources->Data Sources.
        2. Select the CABI Data Source and choose the Resync button.
        3. Choose the Full Synchronization check box
        4. Run the Full Synchronization