Timeout

General Web Coding Microsoft Development
1

Hi all,

i have a small app using ASP and an MSSQL db.

On some pages, i am getting an error “[COLOR=“Blue”]Timeout expired”. No error number or anything.

i have already set “[COLOR=“Purple”]Server.ScriptTimeout [COLOR=“Blue”]= [COLOR=“Red”]3600” in the code, so it should be an issue, and as it is, the pages loads over about 20 secs and then displays as is with the above error message- so its not even waiting minutes for the script.

any ideas what this could indicate?

thanks!

2

The server stops it at 60 seconds, if it is dying at 20, I am not sure what is causing that.

3

[QUOTE=Stephen]
The server stops it at 60 seconds, if it is dying at 20, I am not sure what is causing that.
[/QUOTE]

mmm… 2 questions then:

  1. even if it does get to 60 secs (which it doesnt) - shouldnt my “[COLOR=“Purple”]Server.ScriptTimeout [COLOR=“Blue”]= [COLOR=“Red”]3600” Ovreride that?

and

  1. Sometimes - the same page can display perfectly, and othertimes (within minutes or seconds) will give the timeout error. what could the reason to this discrepancy be?
4

the timeout error is coming from SQL, changing the asp timeout won’t fix that. Figure out what’s going on with your query or the db and you’ll be good to go.

5

thanks J.
i guess its just frustrating 'cos its not consistent

6

The ASP timeout on the server settings overrides what you set :slight_smile:

If you cna view output of the error(timeout), I suspect SQL may be throwing a SQL Cost error, saying that the query will exceed the cost limit of 60.

7

ok, thanks Stephen