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

GETHIERARCHICALREPORTEES results in recursive SQL

SA-72196

Summary



The GETHIERARCHICALREPORTEES method results in a recursive SQL statement being run which uses the Relational Database Service (RDS) storage. The RDS is used due to the creation of temporary files. Additionally, the method has MAXRECORDS set to null.


Error Messages



Example Alert

*8*PEGA0005*90091*500*Node*NA*NA*HAWFRMO226Z3IWXRA3WMC448VOJQR6MSS*User*ABC-FW-MEFW-Work*ME:01.01.02*c5dfebe05b4f1e8a6cf7b1c8692c310f*Y*45*HAWFRMO226Z3IWXRA3WMC448VOJQR6MSS*2442*http-apr-8080-exec-945*PS1__TABTHREAD0*com.pega.pegarules.data.internal.store.DataStorePreparedStatement*ABC-dt1-internal.pegacloud.io|ip-address*[email protected]*Rule-Obj-Activity:ApplicationSetup*CODE-PEGA-LIST GETHIERARCHICALREPORTEESFORRD
Step: 2 Circum:*NA* * * * *pxRunModelCount=12;pxDeclarativePageLoad

Elapsed=0.14;pxRulesExecuted=390;pxJavaGenerateCount=5;pxJavaGenerateElapsed=0.03;pxRDBRowWithStreamCount=14;pxDBInputBytes=707,892;pxAlertCount=1;pxDeclarativeRulesLookupCount=165;pxInputBytes=363

;pxDeclarativeRulesInvokedElapsed=0.00;pxRuleIOElapsed=0.02;pxDeclarativePageLoadCount=6;pxJavaAssembleHLElapsed=0.20;pxDeclarativeRulesLookupElapsed=0.02;pxProceduralRuleReadCount=16;pxRuleFromCac

heCount=59;pxDBOutputBytes=5,597;pxRDBRowWithoutStreamCount=35;pxJavaCompileCount=5;pxRDBIOElapsed=90.16;pxDeclExprCtxFreeUseCount=25;pxRDBIOCount=32;pxJavaAssembleCount=5;pxRunStreamCount=18;pxTot

alReqCPU=0.48;pxRunWhenCount=214;pxOtherCount=47;pxTotalReqTime=90.88;pxActivityCount=90;pxOtherFromCacheCount=61;pxRDBWithoutStreamCount=5;pxRunOtherRuleCount=1;pxJavaAssembleElapsed=0.00;pxDeclar

ativeRulesInvokedCount=28;pxInteractions=1;pxLegacyRuleAPIUsedCount=13;pxRuleCount=49;pxJavaCompileElapsed=0.14;pxRulesUsed=1,616;pxFUACacheDBLoadElapsed=0.00;pxRDBWithStreamCount=14;pxOtherIOElaps

ed=0.07;pxRuleBrowseElapsed=0.00;pxTrackedPropertyChangesCount=20;pxDeclarativeRuleReadCount=6;pxDeclarativeNtwksBuildHLElapsed=0.03;pxOtherIOCount=19;pxDeclarativeNtwksBuildConstElapsed=0.01;*Code

-Pega-List*D_CampaignSuccessByStage*Data-Admin-Operator-ID*OpQueryPage*RDB-List;RULE-OBJ-ACTIVITY CODE-PEGA-LIST GETHIERARCHICALREPORTEESFORRD Step: 2 Circum: 0;doActivity

Rule-Obj-Activity:getHierarchicalReporteesForRD;Call getHierarchicalReporteesForRD;RULE-OBJ-ACTIVITY CODE-PEGA-LIST CRMCAMPAIGNSUCCESSSUMMARY Step: 2 Circum: 0;28 additiona

l frames in stack;*HierarchicalTempPage=tempReporteesCampaignSuccess;Operator=User;pxObjClass=;DBType=postgres;pyTempPlaceHolder=TempPlaceHolder;*Database operation took more than the thresh

old of 500 ms: 90,091 ms.


Steps to Reproduce



Unknown


Root Cause



A defect in Pegasystems’ code or rules.
An RDB-List method was used. This method is deprecated and cannot be used on Cloud.



Resolution



Apply HFix-49174.

Published March 24, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

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

Did you find this content helpful?

Want to help us improve this content?

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