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.