Support Article
Pega005 Alerts for Pega OOTB query
SA-37493
Summary
There is very high Relational Database Service cpu utilization observed which has led to poor performance of the system.
The DB is getting continuous queries even when the system is not in use. If those sessions are killed, it again triggers the query.
Error Messages
Not Applicable
Steps to Reproduce
Not Applicable
Root Cause
The query shown below is executing continuously:
With app_rulesets(pzRuleSetName) as (SELECT "PC0AR"."pzRuleSetName" AS "pzrulesetname" FROM ( SELECT "PC0AR".pzRuleSetName AS "pzRuleSetName" FROM pegarules.pr_sys_app_hierarchy_flat "PC0A
H" INNER JOIN pegarules.pr_sys_app_ruleset_index "PC0AR" ON ( ( "PC0AH".pzAppHash = "PC0AR".pzAppHash ) ) WHERE ( "PC0AH".pzTopAppHash = $1 ) ) "PC0AR" ) ,app_classes(pxClassName) as (SE
LECT DISTINCT "CA1".pxClassName AS "pxclassname" FROM pegarules.pr_sys_class_ancestors "CA1" INNER JOIN pegarules.pr_sys_class_ancestors "CA2" ON ( ( "CA1".pxHeight <= "CA2".pxHeight AND "C
A1".pxHashKey = "CA2".pxHashKey ) ) WHERE ( "CA1".pxHashKey IN (SELECT "PC0CA".pxHashKey AS "field1" FROM pegarules.pr_sys_class_ancestors "PC0CA" WHERE ( "PC0CA".pxClassName = $2 ) ) AN
D "CA2".pxClassName = $3 ) ) SELECT "AC".pxClassName AS "pxClassName" FROM pegarules.pr4_base "r" INNER JOIN app_classes "AC" ON ( ( "r".pyClassName = "AC".pxClassName ) ) INNER JOIN ap
p_rulesets "AR" ON ( ( "r".pyRuleSet = "AR".pzRuleSetName ) )
Resolution
Apply HFix-34234 to resolve the issue.
Published May 8, 2017 - 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.