System.Data.SqlClient.SqlException: Timeout expired.

[marlin]

I wrote an asp.net page that submits a query string to SQL Server. The result is then filled in a dataset, and a report in .pdf is generated from the dataset. If the result is limited to a small set of records, the report is displayed. If the result ends up with larger number of records, I got the following error. The query seems to time out in 35 seconds.

 

I'm not quite sure what causes the timeout problem. Any help is appreciated :) .

 

==========================================================

Server Error in '/LaborDistribution' 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:

Line 103: gdsLaborDistributionResult = New dsLaborDistributionLine 104: gdsLaborDistributionResult.Tables("LaborDistribution").Rows.Clear()Line 105: daLaborDistributionResult.Fill(gdsLaborDistributionResult, "LaborDistribution")Line 106:Line 107: daLaborDistributionResult = Nothing

 

Source File: c:\inetpub\wwwroot\LaborDistribution\LaborDistributionQuery.aspx.vb Line: 105

 

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(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) LaborDistribution.WebForm1.btnSubmit_ServerClick(Object sender, EventArgs e) in c:\inetpub\wwwroot\LaborDistribution\LaborDistributionQuery.aspx.vb:105 System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e) System.Web.UI.HtmlControls.HtmlInputButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain()

 

 

Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573

[kahlua001]

Either set the sqlcommand object's timeout to a higher number, or optimize your query.

[marlin]

Either set the sqlcommand object's timeout to a higher number' date=' or optimize your query.[/quote']

 

Thank you for your help. It works!!! :cool:

[Diesel]

No query should take over 11 seconds