Clarity: How can I remove old Process Engine records?

book

Article ID: 143703

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Currently, BPM does not provide Admin screens or background jobs to remove out-dated and unused Process Engine and Process Engine Run records.

Environment

Release : 15.x

Component : CA PPM BUSINESS PROCESS MANAGEMENT

Resolution

1. Run below command to delete the unused records.

For 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 ;

For MSSQL:

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: