Imported Virtual machine in vRA not showing IP address allocation in network profile

 

Imported Virtual machine in vRA not showing IP address allocation in network profile

Hello Everyone,

Today, I am writing this post for the issue which I encountered after bulk import of Virtual machine into vRealize Automation 7.6 version.

I saw the behaviour that imported virtual machine IP address is not showing allocated in Network profile section.

Due to this IP address allocation not updated in network profile, vRA allocates that same IP to another VM during the VM deployment via vRA. This is default behaviour of vRA because as per the vRA inventory that particular IP is not allocated to any VM.

But when I raised a VM provision request via vRA, it got stucked on customise the virtual machine because it detects that the IP is already in use on the network so my VM request got failed after 2 hrs. time out period.

Now, below are the steps to update the IP address for the registered VMs into vRA via IAAS SQL database so that IP address allocated in network profile and vRA come know about that IP address as well.

 

1.      Login to your IAAS SQL server.

2.      Open the SQL server management studio with SA account or any other account which should have full access on vRA database.

3.      Run below search query to find out the details about that IP address.

                  select * from StaticIPv4Address where IPv4Address ='172.16.10.90'

4.      You will get below details about this IP address.

 

 

5.      So in above pictures, you can see Virtual Machine ID is NULL , and StaticIPv4AddressState value is 1, this means IP is not allocated to any VM by vRA.

6.      Now, we need to update Virtual Machine ID, IP address and StaticIPv4AddressState to “0” via IAAS SQL database update command as shown below.

 

UPDATE StaticIPv4Address SET VirtualMachineID  = '962982F5-06DD-4EF8-B03B-F173742D1028', StaticIPv4AddressState = '0' WHERE IPv4Address = '172.16.10.90'

 

7.      Now, VM ID and IPv4 address details updated as shown below

 

 

8.      So, if you check in vRA under Network profile section, you will see that above IP has been allocated to the respective VM.

 

That’s all for this post, hope this will informative to everyone, Cheers…..!!!!