Support Article
SPPR_SYS_RESERVEQUEUEITEM_B stored procedure does not work
SA-44394
Summary
PRQueueException occurs after installing HFix-28176 and running the SPPR_SYS_RESERVEQUEUEITEM_B stored procedure.
Error Messages
com.pega.pegarules.pub.context.PRQueueException: There was a problem getting a list: code: 1008 SQLState: 72000 Message: ORA-01008: not all variables bound
ORA-06512: at "SCHEMA.SPPR_SYS_RESERVEQUEUEITEM_B", line 114
Steps to Reproduce
- Install the updated SPPR_SYS_RESERVEQUEUEITEM_B supplied with HFix-28176.
- Start the system.
Root Cause
The ORA-06512 was caused due to a coding error in the body of the stored procedure.
Resolution
Apply HFix-37222.
Published November 27, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.