Remove old process engine records

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Currently, BPM 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

Component : CA PPM BUSINESS PROCESS MANAGEMENT

Resolution

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