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

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

book

Article ID: 345955

calendar_today

Updated On:

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.