Symptoms

Client had 4 workflow instances that kept running and caused performance issues on their environment.

They tried stopping the workflows using the Workspace and powershell but that didnt work,

 

Diagnoses

We found that the processes were looping and taking up a lot of resources. We remedied this however there were still processes that were stuck in looping state

 

Resolution

Using the below sql script we managed to stop the processes.

USE K2
UPDATE TServer].rProcInst]
SET EStatus]='4' WHERE RProcInstID]='12345' - "selecting the correct procinstid"
GO

After this we used the GoTo Activity to move the processes to the correct state and continue with them