CAPC failing to sync with ADA 11

Document ID : KB000107985
Last Modified Date : 26/07/2018
Show Technical Document Details
Issue:
After adding ADA (11.0+) to a CAPC installation as a datasource it fails to synchronize.

Looking at the following log on the ADA console:

<installation dir>/CA/SuperAgentSync20XX-XX-XX.Application.SuperAgentDataSource.log

We see the following error:

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:
Windows 2008, 2012, 2016
Cause:
There are foreign key constraints that were left in the mysql database as part of a new ADA function. These functions were not completed in the 11.0 release and cause issues when attempting to edit paramters in the database. We see these issues most frequently when trying to add an ADA datasource to a CAPC installation.
Resolution:
To fix the issue you must do the following on the ADA console:

1) Open a command prompt with administrator rights
2) 'mysql'
3) 'use super'
4) 'alter table aggregate_servers drop foreign key fk_aggregate_servers_server_id;'

Once that is complete, attempt to synchronize the ADA console and the CAPC again and it should succeed.