Question

WellsFargo
IN
Last activity: 4 Jan 2023 9:17 EST
Importance of pxOtherBrowserElapsed Time in Pega00005 Alert
Hi there,
I see a lot of Pega00005 alerts in production. When analyzed the alert I don't see any issue with the database query but I see a field pxOtherBrowserElapsed field elapsed time is consuming 95 of the total elapsed time.
Could someone explain me the importance of the pxOtherBrowserElapsed field?
Appreciate if anyone can help me to understand the field. Below is the alert detail
Hi there,
I see a lot of Pega00005 alerts in production. When analyzed the alert I don't see any issue with the database query but I see a field pxOtherBrowserElapsed field elapsed time is consuming 95 of the total elapsed time.
Could someone explain me the importance of the pxOtherBrowserElapsed field?
Appreciate if anyone can help me to understand the field. Below is the alert detail
2022-12-14 15:06:17,373 GMT*8*PEGA0005*125934*500*1e9b01641e40417adc0fd7c2c828689c*NA*NA*HBFF88FYP109AQLQCC0P4JV7WA3QDRJ7H*SandY02*AACCheckSA-Work*AACAdjustments:19.05.01*63eceb5908bd4f198a6c472e022ec8ab*N*4159*HBFF88FYP109AQLQCC0P4JV7WA3QDRJ7H*4446*WebContainer : 5*TABTHREAD0*com.pega.pegarules.data.internal.store.DataStorePreparedStatement*cstar.wellsfargo.com|lb165mnsvdc-fj.wellsfargo.com*Activity=FinishAssignment*Rule-Obj-Activity:FinishAssignment*AACCHECKSA-WORK-POSTEDTWICE FINSETOFFSETCLASSES #20181215T160318.485 GMT Step: 1 Circum: 0*643*****pxRDBIOElapsed=0.12;pxRDBIOCount=33;pxRunStreamCount=26;pxTotalReqCPU=0.80;pxRunModelCount=92;pxRunWhenCount=236;pxDeclarativePageLoadElapsed=0.01;pxConnectClientResponseElapsed=8.61;pxRulesExecuted=1,068;pxOtherCount=263;pxDBInputBytes=23,140;pxTotalReqTime=138.34;pxActivityCount=341;pxAlertCount=2;pxOtherFromCacheCount=550;pxRDBWithoutStreamCount=24;pxFlowCount=21;pxRunOtherRuleCount=21;pxOtherBrowseElapsed=125.93;pxConnectElapsed=8.79;pxDeclarativeRulesInvokedCount=131;pxInteractions=1;pxLegacyRuleAPIUsedCount=10;pxRuleCount=302;pxInputBytes=1,447;pxConnectCount=24;pxDeclarativeRulesInvokedElapsed=0.03;pxRuleIOElapsed=0.02;pxRulesUsed=1,861;pxDeclarativePageLoadCount=2;pxProceduralRuleReadCount=2;pxRuleFromCacheCount=308;pxOtherIOElapsed=0.21;pxRuleBrowseElapsed=0.00;pxTrackedPropertyChangesCount=543;pxDBOutputBytes=356,292;pxRDBRowWithoutStreamCount=29;pxOtherIOCount=61;pxConnectOutMapReqElapsed=0.01;pxConnectInMapReqElapsed=0.11;*AACCheckSA-Work-PostedTwice*pyWorkPage*AACCheckSA-Work-PostedTwice*pyWorkPage*Java;RULE-OBJ-ACTIVITY AACCHECKSA-WORK FINSEARCHFINANCIALOFFSETS #20210323T212719.641 GMT Step: 9 Circum: 0;doActivity Rule-Obj-Activity:FinSearchFinancialOffsets;doActivity Rule-Obj-Flow;doActivity Rule-Obj-Flow;12 additional frames in stack;*OutputPageClass=[removed];OutstandingBalanceRange=[removed];StepSLA=[removed];pyDeferCommit=[removed];Index=[removed];WorkDateRange=[removed];ReferencePageName=[removed];pyIterationType=[removed];RTN=[removed];ReferenceInsName=[removed];pyIterationTarget=[removed];TimeFlowStarted=[removed];pyDraftMode=[removed];CreateProblemFlow=[removed];pyStatus=[removed];OnlyCreateOutputPageIfError=[removed];ReferenceInsKey=[removed];pyParentFlowPath=[removed];pyTopLevelFlow=[removed];ScoreRuleName=[removed];Threshold=[removed];WorkType=[removed];IsInvestigative=[removed];pyNextAssignment=[removed];MaxResults=[removed];FlowHasEnded=[removed];pyDeferErrors=[removed];InterestPage=[removed];flowName=[removed];pyTempPlaceHolder=TempPlaceHolder;pyStageID=[removed];InterestPageClass=[removed];pyStageLabel=[removed];ReferenceClass=[removed];TaskName=[removed];pyConfirmHarness=[removed];pzRowIndex=[removed];FlowType=AACCheckSA-Work-PostedTwice;pyHowInvoked=[removed];HistoryOperator=[removed];OutputPageName=[removed];pyForEachCount=471;flowType=OffsetSearch;*Database operation took more than the threshold of 500 ms: 125,934 ms SQL: select pzPVStream from PRPCPROD.paf_work where pzInsKey like ? and "PXOBJCLASS" in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?) and "SUSPTYPE" = ? and "SUSPCURR" = ? and "OUTBAL" > ? and "OUTBAL" >= ? and "OUTBAL" <= ? and "SUSPINFLIGHT" <> ? and "INCOMINGDUPLICATEWORKDATE" >= ? and "INCOMINGDUPLICATEWORKDATE" <= ? order by pzInsKey inserts: <AACCHECKSA-WORK %> <AACCheckSA-Work-EnclosedNotListed> <AACCheckSA-Work-FreeItem> <AACCheckSA-Work-Misc> <AACCheckSA-Work-DebitAsCredit> <AACCheckSA-Work-PostedTwice> <AACCheckSA-Work-ATM> <AACCheckSA-Work-ForeignItem> <AACCheckSA-Work-NonNegotiable> <AACCheckSA-Work-CustomerResearch> <AACCheckSA-Work-REGE> <AACCheckSA-Work-MissingCheck> <Payable> <USD> <0> <74.75> <74.75> <true> <20221125> <20221215>
Thanks,
Suman