ADA / Performance Center Bind Failure: Missing Child References

Document ID : KB000004206
Last Modified Date : 14/08/2018
Show Technical Document Details
Issue:

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()

Environment:
Application Delivery Analysis
CA / NetQoS Performance Center
Resolution:

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.

File Attachments:
TEC1911039.zip