Ensure there are valid backups of the vRealize Automation database as the below instructions edit the database. In memory snapshots are not an efficient backup solution. Utilize one of the following: snapshot from a fully shutdown state or 3rd party solutions that may backup the VMDK.
- The IDs of stuck workflows can be retrieved via:
SELECT * FROM o11n_workflowrunstate
WHERE executionstate='running';
- Isolate the faulty records:
SELECT * from o11n_workflowrunstate WHERE id IN ('ExecutionIDFromLogs','ExecutionIDFromLogs','ExecutionIDFromLogs');
- Delete the offending records found from the above queries and logs:
DELETE from o11n_workflowrunstate WHERE id IN ('ExecutionIDFromLogs','ExecutionIDFromLogs','ExecutionIDFromLogs');