How to cleanup processes in Aborting State

Document ID : KB000071773
Last Modified Date : 23/02/2018
Show Technical Document Details
Issue:

Occasionally you will find processes stuck in the aborting status that do not move to 'ABORTED'. This makes it not possible for the Delete Process Instance job to pick up.

Environment:

 
Resolution:
Before proceeding to clear up 'stuck' processes, allow some time to see if the 'ABORTING' processes move to 'ABORTED' as expected. If you have many processes in the queue that could take some time.lease follow these steps:

Change status of the process instances "stuck" in the Aborting status: (query for a record count, then update if needed)


1. To check the amount of records run the select statement:
-----------------------------------------------

SELECT COUNT(*) aborting_count FROM bpm_run_processes
WHERE  status_code = 'BPM_PIS_ABORTING'
 -----------------------------------------------
2. To correct the issue run the update statement:

UPDATE bpm_run_processes
SET    status_code = 'BPM_PIS_ABORTED'
WHERE  status_code = 'BPM_PIS_ABORTING'
Same amount of records as in step 1 should be updated.

Commit;

3. Run Delete Process Instance job to remove of the Aborted instances when needed.