Kill Idle / Old sessions in BOBJ 4.1 SP2 without Restart - BOBJ on SAP JAVA

[Former Member]

Hi Everybody,

We see tons of resources for BOBJ on Tomcat and ironically very few (if not rare) to the point, direct reference to  BOBJ on SAP JAVA !! I wonder how

long it will take before Sr. SAP Persons in Waldorf will release Notes / KBAs which is cent percent relevant for SAP's own SAP JAVA + BOBJ 4.1 combination !?!

We have typical issue of  ' Idle/Old sessions not being released ' and being Production, we were hoping to see at least 1 or 2 notes which talks about killing sessions in BOBJ 4.1 on SAP JAVA and (NOT on BOBJ 4.0 / 4.1 on Tomcat) without server restart   ..when we found

#1803138 : how to kill session in BOBJ without restart and

  guess what? to our most annoying surprize --- on standard service.sap.com/notes : Document is not  released ??!!

We know not all " BOBJ on Tomcat " notes are applicable in cent percent manner to " BOBJ on SAP " and SAP is deafeningly silent on this !!

#1886165 - How to terminate user session manually in XI 3.1 and BI 4.0?

   this note available ( and again it talks only about Tomcat !! ) but, it says SAP Do not support this method and CMS DB Back up is suggested

              -- what is the use of this note in PROD Env ???

#1668750 - Sessions not being released in SAP Business Intelligence Platform 4.0 - Requires restart of server !!

Does anyone have / tried successfully work around to kill old / idle user sessions in " BOBJ on SAP JAVA " environment  And / Or

Anyone knows any other note / KBA which actually talks about " BOBJ on SAP JAVA " for killing session without restart and actaully available on SMP ?

Thanks for your inputs and time,

Regards,

- Ishan

[Former Member · Accepted solution]

You have the option to kill sessions from cmc in bi 4.1 sp3 onwards. it would be supported.

[Former Member · Accepted solution]

Additionally you can also look forward to

[Former Member · Accepted solution]

Hi Arvind :

Thanks for the inputs / link for SessionKillScript.

Appreciate.

Regards,

- Ishan