Clarity: How can I remove old Process Engine records?
book
Article ID: 143703
calendar_today
Updated On:
Products
Clarity PPM On PremiseClarity 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: