Question
Vodafone
IN
Last activity: 10 Jan 2020 10:23 EST
multiple PEGA0035 and PEGA0045 alerts on OOTB marketing activity
We are observing multiple entries of PEGA0035 and PEGA0042 alerts in prod environment.
I could not find pzAutoPopulateNamedPageLinks in designer studio. Please suggest clue on fixing this alert.
We are observing multiple entries of PEGA0035 and PEGA0042 alerts in prod environment.
I could not find pzAutoPopulateNamedPageLinks in designer studio. Please suggest clue on fixing this alert.
2020-01-09 11:18:52,253 GMT*8*PEGA0042*1303*1000*ddf- Proprietary information hidden*NA*NA*BM4PU7MVYAB1Y1ZW58GG7X39B4QH4QJI6*System*********-Work*AoM:01.02.01*584399fc5c36f588d41c500d77ab6805*N*4*BM4PU7MVYAB1Y1ZW58GG7X39B4QH4QJI6*1134*[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'*STANDARD*com.pega.pegarules.data.internal.store.AutoCommitTransaction*NA*System-Queue-ProgramEvents.ProcessEventRun*Rule-Obj-Activity:EstablishContext*SYSTEM-QUEUE-PROGRAMEVENTS EXECUTEEVENTRUN #20170608T103534.035 GMT Step: 3 Circum: 0*NA*****pxRDBIOElapsed=0.22;pxListWithUnfilteredStreamCount=4;pxRDBIOCount=20;pxTotalReqCPU=5.49;pxRunModelCount=144;pxRunWhenCount=18;pxRulesExecuted=580;pxListRowWithUnfilteredStreamCount=4;pxOtherCount=16;pxDBInputBytes=52,219,356;pxTotalReqTime=5.85;pxActivityCount=46;pxAlertCount=8;pxOtherFromCacheCount=9;pxRDBWithoutStreamCount=35;pxCommitCount=3;pxOtherBrowseElapsed=0.01;pxInteractions=4;pxRulesUsed=9,028;pxOtherIOElapsed=5.29;pxRuleBrowseElapsed=0.01;pxTrackedPropertyChangesCount=9;pxDBOutputBytes=15,444;pxRDBRowWithoutStreamCount=2,169;pxOtherIOCount=13;*System-Queue-ProgramEvents*NA*NA*NA*Obj-Open-By-Handle;RULE-OBJ-ACTIVITY SYSTEM-QUEUE-PROGRAMEVENTS EXECUTEEVENTRUN #20170608T103534.035 GMT Step: 3 Circum: 0;doActivity Rule-Obj-Activity:ExecuteEventRun;Call ExecuteEventRun;RULE-OBJ-ACTIVITY SYSTEM-QUEUE-PROGRAMEVENTS PROCESSEVENTRUN #20160219T222431.072 GMT Step: 1 Circum: 0;2 additional frames in stack;*pyTempPlaceHolder=TempPlaceHolder;ProgramInsKey=PEGAMKT-WORK P-3;*Packaging of database query took more than threshold of 1,000 ms: 1,303 ms SQL: select pzPVStream from PEGADATA.MKT_WORK where pzInsKey = ?*
2020-01-09 11:18:52,524 GMT*8*PEGA0035*10001*10000*ddf- Proprietary information hidden*NA*NA*BM4PU7MVYAB1Y1ZW58GG7X39B4QH4QJI6*System**************AoM:01.02.01*584399fc5c36f588d41c500d77ab6805*N*5*BM4PU7MVYAB1Y1ZW58GG7X39B4QH4QJI6*1135*[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'*STANDARD*com.pega.pegarules.data.internal.clipboard.ClipboardPropertyImpl*NA*System-Queue-ProgramEvents.ProcessEventRun*Rule-Obj-Activity:EstablishContext*SYSTEM-QUEUE-PROGRAMEVENTS EXECUTEEVENTRUN #20170608T103534.035 GMT Step: 3 Circum: 0*NA*****pxRDBIOElapsed=0.25;pxListWithUnfilteredStreamCount=5;pxRDBIOCount=26;pxTotalReqCPU=5.65;pxRunModelCount=215;pxRunWhenCount=25;pxParseRuleCount=2;pxRulesExecuted=799;pxListRowWithUnfilteredStreamCount=5;pxOtherCount=21;pxDBInputBytes=65,281,516;pxTotalReqTime=6.13;pxActivityCount=63;pxAlertCount=9;pxOtherFromCacheCount=14;pxRDBWithoutStreamCount=46;pxCommitCount=4;pxOtherBrowseElapsed=0.01;pxInteractions=5;pxRuleCount=2;pxRulesUsed=12,076;pxRuleFromCacheCount=2;pxOtherIOElapsed=5.41;pxRuleBrowseElapsed=0.01;pxTrackedPropertyChangesCount=12;pxDBOutputBytes=29,248;pxRDBRowWithoutStreamCount=2,318;pxOtherIOCount=18;*System-Queue-ProgramEvents*NA*NA*NA*Obj-Open-By-Handle;RULE-OBJ-ACTIVITY SYSTEM-QUEUE-PROGRAMEVENTS EXECUTEEVENTRUN #20170608T103534.035 GMT Step: 3 Circum: 0;doActivity Rule-Obj-Activity:ExecuteEventRun;Call ExecuteEventRun;RULE-OBJ-ACTIVITY SYSTEM-QUEUE-PROGRAMEVENTS PROCESSEVENTRUN #20160219T222431.072 GMT Step: 1 Circum: 0;2 additional frames in stack;*pyTempPlaceHolder=TempPlaceHolder;ProgramInsKey=PEGAMKT-WORK P-3;*The number of elements in this clipboard list property has exceeded WARN level. Maximum size: 10000 Property reference: .pzAutoPopulateNamedPageLinks*
Pegasystems Inc.
US
For Pega0035, the default count of elements allowed in a PageList property is 10000 and if it reached that you would see this WARN alert.
Understand the Pega0035 alert item by looking at the process invoked this alert and if it's valid or expected to have more than 10000, try increasing the count to a higher number or explore other options as specified in the below article.
Give a read on the causes and https://community.pega.com/knowledgebase/articles/pega0035-alert-page-list-property-has-number-elements-exceed-threshold
PEGA0042 indicates that packaging time for a single database query exceeds the threshold setting. Packaging time is defined as the time elapsed from the execution of a query until the last row of the result is returned to the Pega 7 Platform engine.
Inspect the SQL included in this alert and relate with other alerts as described in the below PEGA0042 article. However, this shouldn't be a problem as the threshold is set to 1000 ms (1sec) and query result took 1303 ms (1.3 sec)