Error on opening DbConnection, Server did not respond within the specified timeout interval
There was a problem with ORACLE connection, details included below. After that a lot of requests timed out and IIS CPU usage was 99%.
We had to restart IIS on a server. (Windows 2003 64 bit, oracle client 11g 32 bit)
I would expect this kind of error to raise exception before reuqest time out.
(currently Request Timeout is set to 2 minutes)
In another words, when any kind of ORACLE error happens my app should raise exception right away. In this case it took at least 2 minutes and finaly request timed out.
How can I be sure that Devart command/connection times out before IIS Response times out?
thanks
Code: Select all
Exception information:
Exception type: LinqCommandExecutionException
Exception message: Error on opening DbConnection.
at Devart.Data.Linq.LinqCommandExecutionException.CanThrowLinqCommandExecutionException(String message, Exception e)
at Devart.Data.Linq.Provider.k.a.g()
at Devart.Data.Linq.Provider.k.a.b(IConnectionUser A_0)
at Devart.Data.Linq.Provider.k.b(IConnectionUser A_0)
at Devart.Data.Linq.Provider.DataProvider.ExecuteQuery(CompiledQuery compiledQuery, Object[] parentArgs, Object[] userArgs, Object lastResult)
at Devart.Data.Linq.Provider.DataProvider.Devart.Data.Linq.Provider.IProvider.Execute(Expression query)
at Devart.Data.Linq.DataQuery`1.System.Linq.IQueryProvider.Execute[S](Expression expression)
at System.Linq.Queryable.SingleOrDefault[TSource](IQueryable`1 source)
at RRD.OnePlace.BLL.JobBO.SaveUserFilter(Int64 empID, String filter)
.....
Server did not respond within the specified timeout interval
at Devart.Data.Oracle.bd.a(ac A_0, ai A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(ac connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.bx.a(j A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, j A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Devart.Data.Linq.Provider.k.a.g()