![]() |
|
|
|||||||
![]() |
ASP Net - error: The operation has timed-out (executionTimeout?) |
|
|
Thread Tools | Search this Thread |
|
|
#1 |
|
I am having a problem with my web page timng out while retrieving a long
runnign report (90-120 seconds. I have tried modifying several settings in various places and cannot get it to run for more than 90 seconds. I am running VS.Net and the app is ASP.Net, written using VB.Net. The app calls an asp.Net web service to retrieve the report. Both the web site and the web service are running locally on my PC. I have tried modifying the executionTimeout setting in Web.Config for both the site and the web service, and I have also modified the executionTimeout setting in machine.config. In all cases the value is set to 300 (seconds). ..Net Version is 1.1.4322.2032. I also tried modifying my web site to timeout in 300 seconds using Server.ScriptTimeout = 300 with no effect. Both the web site and the web service have been compiled as "release", and not as "debug". If anyone can provide any suggestions, I would very much apreciate it. Below are sections of each of my config files. System.web settings for My web site web.config <system.web> <compilation defaultLanguage="vb" debug="false" /> <httpRuntime executionTimeout="300" maxRequestLength="4096" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100" enableVersionHeader="true"/> ..... </system.web> System.web settings for My web service web.config <system.web> <compilation defaultLanguage="vb" debug="false" /> <httpRuntime executionTimeout="300" maxRequestLength="4096" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100" enableVersionHeader="true"/> ..... </system.web> System.web settings from machine.config <system.web> <httpRuntime executionTimeout="300" maxRequestLength="4096" useFullyQualifiedRedirectUrl="false" minFreeThreads="8" minLocalRequestFreeThreads="4" appRequestQueueLimit="100" enableVersionHeader="true"/> <compilation debug="false" explicit="true" defaultLanguage="vb"> ... </system.web> Jim Underwood |
|
|
|
|
#2 |
|
Posts: n/a
|
Hi Jim,
Can you provide the error message you're getting? It could be a timeout from your database, database connection, or command object. HTH, Chris Chris Fulstow |
|
|
|
#3 |
|
Posts: n/a
|
the webservice call can also timeout. you need to set its timeout also.
-- bruce (sqlwork.com) "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message news:... >I am having a problem with my web page timng out while retrieving a long > runnign report (90-120 seconds. I have tried modifying several settings > in > various places and cannot get it to run for more than 90 seconds. > > I am running VS.Net and the app is ASP.Net, written using VB.Net. The app > calls an asp.Net web service to retrieve the report. Both the web site > and > the web service are running locally on my PC. > > I have tried modifying the executionTimeout setting in Web.Config for both > the site and the web service, and I have also modified the > executionTimeout > setting in machine.config. In all cases the value is set to 300 > (seconds). > > .Net Version is 1.1.4322.2032. > > I also tried modifying my web site to timeout in 300 seconds using > Server.ScriptTimeout = 300 > with no effect. > > Both the web site and the web service have been compiled as "release", and > not as "debug". > > If anyone can provide any suggestions, I would very much apreciate it. > > Below are sections of each of my config files. > > System.web settings for My web site web.config > <system.web> > <compilation defaultLanguage="vb" debug="false" /> > <httpRuntime executionTimeout="300" maxRequestLength="4096" > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > enableVersionHeader="true"/> > .... > </system.web> > > System.web settings for My web service web.config > <system.web> > <compilation defaultLanguage="vb" debug="false" /> > <httpRuntime executionTimeout="300" maxRequestLength="4096" > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > enableVersionHeader="true"/> > .... > </system.web> > > System.web settings from machine.config > <system.web> > <httpRuntime executionTimeout="300" maxRequestLength="4096" > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > enableVersionHeader="true"/> > <compilation debug="false" explicit="true" defaultLanguage="vb"> > ... > </system.web> > > bruce barker \(sqlwork.com\) |
|
|
|
#4 |
|
Posts: n/a
|
The operation has timed-out.
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.Net.WebException: The operation has timed-out. 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: [WebException: The operation has timed-out.] System.Web.Services.Protocols.WebClientProtocol.Ge tWebResponse(WebRequest request) +58 System.Web.Services.Protocols.HttpWebClientProtoco l.GetWebResponse(WebReques t request) +5 System.Web.Services.Protocols.SoapHttpClientProtoc ol.Invoke(String methodName, Object[] parameters) +183 ReportDistribution.CrystalWeb.crystal.GetReport(St ring strReportName, String strLogin, String strPassword, String strDatabase, String strServer, String[] colParams, String[] colValues, String strReport, String strType) +173 ReportDistribution.RunReport.Button1_Click(Object sender, EventArgs e) +229 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() +1292 ---------------------------------------------------------------------------- ---- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 "Chris Fulstow" <> wrote in message news: oups.com... > Hi Jim, > > Can you provide the error message you're getting? > It could be a timeout from your database, database connection, or > command object. > > HTH, > > Chris > Jim Underwood |
|
|
|
#5 |
|
Posts: n/a
|
I set the timeout on the machine.config, and the web.config for both the web
site and the web service that it is calling. And I restarted IIS, and then rebooted when that didn't work. Still, the request times out after 90 seconds. Any ideas? "bruce barker (sqlwork.com)" <> wrote in message news:%... > the webservice call can also timeout. you need to set its timeout also. > > -- bruce (sqlwork.com) > > > > "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message > news:... > >I am having a problem with my web page timng out while retrieving a long > > runnign report (90-120 seconds. I have tried modifying several settings > > in > > various places and cannot get it to run for more than 90 seconds. > > > > I am running VS.Net and the app is ASP.Net, written using VB.Net. The app > > calls an asp.Net web service to retrieve the report. Both the web site > > and > > the web service are running locally on my PC. > > > > I have tried modifying the executionTimeout setting in Web.Config for both > > the site and the web service, and I have also modified the > > executionTimeout > > setting in machine.config. In all cases the value is set to 300 > > (seconds). > > > > .Net Version is 1.1.4322.2032. > > > > I also tried modifying my web site to timeout in 300 seconds using > > Server.ScriptTimeout = 300 > > with no effect. > > > > Both the web site and the web service have been compiled as "release", and > > not as "debug". > > > > If anyone can provide any suggestions, I would very much apreciate it. > > > > Below are sections of each of my config files. > > > > System.web settings for My web site web.config > > <system.web> > > <compilation defaultLanguage="vb" debug="false" /> > > <httpRuntime executionTimeout="300" maxRequestLength="4096" > > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > > enableVersionHeader="true"/> > > .... > > </system.web> > > > > System.web settings for My web service web.config > > <system.web> > > <compilation defaultLanguage="vb" debug="false" /> > > <httpRuntime executionTimeout="300" maxRequestLength="4096" > > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > > enableVersionHeader="true"/> > > .... > > </system.web> > > > > System.web settings from machine.config > > <system.web> > > <httpRuntime executionTimeout="300" maxRequestLength="4096" > > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > > enableVersionHeader="true"/> > > <compilation debug="false" explicit="true" defaultLanguage="vb"> > > ... > > </system.web> > > > > > > Jim Underwood |
|
|
|
#6 |
|
Posts: n/a
|
Are you saying I need to set the web service timeout in the calling
application? "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message news:... > I set the timeout on the machine.config, and the web.config for both the web > site and the web service that it is calling. > > And I restarted IIS, and then rebooted when that didn't work. > > Still, the request times out after 90 seconds. > > Any ideas? > > "bruce barker (sqlwork.com)" <> wrote > in message news:%... > > the webservice call can also timeout. you need to set its timeout also. > > > > -- bruce (sqlwork.com) > > > > > > > > "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message > > news:... > > >I am having a problem with my web page timng out while retrieving a long > > > runnign report (90-120 seconds. I have tried modifying several settings > > > in > > > various places and cannot get it to run for more than 90 seconds. > > > > > > I am running VS.Net and the app is ASP.Net, written using VB.Net. The > app > > > calls an asp.Net web service to retrieve the report. Both the web site > > > and > > > the web service are running locally on my PC. > > > > > > I have tried modifying the executionTimeout setting in Web.Config for > both > > > the site and the web service, and I have also modified the > > > executionTimeout > > > setting in machine.config. In all cases the value is set to 300 > > > (seconds). > > > > > > .Net Version is 1.1.4322.2032. > > > > > > I also tried modifying my web site to timeout in 300 seconds using > > > Server.ScriptTimeout = 300 > > > with no effect. > > > > > > Both the web site and the web service have been compiled as "release", > and > > > not as "debug". > > > > > > If anyone can provide any suggestions, I would very much apreciate it. > > > > > > Below are sections of each of my config files. > > > > > > System.web settings for My web site web.config > > > <system.web> > > > <compilation defaultLanguage="vb" debug="false" /> > > > <httpRuntime executionTimeout="300" maxRequestLength="4096" > > > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > > > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > > > enableVersionHeader="true"/> > > > .... > > > </system.web> > > > > > > System.web settings for My web service web.config > > > <system.web> > > > <compilation defaultLanguage="vb" debug="false" /> > > > <httpRuntime executionTimeout="300" maxRequestLength="4096" > > > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > > > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > > > enableVersionHeader="true"/> > > > .... > > > </system.web> > > > > > > System.web settings from machine.config > > > <system.web> > > > <httpRuntime executionTimeout="300" maxRequestLength="4096" > > > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > > > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > > > enableVersionHeader="true"/> > > > <compilation debug="false" explicit="true" defaultLanguage="vb"> > > > ... > > > </system.web> > > > > > > > > > > > > Jim Underwood |
|
|
|
#7 |
|
Posts: n/a
|
You need Command.TimeOut, not connection or Server.Timeout
Jeff "bruce barker (sqlwork.com)" <> wrote in message news:%... > the webservice call can also timeout. you need to set its timeout also. > > -- bruce (sqlwork.com) > > > > "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message > news:... >>I am having a problem with my web page timng out while retrieving a long >> runnign report (90-120 seconds. I have tried modifying several settings >> in >> various places and cannot get it to run for more than 90 seconds. >> >> I am running VS.Net and the app is ASP.Net, written using VB.Net. The >> app >> calls an asp.Net web service to retrieve the report. Both the web site >> and >> the web service are running locally on my PC. >> >> I have tried modifying the executionTimeout setting in Web.Config for >> both >> the site and the web service, and I have also modified the >> executionTimeout >> setting in machine.config. In all cases the value is set to 300 >> (seconds). >> >> .Net Version is 1.1.4322.2032. >> >> I also tried modifying my web site to timeout in 300 seconds using >> Server.ScriptTimeout = 300 >> with no effect. >> >> Both the web site and the web service have been compiled as "release", >> and >> not as "debug". >> >> If anyone can provide any suggestions, I would very much apreciate it. >> >> Below are sections of each of my config files. >> >> System.web settings for My web site web.config >> <system.web> >> <compilation defaultLanguage="vb" debug="false" /> >> <httpRuntime executionTimeout="300" maxRequestLength="4096" >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" >> enableVersionHeader="true"/> >> .... >> </system.web> >> >> System.web settings for My web service web.config >> <system.web> >> <compilation defaultLanguage="vb" debug="false" /> >> <httpRuntime executionTimeout="300" maxRequestLength="4096" >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" >> enableVersionHeader="true"/> >> .... >> </system.web> >> >> System.web settings from machine.config >> <system.web> >> <httpRuntime executionTimeout="300" maxRequestLength="4096" >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" >> enableVersionHeader="true"/> >> <compilation debug="false" explicit="true" defaultLanguage="vb"> >> ... >> </system.web> >> >> > > Jeff Dillon |
|
|
|
#8 |
|
Posts: n/a
|
Isn't Command.Timeout for database connections? I am dealing with Crystal
reports DLLs that run reports and return a file to the web service, which returns them to my web app. The database connections do not appear to be a problem, although I am nto ruling anythign at just yet. I have set my Webservice.Timeout=300000 (milliseconds I think, since 300 timed out instantly) in the code that calls the web service, and now I am getting an error at 5 minutes instead of 90 seconds. From what can see it seems to be working as I want it, but more testing is needed. I am purposely sending bad criteria to make the report run for a longer period, so I can see what effect the parameters have. Once I figure out just what makes the difference I'll post the solution here. In the mean time, any additional advice is apreciated. "Jeff Dillon" <> wrote in message news:... > You need Command.TimeOut, not connection or Server.Timeout > > Jeff > "bruce barker (sqlwork.com)" <> wrote > in message news:%... > > the webservice call can also timeout. you need to set its timeout also. > > > > -- bruce (sqlwork.com) > > > > > > > > "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message > > news:... > >>I am having a problem with my web page timng out while retrieving a long > >> runnign report (90-120 seconds. I have tried modifying several settings > >> in > >> various places and cannot get it to run for more than 90 seconds. > >> > >> I am running VS.Net and the app is ASP.Net, written using VB.Net. The > >> app > >> calls an asp.Net web service to retrieve the report. Both the web site > >> and > >> the web service are running locally on my PC. > >> > >> I have tried modifying the executionTimeout setting in Web.Config for > >> both > >> the site and the web service, and I have also modified the > >> executionTimeout > >> setting in machine.config. In all cases the value is set to 300 > >> (seconds). > >> > >> .Net Version is 1.1.4322.2032. > >> > >> I also tried modifying my web site to timeout in 300 seconds using > >> Server.ScriptTimeout = 300 > >> with no effect. > >> > >> Both the web site and the web service have been compiled as "release", > >> and > >> not as "debug". > >> > >> If anyone can provide any suggestions, I would very much apreciate it. > >> > >> Below are sections of each of my config files. > >> > >> System.web settings for My web site web.config > >> <system.web> > >> <compilation defaultLanguage="vb" debug="false" /> > >> <httpRuntime executionTimeout="300" maxRequestLength="4096" > >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > >> enableVersionHeader="true"/> > >> .... > >> </system.web> > >> > >> System.web settings for My web service web.config > >> <system.web> > >> <compilation defaultLanguage="vb" debug="false" /> > >> <httpRuntime executionTimeout="300" maxRequestLength="4096" > >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > >> enableVersionHeader="true"/> > >> .... > >> </system.web> > >> > >> System.web settings from machine.config > >> <system.web> > >> <httpRuntime executionTimeout="300" maxRequestLength="4096" > >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > >> enableVersionHeader="true"/> > >> <compilation debug="false" explicit="true" defaultLanguage="vb"> > >> ... > >> </system.web> > >> > >> > > > > > > Jim Underwood |
|
|
|
#9 |
|
Posts: n/a
|
Um, no connection timeout is for database connections timeout. Command
timeout is for sql command timouts, which is what you are experiencing. When you run the query in SQL Analyzer, how long does it take? Of course the the shortest timeout, the Webservice timeout or command timeout, will happen first. If your command takes longer than the webservice timeout, you'll get that error. Database connections always happen very fast, it's the queries (commands) that can take awhile. First, you need to fix your SQL! Jeff "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message news:... > Isn't Command.Timeout for database connections? I am dealing with Crystal > reports DLLs that run reports and return a file to the web service, which > returns them to my web app. The database connections do not appear to be > a > problem, although I am nto ruling anythign at just yet. > > I have set my Webservice.Timeout=300000 (milliseconds I think, since 300 > timed out instantly) in the code that calls the web service, and now I am > getting an error at 5 minutes instead of 90 seconds. From what can see > it > seems to be working as I want it, but more testing is needed. I am > purposely sending bad criteria to make the report run for a longer period, > so I can see what effect the parameters have. > > Once I figure out just what makes the difference I'll post the solution > here. In the mean time, any additional advice is apreciated. > > > "Jeff Dillon" <> wrote in message > news:... >> You need Command.TimeOut, not connection or Server.Timeout >> >> Jeff >> "bruce barker (sqlwork.com)" <> > wrote >> in message news:%... >> > the webservice call can also timeout. you need to set its timeout also. >> > >> > -- bruce (sqlwork.com) >> > >> > >> > >> > "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message >> > news:... >> >>I am having a problem with my web page timng out while retrieving a >> >>long >> >> runnign report (90-120 seconds. I have tried modifying several > settings >> >> in >> >> various places and cannot get it to run for more than 90 seconds. >> >> >> >> I am running VS.Net and the app is ASP.Net, written using VB.Net. The >> >> app >> >> calls an asp.Net web service to retrieve the report. Both the web >> >> site >> >> and >> >> the web service are running locally on my PC. >> >> >> >> I have tried modifying the executionTimeout setting in Web.Config for >> >> both >> >> the site and the web service, and I have also modified the >> >> executionTimeout >> >> setting in machine.config. In all cases the value is set to 300 >> >> (seconds). >> >> >> >> .Net Version is 1.1.4322.2032. >> >> >> >> I also tried modifying my web site to timeout in 300 seconds using >> >> Server.ScriptTimeout = 300 >> >> with no effect. >> >> >> >> Both the web site and the web service have been compiled as "release", >> >> and >> >> not as "debug". >> >> >> >> If anyone can provide any suggestions, I would very much apreciate it. >> >> >> >> Below are sections of each of my config files. >> >> >> >> System.web settings for My web site web.config >> >> <system.web> >> >> <compilation defaultLanguage="vb" debug="false" /> >> >> <httpRuntime executionTimeout="300" maxRequestLength="4096" >> >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" >> >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" >> >> enableVersionHeader="true"/> >> >> .... >> >> </system.web> >> >> >> >> System.web settings for My web service web.config >> >> <system.web> >> >> <compilation defaultLanguage="vb" debug="false" /> >> >> <httpRuntime executionTimeout="300" maxRequestLength="4096" >> >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" >> >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" >> >> enableVersionHeader="true"/> >> >> .... >> >> </system.web> >> >> >> >> System.web settings from machine.config >> >> <system.web> >> >> <httpRuntime executionTimeout="300" maxRequestLength="4096" >> >> useFullyQualifiedRedirectUrl="false" minFreeThreads="8" >> >> minLocalRequestFreeThreads="4" appRequestQueueLimit="100" >> >> enableVersionHeader="true"/> >> >> <compilation debug="false" explicit="true" defaultLanguage="vb"> >> >> ... >> >> </system.web> >> >> >> >> >> > >> > >> >> > > Jeff Dillon |
|
|
|
#10 |
|
Posts: n/a
|
Thanks to Bruce, I think I have resolved the issue. Essentially, I needed
three settings. First, I needed to set the executionTimeout in the web.config for my web app, as well as the web service it was calling. I think I could also have changed only the machine.config since these are on the same box, but that is undesirable since it would affect every web app on the box. Here is the setting I added to each web.config file, within the system.web section: <httpRuntime executionTimeout="300" /> I also had to add a line to my code where I call the web service, since there is a timeout on the client side (in this case my web app is the client of the web service) of this as well. MyRepWeb is the name of my web service object. I set this just after instantiating the object, just before calling the method to retrieve the report file. MyRepWeb.Timeout = 3000000 Thanks all for the suggestions. "Jim Underwood" <james.underwoodATfallonclinic.com> wrote in message news:... > I am having a problem with my web page timng out while retrieving a long > runnign report (90-120 seconds. I have tried modifying several settings in > various places and cannot get it to run for more than 90 seconds. > > I am running VS.Net and the app is ASP.Net, written using VB.Net. The app > calls an asp.Net web service to retrieve the report. Both the web site and > the web service are running locally on my PC. > > I have tried modifying the executionTimeout setting in Web.Config for both > the site and the web service, and I have also modified the executionTimeout > setting in machine.config. In all cases the value is set to 300 (seconds). > > .Net Version is 1.1.4322.2032. > > I also tried modifying my web site to timeout in 300 seconds using > Server.ScriptTimeout = 300 > with no effect. > > Both the web site and the web service have been compiled as "release", and > not as "debug". > > If anyone can provide any suggestions, I would very much apreciate it. > > Below are sections of each of my config files. > > System.web settings for My web site web.config > <system.web> > <compilation defaultLanguage="vb" debug="false" /> > <httpRuntime executionTimeout="300" maxRequestLength="4096" > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > enableVersionHeader="true"/> > .... > </system.web> > > System.web settings for My web service web.config > <system.web> > <compilation defaultLanguage="vb" debug="false" /> > <httpRuntime executionTimeout="300" maxRequestLength="4096" > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > enableVersionHeader="true"/> > .... > </system.web> > > System.web settings from machine.config > <system.web> > <httpRuntime executionTimeout="300" maxRequestLength="4096" > useFullyQualifiedRedirectUrl="false" minFreeThreads="8" > minLocalRequestFreeThreads="4" appRequestQueueLimit="100" > enableVersionHeader="true"/> > <compilation debug="false" explicit="true" defaultLanguage="vb"> > ... > </system.web> > > Jim Underwood |
|