CodeVerge.Net Beta


   Explore    Item Entry   Register  Login  
Microsoft News
Asp.Net Forums
IBM Software
Borland Forums
Adobe Forums
Novell Forums




Can Reply:  No Members Can Edit: No Online: Yes
Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.custom_modules Tags:
Item Type: NewsGroup Date Entered: 10/19/2004 7:07:28 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
NR
XPoints: N/A Replies: 3 Views: 131 Favorited: 0 Favorite
4 Items, 1 Pages 1 |< << Go >> >|
samkuehn
Asp.Net User
Long running queries times out..10/19/2004 7:07:28 PM

0

I have a module that runs a error that takes a long time (expected). The module is timing out with an error:

A critical error has occurred.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The stored proc that the module calls just takes too long to run. Is there anyway to overide the timeout or something? It would be great if I could have the module display an animated gif that says please wait while the query completes. Even if it displays nothing I need to give the query time to complete so that I can desplay the data.

Any ideas?
cathal
Asp.Net User
Re: Long running queries times out..10/19/2004 11:44:19 PM

0

You can increase the script timeout of the page by altering the httpRuntime executionTimeout="seconds" value in the web.config, but this can cause the user to think that the application is broken.

Unfortunately in ado.net there is little support for asynchronous actions i.e. where you send a query and can leave before the operation is finished, returning later to get the results (happily this is in ado.net 2 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/async2.asp). There are ways to fudge this, which usually involve writing files to locations . These then get picked up by a services which runs every few seconds, processes the query outside the page context and then writes the results to a table. Meanwhile the page that created the file has been using a meta-refresh to check to see if the query results are there, and when they are displays them. If you check about you can find some examples, the only one i have to hand is http://www.west-wind.com/presentations/wwAsyncWebRequest/wwAsyncWebRequest.htm

Cathal
samkuehn
Asp.Net User
Re: Long running queries times out..10/21/2004 6:10:06 PM

0

I tried changing the executionTimeout="" in the web.config and it didn't seem to work. The query still times out after about 40 seconds or so. Is the exception is being generated by the SqlHelper in the Data Access Application Block?
cathal
Asp.Net User
Re: Long running queries times out..10/21/2004 8:59:09 PM

0

the execution timeout is also set in the machine.config . By default it's 90 seconds, so if you don't set one in the web.config, that's how long the timeout usually is. If yours is failing after 40 seconds it would suggest thats the value in machine.config, and that the machine.config has been set to ignore any web.config overrides, which many hosting providers will do to stop a small number of users overtax their servers.

Cathal
4 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
DNS and BIND Authors: Paul Albitz, Pages: 616, Published: 2006
Intelligent tutoring systems: 6th International Conference, ITS 2002, Biarritz, France and San Sebastián, Spain, June 2-7, 2002 : proceedings Authors: Stefano A. Cerri, Guy Gouardères, Fábio Paraguaçu, Pages: 1016, Published: 2002

Web:
long-running query times out in 20 minutes in PIA regardless of ... Message in peopletools-l discussion group regarding long-running query times out in 20 minutes in PIA regardless of configuration.
How to log long-running queries (ODBC) Set a query time-out interval, in milliseconds, in the Long query time ( milliseconds) box. To log long-running queries data programmatically ...
Long running Operations in Oracle (entries in v$session_longops) Table 1 Query execution time depending on hash area size ... many more things behind the scenes and one cannot find out that just looking at long operation. ...
Finding and Fixing Troublesome long-running ingres Queries Disaster “long-running query” is one that takes too long to run. ..... lock is released or the query times out. The easiest way to identify these problems ...

Long running queries times out.. - ng.asp-net-forum.dotnetnuke ... Long running queries times out.., > ROOT > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.dotnetnuke.custom_modules, ...
DNN Language translation Module - ng.asp-net-forum.dotnetnuke ... DNN Language translation Module - ng.asp-net-forum.dotnetnuke ... long running queries times out.. gallery module · new tttforum . ...
does anyone run dnn with oracle ? - ng.asp-net-forum.dotnetnuke Long running queries times out.. - ng.asp-net-forum.dotnetnuke ... The stored proc that the module calls just takes too long to run. ...
writing files - ng.asp-net-forum.security Long running queries times out.. - ng.asp-net-forum.dotnetnuke ... There are ways to fudge this, which usually involve writing files to ...
Timeout expired. The timeout period elapsed prior .... server is ... Long running queries times out.. - ng.asp-net-forum.dotnetnuke ... Timeout expired. The timeout period elapsed prior to completion of the ...

Videos:
Arena Warsong 10-19 Twink Final My last video at 19... decided to level after a long time at 19, got revered and 3k out of 21k. Will release a new video in upcoming weeks, hope ...
"We Close Our Eyes" by Oingo Boingo on ukulele I meant to post this a long time ago, but it took me a month or two to play it without crying. I think this take sounds kind of detached (and ...
Arena - 19 Twink Warsong My last video at 19... decided to level after a long time at 19, got revered and 3k out of 21k. Will release a new video in upcoming weeks, hope ...
Type Less, Find More: Fast Autocompletion Search with a ... Google TechTalks August 14, 2006 Holger Bast ABSTRACT We consider the following full-text search autocompletion feature. Imagine a user of ...
More to Partake "More to Partake" Lyrics: If you thrill the night Come on out tonight Winter chill excites Shiver little sighs It won't last long It won't ...






create url to point to module

problems sending an email.

iactionable problem

fotovisiondnn

dnndownload no longer available for download !

redirecting to child portal

simple module help

is there a market for dnn 2 modules still?

datalist - edittemplate - calendar link in edit mode

apptheory announces the beta availability of the atgen sdk for dotnetnuke

avcalendar--sql execution resulted in following exceptions

debugging a custom module

scott mcculloch's news articles module dnn 3.0 conversion question

anyone want to demo my dotnetnuke webmail module?

free authentication module

solpart menu token settings

blog - how to

dotnetnuke and implementing iportable with errors.

user data/settings sample?

dnn treeview control

error adding user control to custom module

single login for multiple portals

adding a module in the codebehind ?

new module: smart-thinker webcam

deploy to root

google search module...

dnn 3.0.8 multiple controls and edit controls

access list a list of images within dotnetnuke?

cool menu skin object from scott mcculloch

new module released today - dnnstuff module rotator
   
  Privacy | Contact Us
All Times Are GMT