Synchronization issue in CAPC while integrating with ADA

Document ID : KB000102460
Last Modified Date : 19/06/2018
Show Technical Document Details
Issue:
ADA datasource Synchronization Failure in CAPC 

From the DMService.log in CAPC :
Data source Application Delivery Analysis@xxx.xxx.xxx.xx encountered an error while processing a sync request.  The problem is in the data source, not CAPC.  Check the logs for the data source to determine the cause of the problem.  The following stack trace shows the context of the sync request:
javax.xml.ws.soap.SOAPFaultException: Server was unable to process request. ---> Exception has been thrown by the target of an invocation. ---> Failed applying updates during Push Synchronization. ---> Cannot add or update a child row: a foreign key constraint fails (`super`.`aggregate_servers`, CONSTRAINT `fk_aggregate_servers_server_id` FOREIGN KEY (`SERVER_ID`) REFERENCES `servers` (`SERVER_ID`))

 
Environment:
ADA 11.2.0 with CAPC 3.5
Cause:
New feature not fully implemented in ADA 11.2
Resolution:
Delete the foreign key using :
mysql super
alter table aggregate_servers drop foreign key fk_aggregate_servers_server_id;
quit;

Then restart the CA MySQL service
Then restart the ADA synchronization on CAPC