Support Article
Low performance alerts display for pzWarningsIntroduced report
Summary
Performance degradation alerts display on the Pega Diagnostic Cloud for the pzWarningsIntroduced report.
Error Messages
PDC alerts
The SQL query for the report definition Data-Rule-Summary pzWarningsIntroduced took longer than expected.
Steps to Reproduce
Unknown
Root Cause
The pzWarningsIntroduced report fetched a huge number of records.
Resolution
1. Create the below Dynamic System Setting (DSS):
Owning ruleset: Pega-Engine
Purpose: prconfig/reporting/useLayerCakeSchemaChanges/default
Value: True
2. Create an index as below:
create index pr4_rule_vw_tidx on pegarule.pr4_rule_vw
( pyRuleSet, pyClass, pzClassType, pzRulesetVersionMajor,pzRulesetVersionMinorPatch, pyRuleAvailable)
Published February 21, 2019 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.