After deleting the ADA console from the ada_inventory probe configuration in UIM I am unable to add ADA to CAPC as a Data Source.

Document ID : KB000006280
Last Modified Date : 23/10/2018
Show Technical Document Details
Issue:

When attempting to add ADA to CAPC after it being linked to UIM I get the message:

"This data source is attached to another performance center and must be detached before it can be added to this performance center."

Environment:
ADA
UIM
ada_inventory probe
CAPC
Cause:

The UIM IP address is still found in the super.parameter_descriptions table in ADA even after deleting the ADA console from the ada_inventory probe configuration in UIM.

Resolution:

1. RDP to the ADA Console, open a command prompt, and run the command below to login to mysql:

mysql super

 

2. Run the following update statement to remove the UIM URL from the ADA database:

update parameter_descriptions set defaultValue='' where parameter='uimPortalUrl';

 

3. Refresh the CAPC Data Sources page and attempt to add ADA as a data source again and it should succeed.