473,387 Members | 1,582 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 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 1884
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

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

Similar topics

0
by: Lior M | last post by:
Hello everyone I'm having a little problem where my mysql 4.0.21 for some reason stops "responding" until I do a flush-hosts. This is happening almost every day. It's a pretty heavy loaded...
0
by: Michael Bourgon | last post by:
I've been having the same problem for 2 weeks now. If anyone has any ideas, I'd love to hear them. We are using both SQL and Windows Authentication. I was running a Profiler Trace at the time,...
7
by: mjkahn | last post by:
Everything runs fine for a while (weeks even), and then IIS stops responding to (or even logging) requests for ASP pages. HTML pages are served up just fine. I'm running Windows 2000 SP4, and...
3
by: TM360 | last post by:
I realize this may not be the right group to post this, but I'm not having much success elsewhere so I thought I'd give it a try... In our application we have a link that opens a new window...
2
by: Nils Hedström | last post by:
Today my stateserver (running at the same computer at the web-server) suddenly stopped responding (after 10 days working perfectly). I did not see any entry in the eventlog indicating that the...
0
by: dotnet user | last post by:
I have a asp.net webpage which has aroud 20 steps as hyperlink. when start button is clicked, then step1 starts which does some operation in db and returns some value, based on that value i post...
5
by: jobi | last post by:
Hi, I'm trying to develop this vb.net application which gathers info. When I start the gathering process, I refresh text-fields in the form to see progress and to see where it gets. This works...
9
by: Dan S | last post by:
I have a .NET web service running on a 2K box and IIS 5. We've experienced it twice now where the service stops responding to any type of request after running succesfully for a month or so. The...
4
by: Michael | last post by:
Hi Everyone, I hope someone else has had this problem. I recently started to use VS 2005 (vb.net) and today alone I have had to close VS 8 times while trying to code. I have a least 130 controls...
3
by: Jakes | last post by:
I need to associate the elements of a bool type matrix with the state of a checkbox from an array that i've created. For example: if the element checkBoxMatrix is checked then the the element in...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.