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?
***Edited by Moderator Marissa to change Content Type from Discussion to Question; post type from General to Product, added Product details and Capability tags****
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.