Question

5
Replies
350
Views

PEGA0005 alerts due to {call PEGADATA.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }

Error

We are getting multiple PEGA0005 alerts due to {call PEGADATA.sppr_sys_reservequeueitem_b ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) }

Solutions attempted :

Pega suggested to change the orderby clause for this store procedurealter the ORDER BY clause of the standard stored procedure sppr_sys_reservequeueitem_b:FROM:orderby := ' order by pzInsKeyASC';TO:orderby := ' order by pyMinimumDateTimeForProcessing ASC'; .But still we are getting the same issue.