Unable to manually delete an Aria Operations cloud proxy either via command line using curl command or via postman

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

When executing a curl command to manually remove a cloud proxy in Aria Operations 8.17 and later, the following error message is displayed:

following guidelines from knowledge base article: 326397

Environment

Aria Operations 8.17x and later

Cause

The cloud proxy has been removed from Aria Operations UI, however, the Cloud Proxy is still visible from the admin UI. Remnants of the cloud proxy record are still referenced in the casa database. 

Resolution

To resolve the issue:

1.  stop the vmware casa service

systemctl stop vmware-casa


2. Cd to /storage/db/casa/webapp/hsqldb

First, cp -p casa.db.script casa.db.script.orig.05.27.25 (This to make a copy of the file as a backup)

3. open the casa.db.script file (vi)

From here you will need to identify the lines that reference the existing Cloud Proxy: The lines starts as follows: (note the UUID of the CP)

INSERT INTO CLOUD_PROXY VALUES('XXXXX-XXXX-XXXXX-XXXX-XXXXXXXXXX','XXX.XXX.XXX.XXX',NULL,NULL,NULL,'ops-04','.......xxxxxxxxxx

4. Once the identify the above line, delete the entire entry.  

5. Save the file
 

6. restart the casa service:

systemctl start vmware-casa
 

7. Log into the Admin UI and make sure the reference to the CP is now removed?

Additional Information

executing a curl command to manually delete a cloud proxy will not work, if remnants of the CP record still exist in the casa.db.script file. 

A manual clean up is required.