How to update failed deployment migration status in VRA 8.x from DB

Products

• VMware Aria Suite

Issue/Introduction

How to update failed deployment migration status in VRA 8.x from DB

Symptoms:

Deployment migration status failed.

Environment

VMware vRealize Automation 8.x

Resolution

There is a workaround to manually update the status from the migration DB if needed. 

Workaround:

Note: Take snapshots of all nodes of vRA as a precautionary measure. 
           Please involve GSS if not confident to carry out the below steps.

Run this on the master vRA 8.x node , SSH as root: 

1. Enter  db of vRA: vracli dev psql
2. Change to migration-db: \c migration-db
3. Display all tables under the migration-db: \dt
4. run the below queries to update the 2 tables ( inventory and the target_object) :

update target_object set status = ‘MIGRATED’, message_parameters = null, message_key=null where type = ‘DEPLOYMENT’ and status=‘MIGRATION_FAILED’;
update inventory set status =‘MIGRATED’, error_message=null where status=‘MIGRATION_FAILED’;

 

      5.Exit the database: \q

Additional Information

Impact/Risks:

No Major Impact.