Virtual Machine that no longer exists on backing infrastructure has MISSING status in Aria Automation portal.

Products

• VMware Aria Suite

Issue/Introduction

This article describes how to remove a machine with a missing status where the deployment has been deleted,  the machine no longer exists and the UI has no option to delete the machine.

Symptoms:

• Virtual Machine shows status missing in Aria Automation Cloud Assembly Resources.
• The VM no longer exists in vCenter, the deployment object is deleted.
• There is no option to delete the machine in the Aria Automation UI.

Environment

VMware Aria Automation 8.x

Cause

When deployments with missing resources are deleted those resources are still displayed as missing.

Resolution

This issue is resolved in the vRealize Automation 8.11.1 release. If a deployment is deleted with missing resources the resources will be deleted when the delete deployment request is issued.

Workaround:

Before making any changes, always ensure you back up the Aria Automation environment.

1. Take snapshots of all Aria Automation nodes (without memory).
2. Log into the Aria Automation Cloud Assembly portal.
3. Navigate to Assembler -> Virtual Machines -> Managed and locate the VM with a "MISSING" status.
4. Click on the VM to open its details.
5. On the right-hand side, scroll down to Custom Properties and locate the 'resourceId'.
6. Copy the 'resourceId' and save it to a notepad file for later reference.
7. SSH to the Aria Automation appliance as the 'root' user.
8. Log into the PostgreSQL using the following command:

vracli dev psql

9. Connect to the catalog database:

 \c catalog-db

10. Use the 'resourceId' from step 6 to locate the resource:

select * from dep_resource where id = 'resourceidfromstep6xxxxx';

11. Verify that you see only one record, confirming the "MISSING" status and correct resource details.
12. Remove the resource from the database:

delete from dep_resource where id = 'resourceidfromstep6xxxxx';

Once this is done, the "MISSING" VM will no longer be visible in the Aria Automation Cloud Assembly resources.

Additional Information

Impact/Risks:

Machines are present which no longer exist on the backing infrastructure, the deployment has been deleted but we have no option to delete machines in the UI.