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, the following error message is displayed:

 

Environment

Aria Operations 8.17x and later

VCF Operations 9.x 

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

1. SSH into the Aria Operations node as root and first start the casa service:
   systemctl stop vmware-casa
2. Change directories and make a copy of the casa.db.script:
   cd to /storage/db/casa/webapp/hsqldb
cp -p casa.db.script casa.db.script.orig
3. Open the file with with vi and look for the following line:
   INSERT INTO CLOUD_PROXY VALUES('####-####-####-####-#######','####.####.####.####',NULL,NULL,NULL,'<cloudproxy_name>','
4.  Once the above line is identified, press 'dd' on the keyboard to delete the full line.
5. . Save the file (wq!)
6.  Restart the casa service with the following command:
   systemctl start vmware-casa
7. Log into the Admin UI and make sure the reference to the CP (Cloud Proxy) is now removed.