The ADA data source will not sync in CAPC

Document ID : KB000006589
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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 Gigamon@Va10p51463: 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)

Environment:
Any CAPM version
Cause:

As part of the ADA upgrade the application was uninstalled and reinstalled

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 
  • select * from data_sources2\G; 
  • 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 SourceType=<SourceType>; 

EX: update data_sources2 set SourceGUID='1234567890' where SourceType=2; 

 

The data source should now sync successfully