Virtual machine reconfigure request hangs in "Reconfiguring" state indefinitely in vRealize Automation
search cancel

Virtual machine reconfigure request hangs in "Reconfiguring" state indefinitely in vRealize Automation

book

Article ID: 319617

calendar_today

Updated On:

Products

VMware Aria Suite

Issue/Introduction

Symptoms:
  • After requesting a reconfigure action against a provisioned virtual machine, the Infrastructure-as-a-Service inventory item is unresponsive within the "Reconfigure" state.
  • When reviewing the Audit Log for the request, the primary workflow state of the virtual machine is stuck at "Reconfigure virtual machine"
  • Attempting to reconfigure a machine in vRealize Automation fails the error:

    A reconfigure operation for this machine is already in progress.
    Status: ON Reconfigure failed, waiting to retry


Environment

VMware vRealize Automation 6.x
VMware vRealize Automation 7.x

Cause

This issue occurs when the initial reconfigure request is not successful.

Resolution

Currently, there is no resolution.

Workaround:
To workaround this issue, remove the item from the Reconfiguring state by updating SQL database against the item.
 
Note! Before making any changes to the SQL database, ensure to take a full backup.
 
To update all VMs which are stuck in a Reconfiguring state in vRealize Automation 6.x and 7.x:
  1. Connect to the vRealize Automation IaaS SQL Database using SQL Management Studio.
  2. Download the 71246_usp_CleanVirtualMachineReconfigure.zip file and install the usp_CleanVirtualMachineReconfigure.sql in the  IAAS SQL Server database
    1. Open SQL Server Management Studio and login as VCAC/vRA database owner;
    2. Go to Object Explorer > Databases > Select VCAC/vRA database.
    3. Click File > Open > File and select usp_CleanVirtualMachineReconfigure file on query window.
    4. Click Execute or  press the F5 key to install the stored procedure on VCAC database.

      You see the "Command(s) completed successfully." message after the stored procedure is created within the vRA IaaS database.
  1. Execute the stored procedure: usp_CleanVirtualMachineReconfigure with the VMname as parameter.
     
    1. Go to Object Explorer > VCAC database > Programmability > Stored Procedures to list all stored procedures in vRA IaaS database.
    2. Right-click on the usp_CleanVirtualMachineReconfigure stored procedure and select Execute Stored Procedure.
    3. In the Execute Procedure window, input the virtual machine name in the Value column of VirtualMachineName parameter.

      For example, EXEC [dbo].[usp_CleanVirtualMachineReconfigure] 'VirtualMachineName'
    4. Click OK to execute the procedure. 
  2. Go to UI under Items tab for the VM and cancel the Reconfigure request.


Additional Information

  • If a reconfigure request continues to fail, run this query in the IAAS SQL database:

    update VirtualMachine set CurrentTask = NULL where VirtualMachineName = 'Affected-machine-name'
  • If reconfigure request continue to fail with the error "A reconfigure operation for this machine is already in progress.":
  1. Confirm there is a stuck request by running this query:

    select * from StateOperationVirtualMachines where VirtualMachineId IN (select VirtualMachineID from VirtualMachine where VirtualMachineName = 'Affected-machine-name')
  1. Delete the record:

    delete from StateOperationVirtualMachines where VirtualMachineId IN (select VirtualMachineID from VirtualMachine where VirtualMachineName = 'Affected-machine-name')
  1. Reconfigure the affected machine, to confirm issue is no longer present.

If reconfigure request continue to fail, clean up the request stuck In Progress. For more information, see Requests get stuck at 'In Progress' or 'Pending Approval' status in vRA (2114385).

Attachments

71246_usp_CleanVirtualMachineReconfigure get_app
Powered by Wolken Software