Once in a wile am keep getting error messages in my web application:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]
   System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
   System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior behavior) +45
   System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(CommandBehavior behavior) +5
   System.Data.Common.DbDataAdapter.FillFromCommand(O bject data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +38
   GMI.DataAccessLayer.SQLCommandAndDataSet.ExecuteAn dFill(Boolean a_bPreserveCommandObject) +136
   GMI.DataAccessLayer.DataAccessLayer.CompanyUserDat aSet(String sSessionValue, String username, Guid mChanged_gUserSessionID) +72
   GMI.Intranet.DataEntry.Home.CreateRecentlyUsedComp aniesDataSource(String sSessionValue, String username, Guid mChanged_gUserSessionID) +37
   GMI.Intranet.DataEntry.Home.Page_Load(Object sender, EventArgs e) +1449
   System.Web.UI.Control.OnLoad(EventArgs e) +67
   System.Web.UI.Control.LoadRecursive() +35
   System.Web.UI.Page.ProcessRequestMain() +731


Please let me know what should i do in order to stop getting this messages. I am running SQL 2000 and .net C#. Any help would be gratly appretiated.
Greg

GL

You have a query which is taking too long to complete.

You have two options:

1. Make it run faster
2. Increase the timeout value on the command object. By default it is 30 seconds, which apparently isn't long enough for your query, at least sometimes.

Note that option 1 can be addressed by optimizing the query, getting a bigger box, or reducing the load on the box you have.

Option 2 just pushes the problem over the horizon, which may or may not be acceptable, at least in the short term.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Use SQL Server Profiler to watch and see which queries take a long time to run. In this case you will need to watch RPC starting and T-SQL Batch Starting and see which queries don't have a corresponding End.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

GL

GL

First Open SQL Server Books On Line and read up on Profiler.
Then Open your app and get it right to the point where you just need to click a button to get the error.
Then Open Profiler, New Trace, Click start, then switch back to your app, and click the button to make it happen, when you get the error message switch back to Profiler and stop the trace.

David Lundell
Principal Consultant and Trainer
www.mutuallybeneficial.com

Here are a few hints:
1. find something else to do (car service?)
2. take English course or use spellchecker
3. Find someone to do it for you just like you did years ago