ADA / Performance Center Bind Failure: Missing Child References

ADA/NPC Bind Failure

Data source is missing 204 child references in the bind_group_members table 
Source: Device Manager 
Severity: Error 
Occurred On: 21 Dec 2015 10:06:11 PST 

Detail: 
Source: DataSourceService 
System.ArgumentException: Data source is missing 204 child references in the bind_group_members table 
at NetQoS.Services.DataSources2.DataSource2.BindGroupMembers(IDBConnection db, DataSourcePoller dsp, SyncUpdateTable sut, UInt32 updateStage, UInt32 utcUpdateTime) 
at NetQoS.Services.DataSources2.DataSource2.ProcessBindingTables(IDBConnection db, DataSourcePoller dsp, SyncUpdateTable sut, UInt32 updateStage, UInt32 utcUpdateTime) 
at NetQoS.Services.DataSources2.DataSource2.Bind(IDBConnection db, DataSourcePoller dsp, UInt32 utcUpdateTime) 
at NetQoS.Services.DataSources2.DataSourcePoller.ThreadProc()

1. On the ADA server login to mysql via CMD line with: mysql super

2. Run this command: alter table aggregate_applications_flags drop foreign key fk_aggregate_applications_flags_agg_id;

3. Run this command: delete from aggregates where agg_id > 9; 

4. Perform a full resync in CAPC.