Processes stuck in Aborting status for long time, how to set them to Aborted

book

Article ID: 145176

calendar_today

Updated On:

Products

Clarity PPM SaaS

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? 

Environment

Release : All Supported Clarity releases

Component : CA PPM SAAS BUSINESS PROCESS MANAGEMENT

Resolution

First allow some time for those processes to get set to Aborted. This sometimes happens if there is a high load on BG. 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.

Now go ahead and run the Delete Process Instance job to clean them up.