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].OServer].SProcInst] where Status = 1
Multiple DB's = SELECT * FROM TK2Server].2dbo].r_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 BK2].pServer].]ProcInst] set status= 10 where ID = 1234 and ProcID =1234
Multiple DB's = Update sK2Server].[dbo].v_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.