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.