Symptoms
Processes Stuck In Running
Diagnoses
When you have two processes stuck in running and go into the management console to try to stop or remove this processes you just get the spinning wheel for a long time and nothing happens to the processes.
How do you remove the processes stuck in a running state ?
Resolution
Please execute the following against your DB under the Proc.Inst table.
Stop the K2 Service
2. Identify the running instances
Status = 1 (Running)
Status = 4 (Stopped)
Consolidated DB = SELECT * FROM [K2].[Server].[ProcInst] where Status = 1
Multiple DB's = SELECT * FROM [K2Server].[dbo].[_ProcInst] where Status = 1
3. Identify the instance by start time or Folio and change the status to 4 to stop it:
Consolidated DB = Update [K2].[Server].[ProcInst] set status= 10 where ID = 1234 and ProcID =1234
Multiple DB's = Update [K2Server].[dbo].[_ProcInst] set status= 10 where ID = 1234 and ProcID =1234
4. Start the K2 Service.
After this you should be able to remove the instances within workspace.
The best thing to do here would be contact K2 support to carry this out in any case.