Question
Valaris PLC
US
Last activity: 10 Feb 2022 21:48 EST
High number of PEGA0005 during PZASSEMBLEPREPROCESS on pr_sys_app tables causing performance issues in production
High number of PEGA0005 during PZASSEMBLEPREPROCESS on pr_sys_app tables causing performance issues in production.
We are on 8.1.4. No code changes were made to the prod system, but this issue started few days back. We have restarted the jvm couple of times, but it doesn't help. The PEGA0005 is also leading to huge number of PEGA0037 as well.
We believe the issue could be due to the fact that the Rule assembly is being called more frequently for every click, which ideally should not happen. We are trying to run the "Static Assembler" from the dev studio. Is there any thing else we should check or try to fix the issue?
Accepted Solution
Updated: 10 Feb 2022 21:48 EST
Valaris PLC
US
We were able to identify the problem. It was due to the fact that some of the out of the box db tables (like the below ones) were missing indexes. We added the missing indexes and then saw a decline in the number of PEGA0005 alerts. System performance also improved.
pr_sys_appcache_dep
pr4_rule_vw
pr_sys_app_hierarchy_flat
pr_sys_app_ruleset_index
pr_sys_class_ancestors