469,291 Members | 1,733 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,291 developers. It's quick & easy.

ASP.NET Stops Responding.

Hi all,

We've got a page that executes a stored proc on SQL Server. The stored proc completes. I know this because I've checked using profiler. But for some reason our web page simply "hangs" and does not continue on to next task.

The code runs successfully on IIS v5.1, but is hanging on IIS version 6.0. Please help.

Regards,
Craig.
Jul 28 '06 #1
5 1678
sashi
1,754 Expert 1GB
Hi there,

i had this kind of problem once.. check the script timeout period.. take care
Jul 28 '06 #2
Hi there,

i had this kind of problem once.. check the script timeout period.. take care
Hi Sashi,

Thanks for responding. We have checked all the timeout options and set them to very large numbers. Still get the issue tho'.

Cheers
Craig.
Jul 30 '06 #3
sashi
1,754 Expert 1GB
Hi Graig,

what is the size of your database? is it very large? try compacting/shrinking the database.. take care and good luck my fren.. :)

oh.. yeah.. what is the current service pack? try updating the service pack for the OS as well as SQL Server.. not to forget MDAC.. Microsoft Data Access Component..
Jul 30 '06 #4
Hi there,

Thanks for your reply. What this is doing is importing a file and validating the columns row by row. So SQL Server size is not important. It's processing 5000 rows and SQL Server looks to complete ok and it drops the connection when it's done. If we remote into the server and do it "locally" the process completes ok. So it's got to be a timeout issue. Thing is we've set all the timeouts to a crazy number of seconds!

Do you have any further thoughts? Is there a maximum allowed value for timeouts that we might be blowing as we're setting it so large?

Any help would be greatly appreciated.

Cheers
C.
Jul 31 '06 #5
Hi Graig,

what is the size of your database? is it very large? try compacting/shrinking the database.. take care and good luck my fren.. :)

oh.. yeah.. what is the current service pack? try updating the service pack for the OS as well as SQL Server.. not to forget MDAC.. Microsoft Data Access Component..

Sashi,

It turns out that there is a machine.config based value that times the page out at three minutes. It's called Interval Timeout or something. We set that to 20 minutes and the page is still timing out.

Arrgghh! Any further ideas would be appreciated.

Cheers
C
Jul 31 '06 #6

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by Lior M | last post: by
7 posts views Thread by mjkahn | last post: by
2 posts views Thread by Nils Hedström | last post: by
9 posts views Thread by Dan S | last post: by
4 posts views Thread by Michael | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.