CA ADA message Cannot add or update a child row: a foreign key constraint fails

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)

Issue/Introduction

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

Environment

Release : 11.1

Component : ADA MGMT CONSOLE

Cause

Database table corrupted

Resolution

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