Synchronization issue in CAPC while integrating with ADA

Products

• APPLICATION DELIVERY ANALYSIS
• SUPERAGENT

Issue/Introduction

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`))

 

Cause

New feature not fully implemented in ADA 11.2

Environment

ADA 11.2.0 with CAPC 3.5

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