IP address not showed after virtual machine onboard in Aria Automation

Products

• VCF Operations/Automation (formerly VMware Aria Suite)

Issue/Introduction

• Unregister virtual machine from Aria Automation.
• Change IP address of the virtual machine and then onboard the virtual machine in Aria Automation.
• The IP address of this virtual machine doesn't appear in Aria Automation under Networks of Resources in Infrastructure.
• The 'document_update_action' is DELETE for the IP address of the virtual machine in Aria Automation database as below:

provisioning-db=# select document_update_action from ipaddress_state where ip_address = '#.#.#.#';
-[ RECORD 1 ]-------------------+-----------------------------------------------------------------
document_update_action          | DELETE

Environment

VMware Aria Automation

Cause

The value of 'document_update_action' can be PATCH, PUT other than DELETE.

Resolution

NOTE: 

• Suggest to contact Broadcom Support since the steps need to change database that has risk.
• Before action need to take backup or snapshot of Aria Automation.

To resolve the issue follow below steps: 

1. Access Aria Automation 'provisioning-db' database with the steps in KB Unable to add datastore in Datastore Profile
2. Run below SQL command to update the value of 'document_update_action' to PATCH
   
   provisioning-db=# update ipaddress_state set document_update_action = 'PATCH' where ip_address = '#.#.#.#';
   
   
3. IP address of virtual machine can be showed in Aria Automation network resources. 

Additional Information

Aria Automation: Infoblox IP allocation fails with "network interface IP assignment [STATIC] allocation failed: Network profile ... has no subnets with static IP ranges or ranges do not have available IP addresses.'