Getting a Timeout Error

**=?Utf-8?B?TG91aXMgU29tZXJz?=** · Sep 23 '08, 11:15 AM

RE: Getting a Timeout Error

At a glance it looks like the timeout is not from your page, but from your
Database connection.
Try adding a timeout entry in the connectionstrin g or setting the
DbConnection.Co nnectionTimeout property.

Cheers,
Louis

"Andrew Cooper" wrote:

Greetings,
>
I've got a website that has several pages with DataGrid controls on
them. The controls are bound to Object Datasources. On one of the
pages I keep getting a "Timeout expired. The timeout period elapsed
prior to completion of the operation or the server is not responding."
error. The data is being filled from a Stored Procedure on an SQL
Server. When I run the Stored Procedure on the actual server, it is
only taking 24 seconds or so to run and the timeout setting on the
ASP.NET website is set to 120 seconds. Other pages on the site that
have similar queries are working fine. Is there anything else that
might be causing the timeout?
>
Below is a copy of the error message...
>
[SqlException (0x80131904): Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.]
System.Data.Sql Client.SqlInter nalConnection.O nError(SqlExcep tion
exception, Boolean breakConnection ) +800131
>
System.Data.Sql Client.TdsParse r.ThrowExceptio nAndWarning(Tds ParserStateO
bject stateObj) +186
>
System.Data.Sql Client.TdsParse rStateObject.Re adSniError(TdsP arserStateOb
ject stateObj, UInt32 error) +556
System.Data.Sql Client.TdsParse rStateObject.Re adSni(DbAsyncRe sult
asyncResult, TdsParserStateO bject stateObj) +164
System.Data.Sql Client.TdsParse rStateObject.Re adPacket(Int32
bytesExpected) +34
System.Data.Sql Client.TdsParse rStateObject.Re adBuffer() +44
System.Data.Sql Client.TdsParse rStateObject.Re adByte() +17
System.Data.Sql Client.TdsParse r.Run(RunBehavi or runBehavior,
SqlCommand cmdHandler, SqlDataReader dataStream,
BulkCopySimpleR esultSet bulkCopyHandler , TdsParserStateO bject stateObj)
+79
System.Data.Sql Client.SqlDataR eader.ConsumeMe taData() +31
System.Data.Sql Client.SqlDataR eader.get_MetaD ata() +62
System.Data.Sql Client.SqlComma nd.FinishExecut eReader(SqlData Reader
ds, RunBehavior runBehavior, String resetOptionsStr ing) +297
System.Data.Sql Client.SqlComma nd.RunExecuteRe aderTds(Command Behavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean
async) +1005
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method, DbAsyncResult result) +132
System.Data.Sql Client.SqlComma nd.RunExecuteRe ader(CommandBeh avior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String
method) +32
System.Data.Sql Client.SqlComma nd.ExecuteReade r(CommandBehavi or
behavior, String method) +122
System.Data.Sql Client.SqlComma nd.ExecuteDbDat aReader(Command Behavior
behavior) +12
>
System.Data.Com mon.DbCommand.S ystem.Data.IDbC ommand.ExecuteR eader(Comman
dBehavior behavior) +7
System.Data.Com mon.DbDataAdapt er.FillInternal (DataSet dataset,
DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String
srcTable, IDbCommand command, CommandBehavior behavior) +141
System.Data.Com mon.DbDataAdapt er.Fill(DataTab le[] dataTables, Int32
startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior
behavior) +162
System.Data.Com mon.DbDataAdapt er.Fill(DataTab le dataTable) +107
>
NewReportingDat aSetTableAdapte rs.Customer_Sta tistic_Report_B y_DIDTableAd
apter.GetStatis ticsByDIDData(S tring StartDate, String EndDate, String
DID) +455
ClientUsageBLL. GetStatisticsBy DID(String startDate, String endDate,
String DID) +163
>
[TargetInvocatio nException: Exception has been thrown by the target of
an invocation.]
System.RuntimeM ethodHandle._In vokeMethodFast( Object target, Object[]
arguments, SignatureStruct & sig, MethodAttribute s methodAttribute s,
RuntimeTypeHand le typeOwner) +0
System.RuntimeM ethodHandle.Inv okeMethodFast(O bject target, Object[]
arguments, Signature sig, MethodAttribute s methodAttribute s,
RuntimeTypeHand le typeOwner) +72
System.Reflecti on.RuntimeMetho dInfo.Invoke(Ob ject obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture,
Boolean skipVisibilityC hecks) +371
System.Reflecti on.RuntimeMetho dInfo.Invoke(Ob ject obj, BindingFlags
invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +29
>
System.Web.UI.W ebControls.Obje ctDataSourceVie w.InvokeMethod( ObjectDataSo
urceMethod method, Boolean disposeInstance , Object& instance) +480
>
System.Web.UI.W ebControls.Obje ctDataSourceVie w.ExecuteSelect (DataSourceS
electArguments arguments) +1960
System.Web.UI.D ataSourceView.S elect(DataSourc eSelectArgument s
arguments, DataSourceViewS electCallback callback) +17
System.Web.UI.W ebControls.Data BoundControl.Pe rformSelect() +149
System.Web.UI.W ebControls.Base DataBoundContro l.DataBind() +70
System.Web.UI.W ebControls.Grid View.DataBind() +4
System.Web.UI.W ebControls.Base DataBoundContro l.EnsureDataBou nd() +82
>
System.Web.UI.W ebControls.Comp ositeDataBoundC ontrol.CreateCh ildControls(
) +69
System.Web.UI.C ontrol.EnsureCh ildControls() +87
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +50
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
System.Web.UI.C ontrol.PreRende rRecursiveInter nal() +170
System.Web.UI.P age.ProcessRequ estMain(Boolean
includeStagesBe foreAsyncPoint, Boolean includeStagesAf terAsyncPoint)
+2041
>
--
>
Thanks,
Andrew Cooper
>

**Andrew Cooper** · Sep 23 '08, 07:55 PM

Re: Getting a Timeout Error

Louis Somers wrote:

At a glance it looks like the timeout is not from your page, but from your
Database connection.
Try adding a timeout entry in the connectionstrin g or setting the
DbConnection.Co nnectionTimeout property.
>
Cheers,
Louis

That was it. I should have known that. Sometimes its the stupid,
little things that get you.

Thanks, Louis.

Andrew

Getting a Timeout Error

Getting a Timeout Error

Comment

Comment