Regular Contributor.. Regular Contributor..
Regular Contributor..

SOAP Fault Error : Mex Session Exceeded : User session still alive in DB

Dear All , 

Please help our HP SM 9.41 application is not accepting any more session because , Application end 350 sessions showing but when we are checking DB its more than 500 sessions .


Please help us to resolve session sync issue between App and DB .

2 Replies
Micro Focus Expert
Micro Focus Expert

The Max Session Exceeded error would be caused by a configuration limit in SM.   In the sm.ini file the number of sessions that can be handeled by a single servlet is controlled by the 'threadsperprocess' setting.  If you have it set to 50 and you have 7 servlets you would be limited to 350 sessions.

The DB connection issue would be a different problem.  Note the number of SM sessions will not equal the number of DB sessions.  All of the background procesess have DB connections and each servlet has 2 DB connections.  So this may or may not be a problem based on your configuration.

For an issue like this I would recommend a support case if the above does not give you enough information to determine root cause.

Steve Hirschfeld

Honored Contributor.. Honored Contributor..
Honored Contributor..



1- stop all SM services

2- Open the command prompt in administration mode and Run the following command under <SM Installation Directory>\Server\RUN

sm -unlockdatabase

3- Start SM again



The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.