Anand Singh (AnandS24)
Virgin Media Communications Networks Ltd

Virgin Media Communications Networks Ltd
AnandS24 Member since 2017 3 posts
Virgin Media Communications Networks Ltd
Posted: June 19, 2020
Last activity: June 19, 2020
Posted: 19 Jun 2020 10:39 EDT
Last activity: 19 Jun 2020 10:59 EDT

DB Sessions from Pega remains even after App Server restart

We are using Pega v 7.1.7, with Pega MKT and Pega NBAA v 7.2

We have been observing that many DB connections remain active in DB side even after Pega App Server reboot, causing the DB resources to be occupied by old DB connection sessions that were pre-existing before server was shutdown.

I have seen exactly similar thread in PDN which is closed now, hence starting another thread for an answer, before I raise this as a Pega SR.

In the above thread, same situation is being discussed however, the suggestion provided doesnt apply for us, as in our case, these DB sessions even remain after Pega Server was bounced. Our DBA confirm that these DB sessions were establised prior to our App server shutdown, and now occupying DB resources, causing overall performance degradation in Production/Live environment. These DB sessions are more than 20 days old, and they switch from ACTIVE to INACTIVE state since then. 


Since these are sessions from prior to App Server shutdown, we need some inputs from Pega community forum what could be possibly the case here? Is it a Pega config issue, or a Product bug that we need to take up with Pega GCS or Oracle?


***Edited by Moderator Kayla to update Product and Version***

Pega Platform 7.1.7 Decision Management Communications and Media
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.