Open Sessions in BOBJ

Hi,
We recently upgraded from BOBJ 4.1 SP4 to BOBJ 4.2 SP3. We have been using restfulweb services to access reports for some specific users and after upgrade we have a new problem. We have a lot of sessions from this userid and they keep hanging up on BOBJ systems. I have to manually kill these sessions every day. Just as an example I had to kill about 90 sessions from these userid which started on May 4th at from 12-8 PM EST.

I am thinking to run some scripts which will kill sessions periodically but i donot want to interfer with any user whose running reports for various external customers.

I have checked with our team and they tell me no new changes were done to the code from their side. Can you please point me in a direction to resolve this issue. I made sure that the BOBJ timeouts are same as they were in our previous version and checked all BOBJ settings and I see no change.

Thanks in advance


ash0550 :canada: (BOB member since 2011-09-12)

Any Developers using REST SDK?
If yes, Timeout for this default = 60Min.


bharathbn04 (BOB member since 2017-06-01)

In my previous project, i had a similar issue. However, we were letting users consume reports from a in house developed portal. We were running in to sessions being opened even after user is done and reaching limits. How i handled it was using monitoring, every time the session count went to certain limit, i would force the CMS to restart and it would kill all sessions, and existing users would maintain their session automatically.


NycPriya (BOB member since 2010-11-04)