This issue is resolved in vRealize Automation 7.2, available at
VMware Downloads.
To work around this issue if you do not want to upgrade, manually cleanup the affected records in the IPAM request table. This prevents vRealize Automation from retrying the request and stops the errors from occurring.
To manually cleanup the affected records in the IPAM request table:
Note: Take a backup or snapshot of vRealize Automation appliance.
- Log in to the vRealize Automation appliance through SSH using root credentials.
- Log in to postgres database.
- Navigate to /opt/vmware/vpostgres/current/bin
- Run the command:
su postgres
- Run the command:
./psql vcac
- To extend the view in postgres, run the command:
\x
- Confirm the record exists or not by running this command:
SELECT * FROM IAAS_PROVIDER_IPAM_REQUESTS WHERE MACHINE_ID='xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx';
Note: The Machine ID refers to the affected machine ID for which vRealize Automation fails to fetch from the database.
- Delete the record from the postgres database by running this command:
DELETE FROM IAAS_PROVIDER_IPAM_REQUESTS WHERE MACHINE_ID='xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx';