Oracle errors when the client leaves the application idle for 1hr +

Posted on 2003-03-29
Medium Priority
Last Modified: 2007-12-19
I have a site that is connected to the main site via a VPN connection.
When the users leave the Siebel application open and idle for more than 1 hour they receive the following errors:
Generic SSA NOTOK error message
An error has occured preparing a Sql statement
ORA-03113: end-of-file on communication channel.

the users have no problems with any other applications and the retreive email via Outlook through this VPN connection as well.

Any ideas would be apprecaited.
Question by:jmurray110
LVL 22

Expert Comment

by:Helena Marková
ID: 8236675
It seems that Siebel application has set timeout...
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 300 total points
ID: 8238238
Hi jmurray110,
   This "problem" can be result of many things:
   * Oracle closing automatically some connections that are inactive for long time
   * Some Connection Pooling that reuses connections
   * Network connection cuts that drop the connection

  Now, you should try to eliminate possible sources, and in case speak with the siebel application support to check for this problem.
  It is a generic problem, and you might look into the trace files on the server of the client sessions to check for more information.


Author Comment

ID: 8238335
i have found out that the Cisco PIX firewall / VPN device was causing the timeout to occur as it would expire the PAT after an hour of inactivity. I was able to bump the setting and reslove the issue.

Thanks for the suggestions though.
LVL 143

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 8238352
Thus, to clean up this question:
* award the points if you think a comment has pointed out the problem.
* ask in the community support to close the question as you solved your problem yourself

LVL 17

Expert Comment

ID: 10360686
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: angelIII {http:#8238238}

Please leave any comments here within the next four days.

EE Cleanup Volunteer

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question