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 [Server].[ProcInst]
SET [Status]='4' WHERE [ProcInstID]='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