Unable to add ADA Data Source in DX NetOps

Products

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

Issue/Introduction

The ADA data source will not sync after upgrade. We had to uninstall/reinstall the ADA software. Now the following error is seen in DMService.log.

The log is found in the (default path) /opt/CA/PerformanceCenter/DM/logs directory.

The full exception is:

ERROR | pool-2-thread-4 | 2017-04-23 00:00:47,743 | com.ca.im.portal.dm.productsync.DataSourcePoller 
| 
An error occurred during a sync request with data source <ADA Host>: 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:150)
at com.ca.im.portal.api.services.datasource.DataSourcePoll.poll(DataSourcePoll.java:93)
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:101)
at com.ca.im.portal.dm.productsync.SyncPhaseExecutor$MakeDSSyncPhaseCallable$1.call(SyncPhaseExecutor.java:94)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Cause

As part of an ADA upgrade the application was uninstalled and reinstalled. As a result the unique key that allows the tools to communicate has changed, preventing the communication from working.

To validate the values do not match between systems take these steps.

1. On the ADA host:
   1. Open a web browser and go to the following URL: http://localhost/superagentdatasource/productsyncws.asmx
   2. Click on the ProductID link
   3. Click Invoke
   4. Note the value for the Product ID on the resulting page. It is used in the solution.
2. In a terminal/CLI on the PC Portal host complete the following:
   1. Connect to the MySql DB using (default paths shown) this command. Enter the password when prompted.
      • /opt/CA/MySql/bin/mysql -uroot -p
   2. Set it to use the netqosportal DB with the command:
      • use netqosportal;
   3. List the Data Sources with the following command. Find and note the SourceID and SourceGUID values for the ADA Data Source. They are used in the solution.
      • select * from data_sources2\G;
3. The SourceGUID values will not match which causes the error found in the Device Manager logs.

Environment

All supported DX NetOps Performance Management releases

Resolution

To resolve this problem take the following steps. We will make the SourceGUID in PC Portal netqosportal DB match the value from ADA.

1. Follow the steps in the Cause section of this article to determine the SourceGUID value used by ADA and PC Portal.
2. Open the MySql prompt on the PC Portal and change the SourceGUID to match the one seen in ADA.
   1. Connect to the MySql DB using (default paths shown) this command. Enter the password when prompted.
      • /opt/CA/MySql/bin/mysql -uroot -p
   2. Set it to use the netqosportal DB with the command:
      • use netqosportal; 
   3. Run the following query to change the value.
      1. Replace <ADA_SourceGUID> with the value obtained via the steps in the Cause section (Step 1.4). Leave the single quotes surrounding the value.
      2. Replace <ADA_SourceID> with the value obtained via the steps in the Cause section (Step 2.3).
         • update data_sources2 set SourceGUID='<ADA_SourceGUID>' where SourceID=<ADA_SourceID>;
      3. EX: update data_sources2 set SourceGUID='1234567890' where SourceID=5;

The data source should now be able to be added and should sync successfully with PC Portal.