CAPC failing to sync with ADA 11

Products

• CA Application Delivery Analysis MTP (NetQoS / ADA)

Issue/Introduction

After adding ADA (11.0+) to a CAPC installation as a datasource it fails to synchronize.

Looking at the following log on the ADA console:

<installation dir>/CA/SuperAgentSync20XX-XX-XX.Application.SuperAgentDataSource.log

We see the following error:

Cannot add or update a child row: a foreign key constraint fails (`super`.`aggregate_servers`, CONSTRAINT `fk_aggregate_servers_server_id` FOREIGN KEY (`SERVER_ID`) REFERENCES `servers` (`SERVER_ID`))

Environment

Windows 2008, 2012, 2016

Cause

There are foreign key constraints that were left in the mysql database as part of a new ADA function. These functions were not completed in the 11.0 release and cause issues when attempting to edit paramters in the database. We see these issues most frequently when trying to add an ADA datasource to a CAPC installation.

Resolution

To fix the issue you must do the following on the ADA console:

1) Open a command prompt with administrator rights
2) 'mysql'
3) 'use super'
4) 'alter table aggregate_servers drop foreign key fk_aggregate_servers_server_id;'

Once that is complete, attempt to synchronize the ADA console and the CAPC again and it should succeed.