A reconfigure operation for this machine is already in progress error while re-configuring a machine in vRA

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• Attempt to reconfigure a machine in vRealize Automation fails.
• You see the error:
• A reconfigure operation for this machine is already in progress.
• Status: ON Reconfigure failed, waiting to retry

Environment

VMware vRealize Automation 6.2.x
VMware vRealize Automation 7.1.x
VMware vRealize Automation 7.0.x
VMware vRealize Automation 7.2.x

Resolution

Currently, there is no resolution.

Workaround:

To workaround the issue, remove the pending operation request in vRealize Automation IaaS database:

 

1. Take a full backup of IaaS database.
2. Connect to IaaS database using credentials having administrator privileges.
3. Confirm there is a stuck request by running query:
   
   select * from StateOperationVirtualMachines where VirtualMachineId IN (select VirtualMachineID from VirtualMachine where VirtualMachineName = 'Affected-machine-name')
    
4. Delete the record:
   
   delete from StateOperationVirtualMachines where VirtualMachineId IN (select VirtualMachineID from VirtualMachine where VirtualMachineName = 'Affected-machine-name')
    
5. Reconfigure the affected machine, to confirm issue is no longer present.