The ADA data source will not sync in CAPC

book

Article ID: 6589

calendar_today

Updated On:

Products

CA Infrastructure Management CA Infrastructure Management CA Performance Management - Usage and Administration CA Performance Management - Data Polling

Issue/Introduction

The ADA data source will not sync after upgrade.  The following error is seen in DMService.log: DS_PRODUCT_ID_CHANGED.  

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 Anthem ADA [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: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 the ADA upgrade the application was uninstalled and reinstalled

Environment

Any CAPM version

Resolution

On the ADA box:

  • Open a web browser and go to the following URL: http://localhost/superagentdatasource/productsyncws.asmx 
  • Click on the ProductID link 
  • Click Invoke 
  • Note the value for the Product ID on the resulting page

 

In CAPC shell please do the following:

  • mysql netqosportal 
  • mysql -unetqos -pnetqos netqosportal  
  • Find the ADA data source 
  • Once you find the data source note the SourceGUID.  It should not match the value you got from the ADA box in the previous steps

 

We want to make the SourceGUID in CAPC match the value from ADA. Please do the following: 

  • Confirm the "SourceType" of the ADA data source once located 
  • Run the following query: update data_sources2 set SourceGUID='ADA productID ' where SourceID=<ADA SourceID; 

EX: update data_sources2 set SourceGUID='1234567890' where SourceID=<ADA SourceID>; 

 

The data source should now sync successfully