The Application Delivery Analysis (ADA) Data Source in DX NetOps Performance Management PC Portal web UI is failing synchronization.
The ADA DS in PC Portal is failing sync.
ADA/NPC Bind Failure
Data source is missing 204 child references in the bind_group_members table
Source: Device Manager
Occurred On: 21 Dec 2015 10:06:11 PST
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)
The following error is seen in the PC 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
Incorrect information present in ADA database.
All supported Application Delivery Analysis and DX NetOps Performance Management integrated releases
To resolve the issue:
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:
The Data Source should once again successfully sync with PC Portal.