Support Article
Cases stuck in "Now-Processing" in the PR_SYS_QUEUE_SLA table
SA-20303
Summary
This is a large number of cases in the "Now-Processing" status in the PR_SYS_QUEUE_SLA table. These items do not appear to be getting processed currently, and the number is increasing. Here are the counts from the table:
7734 Scheduled
648 Broken-Process
78170 Now-Processing
149 null
Error Messages
Not Applicable.
Steps to Reproduce
Not Applicable.
Root Cause
A defect in Pegasystems’ code or rules: An error in a where clause of a SQL query led to this behavior.
Resolution
Apply HFix-26187.
Published March 12, 2016 - 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.