Support Article
Generating Guardrail Report hangs DEV system
SA-17182
Summary
When attemptting to generate a Guardrail report in Pega 7.1.4, the system slows down as a long-running query is generated. Users experience performance degredation and the environment must be restarted or it will fail. The report does not respect date filters.
Error Messages
N/A
Steps to Reproduce
Access Guardrail landing page in Pega 7.1.4
Root Cause
Defect in PRPC version 714.
Resolution
Performance Improvements made from PRPC716 ("useLayerCakeSchemaChanges"): if upgrading is not an option then we advise the following local-change:
1. Run SPPR_REBUILD_INDEXES and rebuild the indexes
2. Updating the statistics of the following tables
pr_sys_app_hierarchy_flat
pr_sys_app_ruleset_index
pr4_rule_vw
pr_sys_ruleset_index
pr4_base
pr_index_warnings
3. Delete and recreate the following index pr_index_warnings_idx1
Drop index <schema name>.pr_index_warnings_idx1;
Create index pr_index_warnings_idx1 on <schema name>.pr_index_warnings (
pxReferencingRuleInsKey,
pxObjClass,
pxWarningCreatedTime,
pxWarningCreateOperator,
pxWarningSeverity
)
Published January 31, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.