Support Article
Unable to delete pr_sys_statusdetails table entries
SA-23067
Summary
Records in the pr_sys_statusdetails table do not get deleted as expected by the SystemCleaner agent. This leads to a build-up of records in the table, which results in poor performance.
Error Messages
Not Applicable
Steps to Reproduce
Observe count(*) of pr_sys_statusdetails over time.
Root Cause
A defect in the way the System Cleaner agent uses Obj-Open-By-Handle. It does not delete entries in the pr_sys_statusdetails table.
Resolution
Apply HFix-27410 for Pega 7.1.9. The issue is natively fixed in Pega 7.2.
Published May 14, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.