Processes stuck in Aborting status for long time

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Processes are stuck in Aborting status for more than one day, and they never go to Aborted. BG restart does not fix the problem. What can be done? 

Reset Aborting process to Aborted status

Environment

Release : All Supported Clarity releases

Resolution

1. First, allow some time for those processes to get set to Aborted. This sometimes happens if there is a high load on BG.
2. If after a day or more the processes are still stuck, please use the following solution:
   On the database, run the query:
   UPDATE bpm_run_processes
   SET status_code = 'BPM_PIS_ABORTED'
   WHERE  status_code ='BPM_PIS_ABORTING'
   
   commit
   
   This will set all Aborting processes to Aborted. A restart is not required.
3. Now go ahead and run the Delete Process Instance job to clean them up.