471,595 Members | 1,774 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,595 software developers and data experts.

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 1702
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 leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.