Question

7
Replies
1156
Views
Nadimuthu T Member since 2014 30 posts
ANZ
Posted: 2 years ago
Last activity: 2 years 7 months ago
Closed

Database operation took more than the threshold of 500 ms: 748 ms SQL: {call PEGA_DATA.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }*

Hi, I am getting PEGA0005 alert continuously related to PZFTSINCREMENTALINDEXER agent activity . Can any one assist for this. Already modified the below changes. The FTS Intex Table have less valume Count- 30/Minute https://pdn.pega.com/support-articles/spprsysreservequeueitemb-stored-p… This is an ORACLE environment. To resolve this issue, alter the ORDER BY clause of the standard stored procedure sppr_sys_reservequeueitem_b: FROM: orderby := ' order by pzInsKey ASC'; TO: orderby := ' order by pyMinimumDateTimeForProcessing ASC'; Alert Log : 2018-01-31 13:35:12,213 GMT*8*PEGA0005*558*500*77f5104fa86a1e2d4aaee6a684d877fb*NA*NA*B30A1878FD3ADD612D286B02019BD80C6*System*PegaSample*PegaRULES:07.10*25813dd653972ff0b4095b6d606dbcbf*N*1*B30A1878FD3ADD612D286B02019BD80C6*5818*WorkManager.PEGAPWorkManager : 4*STANDARD*com.pega.pegarules.data.internal.store.DataStorePreparedStatement*NA*System-Queue-FTSIncrementalIndexer.pzFTSIncrementalIndexer*Rule-Obj-Activity:pzFTSIncrementalIndexer*SYSTEM-QUEUE-FTSINCREMENTALINDEXER PZFTSINCREMENTALINDEXER #20150626T110538.512 GMT Step: 2 Circum: 0*NA*****pxTotalReqTime=1.13;pxInteractions=1;pxAlertCount=1;pxListWithUnfilteredStreamCount=1;pxRulesUsed=1;pxListRowWithUnfilteredStreamCount=1;pxOtherIOElapsed=0.09;pxRulesExecuted=1;pxDBInputBytes=2,818;pxRDBIOCount=2;pxOtherIOCount=1;pxTotalReqCPU=0.01;pxOtherBrowseElapsed=0.13;pxActivityCount=1;pxRDBIOElapsed=0.89;*NA*NA*NA*NA*Java;RULE-OBJ-ACTIVITY SYSTEM-QUEUE-FTSINCREMENTALINDEXER PZFTSINCREMENTALINDEXER #20150626T110538.512 GMT Step: 2 Circum: 0;doActivity Rule-Obj-Activity:pzFTSIncrementalIndexer;initial Executable;0 additional frames in stack;*QueueNumber=0;pzMaxRecords=0;LockString=0 System-Queue-FTSIncrementalIndexer.pzFTSIncrementalIndexer System-Queue-FTSIncrementalIndexer;pyQueueClass=System-Queue-FTSIncrementalIndexer;*Database operation took more than the threshold of 500 ms: 558 ms SQL: {call PEGA_DATA.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }* 2018-01-31 14:00:21,708

***Updated by moderator: Lochan to add Categories***

Data Integration System Administration
Moderation Team has archived post
Share this page LinkedIn