Support Article
System response is slow and system hangs during check-in
SA-54444
Summary
Low performance of the system while responding to activities such as rule save, check-in or check-out, rule delete etc. The system hangs during check-in and branch merge.
Error Messages
Not Applicable
Steps to Reproduce
Unknown
Root Cause
A defect in Pegasystems’ code or rules. The subquery in 'DELETE FROM PEGA_RULES.pr_sys_appcache_entry...' is incorrectly optimized by the MS and SQL optimizer. This leads to timeouts and low performance of the system.
Resolution
- Apply HFix-42166
- Create a Dynamic System Setting (DSS) as below:
"racache/useForceOrderHintForInvalidationQuery"
Owning Ruleset: "Pega-RULES"
value : true
- Restart the server after applying the hotfix
Published October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.