ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Clarity: How can I remove old Process Engine records?
Article ID: 143703
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.
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
Feedback
Yes
No
Powered by
