Processes are not running or take a long time to run. "Missmatched Pas Conditions" error

Products

• Clarity PPM SaaS

Issue/Introduction

Production processes have not been running for over an hour.  This is affecting production data to be updated correctly.  

Cause

Corrupted data in the BPM_PROCESSES table where process_engine_id is NULL

Resolution

Please reference defect DE57433 which is to provide the process engine logic to better handle this error condition.
To look for the bad data to clear, run the following query:

-- For SaaS, please open a support case so Support can review and advise
SELECT * FROM
BPM_RUN_PROCESSES
where process_engine_id is null
AND STATUS_CODE NOT IN ('BPM_PIS_DONE', 'BPM_PIS_ABORTED');

To correct the issue, remove this bad data:
-- Please have your DBA or Broadcom backup this table prior
-- For SaaS, please open a support case so Support can review and advise

DELETE FROM
BPM_RUN_PROCESSES
where process_engine_id is null
AND STATUS_CODE NOT IN ('BPM_PIS_DONE', 'BPM_PIS_ABORTED');

 

After clearing the orphan data, a BG restart is required