Question

2
Replies
266
Views
PonnurangamN2827 Member since 2019 43 posts
Vodafone
Posted: July 9, 2019
Last activity: July 14, 2019
Closed

Observed PEGA0004 alert for OOTB activity

Hi Team,

we are observing PEGA0004 alerts for the ootb activity SendEmailsInBulkChild in production . Please find below stack trace.

2019-07-09 15:47:36,488 GMT*8*PEGA0004*50037544*50000000*ddf-10.160.8.17*NA*NA*B0B5AO3QQ4OA0TZITFK78CEP9NGT3SRMI*none*PegaMKT-Work*A*0bc0a23e2f67ede142c7a842cd6b2e97*N*1*B0B5AO3QQ4OA0TZITFK78CEP9NGT3SRMI*1972*[ACTIVE] ExecuteThread: '25' for queue: 'weblogic.kernel.Default (self-tuning)'*STANDARD*com.pega.pegarules.data.internal.access.DatabaseImpl*NA*System-Queue-SendEmail.SendEmailsInBulkChild*Rule-Obj-Activity:SendEmailsInBulkChild*PEGAMKT-WORK-OFFER SETUPCUSTOMEMAILHEADERS #20190204T171918.664 GMT Step: 11 Circum: 0*NA*****pxInteractions=1;pxTotalReqCPU=2.28;pxRunModelCount=1,926;pxRulesUsed=2,569;pxRulesExecuted=2,569;pxOtherCount=644;pxOtherIOElapsed=2.37;pxDBInputBytes=50,037,544;pxTotalReqTime=141.24;pxActivityCount=643;pxOtherIOCount=643;pxAlertCount=1;pxOtherFromCacheCount=1;*Code-Pega-Child*NA*Code-Pega-Child*NA*Java;RULE-OBJ-ACTIVITY SYSTEM-QUEUE-SENDEMAIL SENDEMAILSINBULKCHILD #20190311T151652.568 GMT Step: 1 Circum: 0;doActivity Rule-Obj-Activity:SendEmailsInBulkChild;initial Executable;0 additional frames in stack;*OfferClassName=Data-BatchOutPR185;MaxRetryAttempts=3;AccountPage=page "<unnamed>" of class "Data-EmailAccount", 2/67 props expandedexpanded properties: -pxCommitDateTime EQUALS "20190709T061209.000 GMT" -SMTPNameValueList;JdbcDataSource=java:comp/env/jdbc/PegaRULES;DBType=Oracle;*The number of database bytes input for this interaction has exceeded the WARNING level for Requestor B0B5AO3QQ4OA0TZITFK78CEP9NGT3SRMI, operator Maximum bytes: 50000000 Actual bytes: 50037544*

step 11 of SetupCustomEmailHeaders is setting static email during which this issue is been observed

Followed the link https://community.pega.com/knowledgebase/articles/pega0004-alert-quantity-data-received-database-query-exceeds-limit wherein it recommended number of solutions.

Exposing pagelist would be the good solution in this case? Please recommend.

System Administration
Moderation Team has archived post
Share this page LinkedIn