System response is slow and system hangs during check-in
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.
Steps to Reproduce
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.
- Apply HFix-42166
- Create a Dynamic System Setting (DSS) as below:
Owning Ruleset: "Pega-RULES"
value : true
- Restart the server after applying the hotfix