Server did not respond within the specified timeout interval

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Chetanrpawar
Posts: 3
Joined: Wed 25 Jul 2012 13:49

Server did not respond within the specified timeout interval

Post by Chetanrpawar » Wed 25 Jul 2012 14:00

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
Devart Team
Posts: 8082
Joined: Thu 14 Aug 2008 12:44

Re: Server did not respond within the specified timeout interval

Post by Shalex » Fri 27 Jul 2012 11:32

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
Posts: 3
Joined: Wed 25 Jul 2012 13:49

Re: Server did not respond within the specified timeout interval

Post by Chetanrpawar » Fri 27 Jul 2012 12:33

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
Devart Team
Posts: 8082
Joined: Thu 14 Aug 2008 12:44

Re: Server did not respond within the specified timeout interval

Post by Shalex » Fri 27 Jul 2012 14:50

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
Posts: 3
Joined: Wed 25 Jul 2012 13:49

Re: Server did not respond within the specified timeout interval

Post by Chetanrpawar » Sat 28 Jul 2012 08:59

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

Shalex
Devart Team
Posts: 8082
Joined: Thu 14 Aug 2008 12:44

Re: Server did not respond within the specified timeout interval

Post by Shalex » Mon 30 Jul 2012 14:53

Chetanrpawar wrote: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?

Post Reply