Question

1
Replies
36
Views
RaghuN99 Member since 2020 1 post
ProCom Consulting
Posted: 2 months ago
Last activity: 2 months 1 week ago

Slow stored procedure PEGADATA.SPPR_SYS_RESERVEQUEUEITEM_B

After the PEGA Upgrade to 8.3.1 we are seeing the DB Time exceptions in PDC. Description: 

Slow stored procedure PEGADATA.SPPR_SYS_RESERVEQUEUEITEM_B.

SQL Statement

CALL PEGADATA.sppr_sys_reservequeueitem_b (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)  

Rules Causing this Behavior
Rule TypeRule-Obj-ActivityTotal Time56 s
Occurrences1  
    
Class NameSYSTEM-QUEUE-EXECUTIONREQUEST-
Activity NamePROCESSQUEUE
Activity Step #1

 

I was looking at the article:

https://community.pega.com/support/support-articles/spprsysreservequeueitemb-stored-procedure-taking-more-time

The changes mentioned in the article are already available in the procedure.

Any ideas? Did anyone face this issue after 8.3.1 upgrade?

Pega Platform 8.3.1 Communications and Media
Share this page LinkedIn