Server did not respond within the specified timeout interval

Server did not respond within the specified timeout interval

Postby ericliu » Fri 18 Sep 2015 03:32

09:58:57 [ThreadId 16] ExPostMapper : MIG-00656: OracleException during MapExPost legacy synchronisation. Devart.Data.Oracle.OracleException (0x80004005): Server did not respond within the specified timeout interval à Devart.Data.Oracle.ar.a(b2 A_0, p A_1)
à Devart.Data.Oracle.OracleInternalConnection..ctor(b2 connectionOptions, OracleInternalConnection proxyConnection)
à Devart.Data.Oracle.ap.a(o A_0, Object A_1, DbConnectionBase A_2)
à Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, o A_1, DbConnectionBase A_2)
à Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
à Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
à Devart.Common.DbConnectionFactory.b(DbConnectionBase A_0)
à Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
à Devart.Common.DbConnectionBase.Open()
à Devart.Data.Oracle.OracleConnection.Open()
à Iris.Legacy.Writers.LegacyDBWriters.Write()
à Iris.DataImport.ExPostMapper.MapExPost(DateTime validat, Nullable`1 validuntil, DateTime deliverydate, Boolean skipimport, ExPostStreamAssetsType streamAssetsType, Arguments arguments)

Dear devart support,

My company PFS( a state street company) is a loyal customer of your product.

Occasionally we met above errors when connecting to oracle, and we don't have a clue about it as the database is running well and the error seems random. Could you please shed some light on the causes of the error and the solutions. Thanks alot.
ericliu
 
Posts: 3
Joined: Fri 18 Sep 2015 03:24

Re: Server did not respond within the specified timeout interval

Postby Pinturiccio » Mon 21 Sep 2015 09:59

This exception occurs when connection establishing takes more time than the interval, specified in the 'Connection Timeout' connection string parameter. By default it is 15 seconds. We recommend you to increase the value of this parameter. For more information, please refer to http://www.devart.com/dotconnect/oracle/docs/?Devart.Data.Oracle~Devart.Data.Oracle.OracleConnection~ConnectionTimeout.html
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44

Re: Server did not respond within the specified timeout interval

Postby zhuqijun » Wed 20 Jan 2016 04:58

Could you list what could be the cause of 'server did not respond...', is the a oracle server issue? or the client (dotconnect) issue?
zhuqijun
 
Posts: 23
Joined: Fri 05 Jul 2013 06:56

Re: Server did not respond within the specified timeout interval

Postby Pinturiccio » Thu 21 Jan 2016 15:31

As we wrote before, the exception "Server did not respond within the specified timeout interval" occurs when connection establishing takes more time than the interval, specified in the 'Connection Timeout' connection string parameter.

The reason of the exception is that a connection could not be established in the time interval, specified in the 'Connection Timeout' connection string parameter. An underlying reason that prevented establishing a connection does not matter. It can be the server not running, network troubles, heavily loaded server, which needs too much time for establishing a connection.

One thing we can say for sure, this is not a dotConnect for Oracle issue.

By default, the value of the 'Connection Timeout' connection string parameter is 15 seconds. We recommend you to increase the value of this parameter. For more information, please refer to http://www.devart.com/dotconnect/oracle/docs/?Devart.Data.Oracle~Devart.Data.Oracle.OracleConnection~ConnectionTimeout.html
Pinturiccio
Devart Team
 
Posts: 1978
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle