Symptom

It's possible for a job in Process Engine to become stuck while executing and show both a start and end date.

Resolution

When this happens, it’s best to remove the job from the Process table of the ProcessEngine database to release the job. Open MySQL Query Browser or WorkBench and navigate to the ProcessEngine database. Find the job by searching the table where the name matches the name of the hung process:

SELECT * FROM PROCESS WHERE NAME = “Name of hung process”;

Ensure this returns one result and the status is 2. Then simply change it from a select statement to a delete statement:

DELETE FROM PROCESS WHERE NAME = “Name of hung process”;

If you see multiple rows appear, find the process ID of the row with 2 as the status, then modify the select statement to return this row:

SELECT * FROM PROCESS WHERE ID = “ID of hung process”;

Ensure the correct row is returned from the search and then change to a delete statement:

DELETE FROM PROCESS WHERE ID = “ID of hung process”;

After each deletion from the process table, go back to Process Engine manager and ensure the hung process has been removed. It may take Process Engine a few minutes to clear the licences used by the process.