Timeout Error

G

Guest

I have a web application developed in asp.net v1.1; database is sql server
2005. In production envionment, we are receiving the following error:

System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) at
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at
System.Data.SqlClient.SqlDataReader.get_MetaData() at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
String method) at
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior) at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable,
IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

When we run the stored proc from SQL Server management studio, its taking
just 1 second to return bunch of records (less than 100). When the same is
being called from the web app, we are getting the timeout error.

I found few articles which talks about a bug in ado.net:

1. You may receive an error message when an ADO.NET-connected application
uses the SqlBulkCopy class (http://support.microsoft.com/?kbid=913177)

2. When an ADO.NET-connected application uses the System.Data.SqlClient
namespace, the application may experience high CPU use and may stop
responding (http://support.microsoft.com/kb/912731)

We are experiencing the same issues mentioned in these articles. But, the
fix provided in those articles is for .NET v2.0. We are using .NET v1.1.

Can anyone pls help me resolving this issue?

Thanks,
Kalyan
 
W

William \(Bill\) Vaughn

This type of timeout (as opposed to a Connection.Open timeout) is caused by
the inability of the server to complete the task for some reason (in the
allotted time). Why didn't it complete? It's hard to say, but it could be
the operation was waiting for some other operation to complete (which held
needed resources), the server was overloaded at the time, the operation has
asked to complete a task that could not be done in time or a dozen other
reasons...

--
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest books:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition) and
Hitchhiker's Guide to SQL Server 2005 Compact Edition

-----------------------------------------------------------------------------------------------------------------------
Kalyan Nistala said:
I have a web application developed in asp.net v1.1; database is sql server
2005. In production envionment, we are receiving the following error:

System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception,
Boolean breakConnection) at
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception,
Boolean breakConnection) at
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject
stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet
bulkCopyHandler, TdsParserStateObject stateObj) at
System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at
System.Data.SqlClient.SqlDataReader.get_MetaData() at
System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,
RunBehavior runBehavior, String resetOptionsString) at
System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method,
DbAsyncResult result) at
System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior,
String method) at
System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior
behavior) at
System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.FillInternal(DataSet
dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable,
IDbCommand command, CommandBehavior behavior) at
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

When we run the stored proc from SQL Server management studio, its taking
just 1 second to return bunch of records (less than 100). When the same is
being called from the web app, we are getting the timeout error.

I found few articles which talks about a bug in ado.net:

1. You may receive an error message when an ADO.NET-connected application
uses the SqlBulkCopy class (http://support.microsoft.com/?kbid=913177)

2. When an ADO.NET-connected application uses the System.Data.SqlClient
namespace, the application may experience high CPU use and may stop
responding (http://support.microsoft.com/kb/912731)

We are experiencing the same issues mentioned in these articles. But, the
fix provided in those articles is for .NET v2.0. We are using .NET v1.1.

Can anyone pls help me resolving this issue?

Thanks,
Kalyan
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Randomly get timeout on SqlClient hitting localhost 13
On TransactionScope and TableAdapter 0
data reader error... 4
Need advice for tracking down a general network error exception 7
Internal .Net Framework Data Provider error 12 0
View timed out every now and then 5
Exceptions from SQL Server 2005 1
Error Message: Timeout expired. 2

Top