Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Low performance alerts display for pzWarningsIntroduced report

SA-71917

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

Suggest Edit

Published February 21, 2019 - Updated December 2, 2021

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us