Question
DXC Technology
BE
Last activity: 17 Apr 2018 9:43 EDT
System Queue management in SMA and pr_sys_queues table
Dears,
I noticed that the amount of Item Count with Status Scheduled in SMA is very high like and not equal to the count of records in the table pr_sys_queues with column pyitemstatus as Scheduled.
Means my understanding that the table from where this is fetched in SMA is pr_sys_queues is wrong. Could you let me know from which table does SMA populate the details in the section called System Queue Management under Agent Management.
regards,
Jagan
Accepted Solution
Pegasystems Inc.
US
There are multiple queue tables. For example, the SLA queue items would be stored in pr_sys_queues_sla and not pr_sys_queues.
Here is the list of queue tables I see in my 7.3.1 system.
PR_SYS_QUEUE_AUTOTEST
PR_SYS_QUEUE_COL_POP
PR_SYS_QUEUE_COUNT
PR_SYS_QUEUE_EXECREQ_CONN
PR_SYS_QUEUE_EXECREQ_SVC
PR_SYS_QUEUE_FTSINDEXER
PR_SYS_QUEUE_SLA
PR_SYS_QUEUE_STARTFLOWS
PR_SYS_QUEUES
DXC Technology
BE
Thanks for the quick reply.
So whatever is related to an agent is only stored in PR_SYS_QUEUES right.
If so, if there is a poison entry in this queue which is trying to kill the server with many retries, is there a way to handle this particular entry. Any best practise ?
We would normally go and update the table's pyitemstatus from Now-Processing or Scheduled to Broken-Process. But after this update, we see that we are no more able to find that entry in the table any more. What happens to it ?
Pegasystems Inc.
US
If the item is in a Now-Processing or Scheduled status then it should still be in the table. Is it a custom agent or an out of the box agent? If it is the ServiceLevelEvents agent, those would be stored in the pr_sys_queue_sla table.
DXC Technology
BE
It is a standard agent. We are of couse able to see Now-Processing and Scheduled items but the ones manually moved to Broken-Status are not seen after i update them. Why is that. Does Pega clean them ? because we would still need those broken items for more investigation.
I do see some broken items in the queue but those have reached this status after completing their maximum retries. My question is specifically for those that are manually updated to broken by a db script.
Pegasystems Inc.
US
If the queue items are manually updated via a db script then the item status in the blob column will not be in sync with the exposed column.
DXC Technology
BE
We are not updating the Blob directly but only updating the pyitemstatus column to Broken-Process. But such updated entries are not visible any more.
Pegasystems Inc.
US
I just tried it on my 7.3.1 system. I changed the pyItemStatus of an entry in pr_sys_queues and I see it reflected in SMA. You should open an SR so an engineer can look at the behavior on your system.