ADA datasource Synchronization Failure in CAPC 

From the DMService.log in CAPC :
Data source Application Delivery [email protected] 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`))

 

New feature not fully implemented in ADA 11.2

ADA 11.2.0 with CAPC 3.5

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