Server did not respond within the specified timeout interval

[ericliu]

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.

[Pinturiccio]

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 ... meout.html

[zhuqijun]

Could you list what could be the cause of 'server did not respond...', is the a oracle server issue? or the client (dotconnect) issue?

[Pinturiccio]

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 ... meout.html