How to Kill the Essbase Processes/Sessions in 'Terminating' Status?

How to Kill the Essbase Processes/Sessions in 'Terminating' Status? [ID 839411.1]
		Modified 19-JAN-2011     Type HOWTO     Status PUBLISHED

In this Document
  Goal
  Solution
  References

---

Applies to:

Hyperion Essbase - Version: 7.1.6.0.06 to 9.3.1.1.00 - Release: 7.1 to 9.3
Information in this document applies to any platform.

Goal

How to kill the Essbase processes/sessions stuck in a 'Terminating' Status?

Solution

Run the following two MaxL commands to end the sessions:

alter system logout session all force;
alter system kill request all;

If the above two MaxL commands do not end the session, the only way to get rid of them is to stop/start Essbase.

Use the following MaxL commands to shutdown Essbase: 

alter system unload application all;
alter system shutdown;

These commands will cleanly unload applications currently in memory. If there is a hung process on one of the applications, Essbase will not shutdown and you will need to kill the hung ESSSVR process.  See Document 583519.1 for information in killing ESSSVR processes.

If these sessions are not causing an issue, they should be cleared on the next scheduled recycle of Essbase.

References

NOTE:583519.1 - Kill a Runaway or Ghost ESSSVR Process