SPPR_SYS_RESERVEQUEUEITEM_B in 7.3.1 is not closing DB connection
Our application uses Pega 7.3.1 and oracle DB which is hosted in AWS . RAM size of DB is 32 GB and PGA is 5 GB.
Problem statement : store procedure SPPR_SYS_RESERVEQUEUEITEM_B connection is closed in DB which is in creasing PGA memory. This increased PGA memory(almost touching 5GB) causing problem in regular system programs(data loading, campaign).
As a work around , we had to kill the db sessions forcefully to get some space .
Question here is that why store sproc is not closing connections. I could see there is an issue with same SP in 7.3.1 regarding cursor open. I think this is still an issue in 7.3.1. I may be wrong here.
Please suggest on mitigation of this issue and let me know any information/questions.
SR B38330 · ISSUE 297411
Added code to ensure cursor closes on null-pointer exception
RESOLVED IN PEGA VERSION 7.3
Open cursor issues were occurring with out-of-the-box queries.SPPR_SYS_RESERVEQUEUEITEM_B Stored Proc when an exception was raised. Code has been added to ensure the cursor is closed in this situation.