Question

Updating PR_SYS_QUEUES Status

I have entries in PR_SYS_QUEUES that are constantly reprocessing. Due to affect on database server archive process, I am planning to update PYITEMSTATUS to 'Broken-Process' via database script (there will be separate analysis to find root underlying issue and remediate). Just wanted to get feedback that this works as a possible solution even if it's not the ideal solution and the best practice for updating PR_SYS_QUEUES.

Correct Answer
December 27, 2018 - 7:48am

It should work since the stored procedure used by the agent queue processing checks for items that are in a Scheduled status and a date ready to be processed.

Comments

Keep up to date on this post and subscribe to comments

December 27, 2018 - 7:48am

It should work since the stored procedure used by the agent queue processing checks for items that are in a Scheduled status and a date ready to be processed.

December 27, 2018 - 8:47am

Thanks for the quick reply! I just noticed I was not clear in my first post. I meant to ask whether there is an alternative best practice (or better solution) when dealing with updates to PR_SYS_QUEUES. If not, I will proceed with DB script. Thanks again.

December 27, 2018 - 9:23am

You could also use the Defer option in SMA or the Queue Management landing page to move the items to the broken queue. I think the Queue Management landing page was added in 7.3.

https://community.pega.com/sites/default/files/help_v74/procomhelpmain.htm#engine/queue-management/eng-deferring-queue-items-tsk.htm