Hi all
I get the following error when executing a rather intense stored procedure
from an ASPX page.
I have tried:
- Increasing timeouts on IIS 5.0 (all areas that even mention timeout)
- use the "Connection Timeout=2400" string in the SqlConnection connections
string
- disabled connection pooling.
the error seems to consistently come back after 30 seconds! I am using
Microsofts Data Application blocks for accessing SQL.
is there a timeout setting that i am missing???? or is this a bug?
Thanks!
Jason
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)
+44
System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(Comman
dBehavior 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
Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(SqlConnection
connection, CommandType commandType, String commandText, SqlParameter[]
commandParameters) +148
ppm.Post_to_GL.run_a_sp_ProcessedDeals() +246
ppm.Post_to_GL.btnPostToGL_Click(Object sender, EventArgs e) +75
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo
stBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler
sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277 5 13232
The SQL Connection timeout is just how long the attempt to make a connection
lasts if it's having trouble. It has nothing to do with execution of SQL
statements.
You need to change the timeout on the command object.
"Jason" <c_*******@mighty.co.za> wrote in message
news:%2********************@tk2msftngp13.phx.gbl.. . Hi all
I get the following error when executing a rather intense stored procedure from an ASPX page. I have tried: - Increasing timeouts on IIS 5.0 (all areas that even mention timeout) - use the "Connection Timeout=2400" string in the SqlConnection
connections string - disabled connection pooling.
the error seems to consistently come back after 30 seconds! I am using Microsofts Data Application blocks for accessing SQL. is there a timeout setting that i am missing???? or is this a bug?
Thanks! Jason
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) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(Comman dBehavior 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 Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +148 ppm.Post_to_GL.run_a_sp_ProcessedDeals() +246 ppm.Post_to_GL.btnPostToGL_Click(Object sender, EventArgs e) +75 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277
did you try setting up SqlCommand.CommandTimeout property?
If not, do so...
--
Hope this helps,
Zeeshan Mustafa, MCSD
"Jason" <c_*******@mighty.co.za> wrote in message
news:%2********************@tk2msftngp13.phx.gbl.. . Hi all
I get the following error when executing a rather intense stored procedure from an ASPX page. I have tried: - Increasing timeouts on IIS 5.0 (all areas that even mention timeout) - use the "Connection Timeout=2400" string in the SqlConnection
connections string - disabled connection pooling.
the error seems to consistently come back after 30 seconds! I am using Microsofts Data Application blocks for accessing SQL. is there a timeout setting that i am missing???? or is this a bug?
Thanks! Jason
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) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(Comman dBehavior 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 Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +148 ppm.Post_to_GL.run_a_sp_ProcessedDeals() +246 ppm.Post_to_GL.btnPostToGL_Click(Object sender, EventArgs e) +75 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277
The Connect Timeout property of the Connection String will specify how
long the underlying provider will wait before a Connection Timout
occurs. After you connect this is not going to be used unless you
perform a reconnection again.
You can try to use a SQLCommand object but specify the Timeout Property.
I am not sure about the Application Block as I am not at my desk. Should
you require please drop me an email or post to this forum.
The Default is 20 seconds for a sql command to timeout. If it a heavily
used table then try to add the WITH (NOLOCK) clause for your select
statements.
Regards,
Trevor Benedict R
MCSD
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
did you try setting up SqlCommand.CommandTimeout property?
If not, do so...
--
Hope this helps,
Zeeshan Mustafa, MCSD
"Jason" <c_*******@mighty.co.za> wrote in message
news:%2********************@tk2msftngp13.phx.gbl.. . Hi all
I get the following error when executing a rather intense stored procedure from an ASPX page. I have tried: - Increasing timeouts on IIS 5.0 (all areas that even mention timeout) - use the "Connection Timeout=2400" string in the SqlConnection
connections string - disabled connection pooling.
the error seems to consistently come back after 30 seconds! I am using Microsofts Data Application blocks for accessing SQL. is there a timeout setting that i am missing???? or is this a bug?
Thanks! Jason
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) +44
System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(Comman dBehavior 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 Microsoft.ApplicationBlocks.Data.SqlHelper.Execute Dataset(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) +148 ppm.Post_to_GL.run_a_sp_ProcessedDeals() +246 ppm.Post_to_GL.btnPostToGL_Click(Object sender, EventArgs e) +75 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePo stBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1277
The Connect Timeout property of the Connection String will specify how
long the underlying provider will wait before a Connection Timout
occurs. After you connect this is not going to be used unless you
perform a reconnection again.
You can try to use a SQLCommand object but specify the Timeout Property.
I am not sure about the Application Block as I am not at my desk. Should
you require please drop me an email or post to this forum.
The Default is 20 seconds for a sql command to timeout. If it a heavily
used table then try to add the WITH (NOLOCK) clause for your select
statements.
Regards,
Trevor Benedict R
MCSD
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it! This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: bdeviled |
last post by:
I am deploying to a web environment that uses load balancing and to insure
that sessions persist across servers, the environment uses SQL to manage
sessions. The machine.config file determines how...
|
by: David M. Nolf |
last post by:
I have a web service that has a method that takes a fair amount of time to
complete. One of my clients is stating that they are getting a timeout
back.
I am having difficulties getting my...
|
by: Dan |
last post by:
All,
I have a Web Service that validates a piece of data. However, the database
that the data comes from is mamouth. So, it may take a long time for the
validation query to complete.
...
|
by: A.M-SG |
last post by:
Hi,
How can I increase the HTTP Timeout value at the client side?
Thank you,
Alan
|
by: george |
last post by:
Hi all, here's my index.asp file. I don't know where has gone wrong.
can't run properly, just showing
error ASP 0113 Script timeout
<!--#include file="head.asp"-->
<!-- begin...
|
by: stormsender |
last post by:
Hi there, I'm a noob to javascript, so was hopping to find some help here...
I believe that what I need is simple, still haven't found any solution.
I have a website serving ads, and links...
|
by: johnlim20088 |
last post by:
Hi,
Currenty I have a window based NET application running and have a following function to http post some data.
string url = xxxx.aspx? parameter1=¶meter2=&..etc
WebRequest request...
|
by: cmgmyr |
last post by:
Hey All,
I'm having a little problem with exporting data from my database. The
problem is that the query seems to be too much for PHP and MySQL to
handle since it is timing out. I have the timeout...
|
by: Atli |
last post by:
Introduction
In this article I aim to explain the reasons why PHP sessions expire after a set period of inactivity, and how this mechanism works. I'll describe two commonly used methods to control...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM).
In this month's session, the creator of the excellent VBE...
|
by: DolphinDB |
last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation.
Take...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: marcoviolo |
last post by:
Dear all,
I would like to implement on my worksheet an vlookup dynamic , that consider a change of pivot excel via win32com, from an external excel (without open it) and save the new file into a...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
| |