ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Processes stuck in Aborting status for long time

book

Article ID: 145176

calendar_today

Updated On:

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.