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.
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.
Posted: 4 years ago
Posted: 27 Dec 2018 9:23 EST
Carissa Wenhardt (CarissaW_GCS)
Senior Principal Engineer, Technical Support, Industry Apps