Messages:AAAA-MM-DD HH:MM:SS,NNN | Error | Exception while processing file "C:\CA\Datafiles\R1645328700_10-2-16.dat": Cannot add or update a child row: a foreign key constraint fails (`super`.`aggregate_clients`, CONSTRAINT `fk_aggregate_clients_agg_id` FOREIGN KEY (`AGG_ID`) REFERENCES `aggregates` (`AGG_ID`))
/* QUERY THREW EXCEPTION
Source: Devart.Data.MySql
Message: Cannot add or update a child row: a foreign key constraint fails (`super`.`aggregate_clients`, CONSTRAINT `fk_aggregate_clients_agg_id` FOREIGN KEY (`AGG_ID`) REFERENCES `aggregates` (`AGG_ID`))
*/
Release : 11.1
Component : ADA MGMT CONSOLE
Database table corrupted
Stop all ADA Services
Delete the foreign key using :
mysql super
alter table aggregate_clients drop foreign key fk_aggregate_clients_agg_id;
quit;
Then restart the CA MySQL service and after all ADA Services