Aria Operations 8.18.x
This issue occurs if the vCenter with VCF license was removed from Aria Operations at some point.
(1) Identify the specific vCenter adapter(s) to remove by collecting/comparing these two outputs.
(a) SSH to Aria Operations and note the output of the vc_id and it's status from the following command:
su - postgres -c "/opt/vmware/vpostgres/current/bin/psql -d vcopsdb -p 5433 -c 'select * from vcenter_license_mapping;'
(b) Export the integrations JSON from Aria Operations - see below screenshot.
(2) If the vCenter ID is showing as -2 within the postgres output. And that vc_id also exists within the integration JSON. These are the vCenter adapter names that need updating.
{Example - see how 6era11ff-21j7-4oc4-9b43-86a032c66ff2 vc_id has -2 status and maps to the hostname myvcenterhostname.local}
6era11ff-21j7-4oc4-9b43-86a032c66ff2 | -2 | vSphere 8 Enterprise Plus for VCF
"resourceUUID": "6era11ff-21j7-4oc4-9b43-86a032c66ff2"
(3) Follow the steps below after taking snapshots of all Analytics nodes in the Aria Operations cluster as per this KB.
(4) Login to Aria Operations UI to remove and readd the affected vCenter integrations.
Contact Broadcom Support by attaching these outputs to a new case if you require further assistance with these steps.