Server did not respond within the specified timeout interval

[Chetanrpawar]

Hello,

I am getting below error when I tried to execute query using entity framework.

Message: Server did not respond within the specified timeout interval

Stack Trace: at Devart.Data.Oracle.a3.a(z A_0, ai A_1)
at Devart.Data.Oracle.OracleInternalConnection..ctor(z connectionOptions, OracleInternalConnection proxyConnection)
at Devart.Data.Oracle.cs.a(k A_0, Object A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionFactory.a(DbConnectionPool A_0, k A_1, DbConnectionBase A_2)
at Devart.Common.DbConnectionPool.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionPool.GetObject(DbConnectionBase owningConnection)
at Devart.Common.DbConnectionFactory.a(DbConnectionBase A_0)
at Devart.Common.DbConnectionClosed.Open(DbConnectionBase outerConnection)
at Devart.Common.DbConnectionBase.Open()
at Devart.Data.Oracle.OracleConnection.Open()
at Platform.DataAccess.RFConnection.Open()

Please help with solution you have.

Thanks,
Chetan

[Shalex]

The error says that your Oracle server is not available. Try your connection string with another tool - is connection established successfully in this case?

[Chetanrpawar]

When I update the edmx file with from database, It works fine. I was able to update or add entities. But when I used context to call database, It is throwing this error.
Even in visual studio, using database explorer, I can connect to database.

[Shalex]

1. If your query takes much time, try adding the "Default Command Timeout=0;" parameter to your connection string.
2. Turn on dbMonitor and make sure that Entity Framework uses a correct connection string.
Download link: http://www.devart.com/dbmonitor/dbmon3.exe
Documentation: http://www.devart.com/dotconnect/oracle ... nitor.html

[Chetanrpawar]

Command timeout solution doesn't work.
Using DMonitor, framework using correct connection string.

[Shalex]

Using DMonitor, framework using correct connection string.

1. Find out with dbMonitor if this error occurs on opening a connection or on executing some query?
2. Do any LINQ to Entities queries generate this error with your model?
3. Please copy the connection string from DbMonitor and try to open a plain ADO.NET connection (OracleConnection.Open()) in your code with this connection string. Is it opened successfully?