Question

2
Replies
287
Views
Ponnurangam Nagaraj (PonnurangamN2827)
Vodafone

Vodafone
IN
PonnurangamN2827 Member since 2019 43 posts
Vodafone
Posted: July 9, 2019
Last activity: July 14, 2019
Posted: 9 Jul 2019 18:46 EDT
Last activity: 14 Jul 2019 8:22 EDT
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.

Show More

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.

Show Less
System Administration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.