SR-B57616: SLA agent is processing cases very slow
Hi Team,
Could you suggest a db query or an activity rule that looks at each queue item in broken queue, and checks whether the work corresponding to that item is already complete, and then deletes that queue item.
Seems at present there is no particular tool available for removing queue items that correspond to completed work. So we need either a db query or activity rule as having hundreds of thousands of queue items is not a healthy situation.
***Updated by moderator: Lochan to add SR exists group tag***
BUPA
AU
PRPC provides one OOTB report to list broken queue items. I think you have to write a custom activity to clean it or you can use DB query to do so.
select * from <data_schema>.pr_sys_queues where pyItemStatus = 'Broken-Process'
Pegasystems
US
I think you want to augment that query to join your work table and your queue table since you want to find queue entries that refer to a work object whose status is resolved.
If you know that such a status is "like 'Resolved-*'" then you'll want to convey that in your query.