High number of PEGA0005 during PZASSEMBLEPREPROCESS on pr_sys_app tables causing performance issues in production

General
, ,
1

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?

2

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