Snapshot operations in VMware vRealize Automation appear to be stuck

Products

• VMware Aria Suite

Issue/Introduction

Symptoms:

• Items tab in the vRealize Automation appliance reports snapshot operations in progress even when there are no snapshot operations performed.
• In the Items tab, you see the message:
  
  Snapshot operation in progress...

Environment

VMware vCloud Automation Center for Server 6.1.x
VMware vCloud Automation Center for Desktop 6.0.x
VMware vCloud Automation Center for Server 6.0.x
VMware vCloud Automation Center for Desktop 6.1.x
VMware vRealize Automation 6.2.x

Resolution

To resolve this issue, identify and remove the snapshot operations that appear to be in progress.

To identify and remove the snapshot operation:

Note: This procedure modifies the database. Ensure to take a backup of the database before proceeding.

1. Stop all DEM worker services.
2. Access the IaaS database using the Microsoft SQL Management Studio.
3. Run this SQL statement to view the [dbo].[WorkflowOperations] table entries:
   
   Select * from [dbo].[WorkflowOperations]
   
   If there are more than one workflow operation, identify the appropriate WorkflowOperation_Id in the [dbo].[WorkflowOperationArguments].
   
   For example:
   
   
   • If you can identify the virtual machine UUID from the [dbo].[VirtualMachine] table, run this SQL statement to replace VM_UUID with the appropriate UUID
     
     Select * from [dbo].[WorkflowOperationArguments] where Name = 'VirtualMachineID' and Value = ' VM_UUID'
     
     
   • If you know the name of the snapshot, run this SQL statement to replace the old snapshot with new snapshot
     
     Select * from [dbo].[WorkflowOperationArguments] where (Name = 'SnapshotName' or Name = 'NewSnapshotName') and Value Like 'SnapshotTest%
     
     
4. After identifying the Workflow Operation, delete the Workflow Operation entry by running this SQL statement:
   
   Delete from [dbo].[WorkflowOperations] where Id = WorkflowOperationId
   
   Where WorkflowOperationId is the workflow operation ID noted in Step 3.
   
   
5. If the previous statement works properly, remove WorkflowOperationArguments and replace the WorkflowOperationId with the appropriate Workflow Operation ID by running this SQL statement:
   
   Delete from [dbo].[WorkflowOperationArguments] where WorkflowOperation_Id = WorkflowOperationId
   
   Where WorkflowOperationId is the workflow operation ID noted in Step 3.
   
   
6. Review the item in the UI and validate that the message has cleared.
7. Restart the DEM worker services.