ADA / NetOps Portal Bind Failure: Missing Child References

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)
• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The Application Delivery Analysis (ADA) Data Source in NetOps Portal web UI is failing synchronization.

The ADA DS in NetOps Portal is failing sync.

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

The following error is seen in the NetOps Portal DMService.log file.

ERROR | pool-2-thread-2          | 2021-12-10 11:47:14,033 | com.ca.im.portal.dm.productsync.DataSourcePoller                       | 
Data source Application Delivery Analysis encountered an error while processing a sync request.  The problem is in the data source, not CAPC.  Check the logs for the data source to determine the cause of the problem.  The following stack trace shows the context of the sync request:
java.lang.IllegalArgumentException: Data source 5 is missing 5 child references in the bind_group_members table

Environment

All supported Application Delivery Analysis and DX NetOps Performance Management integrated releases

Cause

Incorrect information present in ADA database.

Resolution

To resolve the issue:

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 NetOps Portal for the ADA Data Source.

Additional Information

The solution step 3 MySql delete command may fail with an error similar to the following error.

mysql> delete from aggregates where agg_id > 9;
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`super`.`aggregate_applications`, CONSTRAINT `fk_aggregate_applications_agg_id` FOREIGN KEY (`AGG_ID`) REFERENCES `aggregates` (`AGG_ID`))

To resolve that error:

1. Run this command:
2. delete from aggregate_applications where agg_id > 9;
3. Run the alter command from solution step 2 again.
4. Run the delete command from solution step 3 that returned an error.

The Data Source should once again successfully sync with NetOps Portal.