Highlighted
New Member.
279 views

Database sessions not getting released

Hi folks,

So here's the issue; SRC 1.30 running on Service Manager 9.31.

If the Service Manager inactivity timer is set to a lower value than the SRC inactivity timer, when SM kills the session the database disconnect command is never sent (sqociDisconnect:OCISessionEnd” and “sqociDisconnect:OCIServerDetach).  This leaves the database connected forever, until you run out of database sessions.  This does not happen with SM client sessions.

This appears to happen with any web services connection.  Has anybody else noticed this behaviour? Has anybody found a cause?

Thanks!

0 Likes
1 Reply
Highlighted
Micro Focus Expert
Micro Focus Expert

Re: Database sessions not getting released

Hi,

Do you have webservices_sessiontimeout already in your sm.ini? If you answer is no, please give it a try and let us know if behavior reported still happens.

--------------------------------

Parameter
Webservices_sessiontimeout
Description
This parameter defines the number of seconds that the server waits for a WebService API client request before the server assumes that the client session has timed out and closes the connection.

Valid if set from
Server's OS command prompt
Initialization file (sm.ini)
Requires restart of HP Service Manager server?
Yes
Default value
1800
Possible values
Number of seconds
Example usage
Command line: sm -httpPort:13080 -webservices_sessiontimeout:30
Initialization file: webservices_sessiontimeout:30

--------------------------------

Regards,

If you feel this was helpful please click the KUDOS! thumb below!
0 Likes
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.