Remove old process engine records

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Currently, Clarity does not provide Admin screens or background jobs to remove outdated and unused Process Engine and Process Engine Run records. How can these records be removed?

Environment

All Supported Clarity Releases

Resolution

Note:

• The old process engines records are kept for historical purposes and removing them may leave old completed processes with orphaned references to old process engines.
• Only complete this if you have also done a cleanup of Clarity processes in the system

1. Run below command to delete the unused records

Oracle:

SELECT *
FROM BPM_RUN_PROCESS_ENGINES
WHERE END_DATE != NULL
    OR END_DATE <= SYSDATE;

DELETE
FROM BPM_RUN_PROCESS_ENGINES
WHERE END_DATE != NULL
    OR END_DATE <= SYSDATE;

MS SQL Server:

SELECT * BPM_RUN_PROCESS_ENGINES
WHERE END_DATE != NULL
    OR END_DATE <= getdate();

DELETE
FROM BPM_RUN_PROCESS_ENGINES
WHERE END_DATE != NULL
    OR END_DATE <= getdate();

2. Restart BG services

Additional Information

Please also see some recommended Clarity Housekeeping activities:

• Clarity Housekeeping Activities