Unable to remove missing resources from deployment on Aria Automation

Products

• VMware vRealize Automation 8.x

Issue/Introduction

• There are one or more resources that are in an invalid/missing state or have been deleted already however on the Aria Automation they still show up.
• If missing/deleted resources are tied to a deployment, options like change project/owner, etc will fail the validation test and the requests will fail. 
• An exact error like : "Action is not supported based on the current state. Reason: Validation Failure"
• You cannot remove the resources from the VRA UI as an option does not exist. 

Cause

• If a deployment has missing/deleted resources tied up the day-2 actions like change project/owner, etc will fail the validation test and cannot get executed. 

Resolution

• Ensure proper backup and snapshot of the VRA environment before attempting the workaround/resolution steps. 
• We can remove the missing/deleted resources from the VRA database. 
• Steps:
  1. ssh as root to the VRA node. 
  2. Run the below command to access the VRA DB:
     vracli dev psql
  3. change to catalog db:
     \c catalog-db
  4. Run the below query to list the missing resource:
     select * from dep_resource where id='c9751f4e-0843-424f-81b0-16ffb1dbbc0c';
     
     Note: you can get the resource ID of the resource from the VRA UI. See below as an example of an affected resource "extrad":
     
     
  5. Run the below query to delete the problematic resource :
     delete from dep_resource where id='c9751f4e-0843-424f-81b0-16ffb1dbbc0c';
  6. Once the missing resource is deleted, you can go back to the deployment and try to change the project for the deployment and it will work.