Post migration or upgrade to version 7.5, Form Details or Day 2 operations do not appear for Azure machines

Products

• VMware Aria Suite

Issue/Introduction

After upgrade or migration to vRealize Automation 7.5, Form Details or Day 2 operations may not show up properly for Azure Machines.  Some examples of Day 2 operations would be Start, Stop, or Restart.

vRealize Automation 7.5 ships with a new Azure plugin that supports the latest Azure SDK.  This issue can occur on migrated or upgraded setups due to changes in this plugin.

Environment

VMware vRealize Automation 7.5.x

Resolution

VMware is aware of this issue.

A resolution for this issue is being evaluated for inclusion in a future release.

To work around this issue, perform the following steps:

1. Snapshot or backup all related servers and databases.
2. Log into the vRealize Automation appliance using the console or SSH.
3. Log into postgres using the following commands:
   
   su postgres
   cd /opt/vmware/vpostgres/current/bin
    
4. Connect to the database by running the command:
   
   psql vcac
    
5.  Run the following SQL queries:
   
   update asd_resource set vco_id = REPLACE(REPLACE( REPLACE(vco_id,',vmid:',',virtual-machine:') ,',rg:',',resource-group:') , ',location:', ',region:' ) where vco_type = 'Azure:VirtualMachine';
   
   update cat_resource set resourcedata = REPLACE(resourcedata::text ,'", "powerState"=>"{\"type\":\"string\",\"value\":\"','", "powerState"=>"{\"type\":\"string\",\"value\":\"PowerState/')::hstore where resourcetype_id = '_internal!::!dda3cc3f-f2da-45f5-bc64-a292c1ace3ba' AND resourcedata::text not like '%"PowerState/%' ;
    
6. Exit the postgres vcac database by running the commands:
   
   \q
   exit