Server did not respond within the specified timeout interval

Server did not respond within the specified timeout interval

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

Re: Server did not respond within the specified timeout interval

Postby 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?
Shalex
Devart Team
 
Posts: 7842
Joined: Thu 14 Aug 2008 12:44

Re: Server did not respond within the specified timeout interval

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

Re: Server did not respond within the specified timeout interval

Postby 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/docs/?DbMonitor.html
Shalex
Devart Team
 
Posts: 7842
Joined: Thu 14 Aug 2008 12:44

Re: Server did not respond within the specified timeout interval

Postby Chetanrpawar » Sat 28 Jul 2012 08:59

Command timeout solution doesn't work.
Using DMonitor, framework using correct connection string.
Chetanrpawar
 
Posts: 3
Joined: Wed 25 Jul 2012 13:49

Re: Server did not respond within the specified timeout interval

Postby 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?
Shalex
Devart Team
 
Posts: 7842
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle