Where is the session timeout value for the duration of running an sql query/procedure [message #686410] |
Wed, 07 September 2022 16:26 |
|
Bob Alston
Messages: 6 Registered: September 2022
|
Junior Member |
|
|
I am using a web service developed by a government entity. Some of my requests which has
been confirmed to be valid requests seemed to be automatically canceled after 10 minutes. When using Soap Sonar personal 9 I receive a response back at 600.8 seconds. I get this response.
image.png
From research I understand this is most likely by a processing timeout setting for the query request. What I need help on is exactly where is this setting established - in the application program? In a database setting or procedure? Somewhere else?
So far the entity providing the web service has been unable to locate the setting.
one web source stated the following:
"This error may be due to an internal Sql*Net parameter which times out
the connection. This is called sqlnet.expired.time which logs out users after a set time. Contact your DBA to reset this parameter and retry."
www.ibm.com/support/pages/error-ora-01013-user-requested-cancel-current-operation
But if this is the setting in play I don't know how to tell the provider where to look for this.
Thank you.
Bob
|
|
|
|
Re: Where is the session timeout value for the duration of running an sql query/procedure [message #686412 is a reply to message #686410] |
Thu, 08 September 2022 00:56 |
John Watson
Messages: 8938 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
There are many places where this sort of issue can arise, before you get to the database. You probably need track right through the stack looking for timeouts and keepalives. Start with your load balancers, web listeners (Apache? Nginx?), and java servers (Tomcat?)
Certainly you should set SQLNET.EXPIRE_TIME (note the exact spelling) in your database server's sqlnet.ora file (I usually set it to 1) but it is unlikely to fix the problem.
--update: typo, corrected 10 to 1 for the sqlnet.expire_time
[Updated on: Thu, 08 September 2022 00:59] Report message to a moderator
|
|
|
|