Onboarding Plan Stuck in "In-Progress" State due to Onboarding Timeout Issues in Aria Automation 8.x

Products

• VMware Aria Suite
• VMware vRealize Automation 8.x

Issue/Introduction

The onboarding plan remains in the "In-Progress" state despite all VMs being successfully onboarded.

Onboarding plan shows as "executing," for the VMs which displays "pending" status.

This situation typically occurs when the onboarding process times out, preventing the status from changing to "FAILED" and instead leaving it in the "EXECUTING" state.

Environment

Aria Automation 8.x

Resolution

 

1. 1. Take a snapshot of all the Aria automation nodes.
   2. SSH into one of the Aria Automation appliance nodes in your cluster.
   3. Execute the following command to open the relocation database: vracli dev psql relocation-db 
   4. Turn on expanded display : \x
   5. Provide the name of the affected onboarding plan by running the following query:  select * from plan where name = ‘NAME OF PLAN’;
   6. Update the status of the specific onboarding plan to 'OK':   update plan set status=‘OK’ where name = ‘NAME OF PLAN’;
   7. Execute the select query to ensure the status has been updated: select * from plan where name = 'NAME OF PLAN';
   8. Exit the database command-line interface : \q
   9. Login to Aria automation portal to check the status.
   10. You should now be able to add/remove the VM machines in the plan.