Unable to Remove or Delete Process Instance In Inactive/Not Started State

Products

• Clarity PPM SaaS

Issue/Introduction

Unable to delete process instance from Administration > Data Administration > Processes > Initiated page:

It can be neither cancelled or deleted. 
The following process instances cannot be deleted because either you do not have permission or their status is not yet done or cancelled

 

Environment

Release : All

 

Resolution

The status 'Not Started' or in the Gray status means it is in the inactive state.
Run the following SQL statement:

update bpm_run_processes
set status_code = 'BPM_PIS_ABORTED'
WHERE status_code = 'BPM_PIS_INACTIVE';
COMMIT;