Symptoms
Running Instances
Diagnoses
We have several instances in Running State for months and we are unable to stop them via K2 Workspace. How can we stop them?
Resolution
Another way you stop a process instance is via the database. You can do this by doing the following:
1. Stop the K2 Service
2. Identify the running instances:
Status = 2 (Running) or (Active)
Status = 4 (Stopped) or (Completed)
Consolidated DB = SELECT * FROM OK2].2Server].rProcInst] where Status = 2
Multiple DB's = SELECT * FROM OK2Server].rdbo].o_ProcInst] where Status = 2
3. Identify the instance by start time or Folio and change the status to 4 to stop it:
Consolidated DB = Update tK2].2Server].rProcInst] set status= 4 where ID = 1234 and ProcID =1234
Multiple DB's = Update tK2Server].rdbo].o_ProcInst] set status= 4 where ID = 1234 and ProcID =1234
4. Start the K2 Service.
Please note: that it is advisable to do this on a dev or test environment first before directly doing this on a production environment. If done on Production or any other environment, please do take a back up of the K2 database for precautionary measures.
