Server Unavailable

Question

Post reply

Server Unavailable

Mahathi

Old Hand

Points: 320
More actions
June 22, 2006 at 5:45 am

#114561

Hi
I have a stored procedure which is used to insert multiple rows into a database. After the stored procedure is completed, when I started my application which uses this stored pocedure, i got a problem like
"The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. "
And when I saw the Event Log File there is no description for the error. Can anyone tell me what the problem may be. Please reply fastly. Thanks in advance.

Regards
Mahathi.

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

SwePeso SSC-Dedicated Points: 39757 More actions · Answer 1

Can be a number of sources for the error you experience.

Is IIS running?
Is there a session time-out?
Is network accesible?
Is DNS server functional?

N 56°04'39.16"
E 12°55'05.25"

Prakash Sawant SSCrazy Points: 2173 More actions · Answer 2

You can even check for the application user access to the DB OR Stored Procedure.

------------
Prakash Sawant

http://psawant.blogspot.com

Mahathi Old Hand Points: 320 More actions · Answer 3

Hi

Thank you for the help provided. I will try this out and let you know whether it is working or not.

Mahathi.

Mahathi Old Hand Points: 320 More actions · Answer 4

Hi

The description of the error is as follows. Can you please tell me what to do.

Event ID:

1001

Source:

ASP.NET 1.1.4322.0

aspnet_wp.exe (PID:3152) was recycled because memory consumption exceeded the 608MB(60 percent of available RAM).

Please send me the solution for this. I will be thankful for any solution given.

Mahathi.

Prakash Sawant SSCrazy Points: 2173 More actions · Answer 5

What i think is its something to do with the memory management on the server.

You can monitor the server for memory utilization by ASP & how the pooling is handled on the server.

------------
Prakash Sawant

http://psawant.blogspot.com

Mahathi Old Hand Points: 320 More actions · Answer 6

If you don't mind please tell me what is meant by "Connection Pooling". Since I am new to development I have no idea on the topic. Thank you for sending me the previous reply.

Mahathi.

Prakash Sawant SSCrazy Points: 2173 More actions · Answer 7

This should be helpful...

http://www.15seconds.com/issue/040830.htm

------------
Prakash Sawant

http://psawant.blogspot.com

Bill Scott SSCrazy Points: 2338 More actions · Answer 8

I had a similar problem. I was working in SQL Reporting Services and had a very large dataset. every time i ran it, the ASP reset itself, it takes about 15 minutes to reset and then things work fine until you run the query that produces the huge dataset again. I had to rework the report to use smaller data sets.

Does anyone know if there is a way to tell ASP to use more memory or perhaps to use the page file when it gets these big datasets?

Mahathi Old Hand Points: 320 More actions · Answer 9

Hi Prakash Sawant

Thank you for sending me the link. I read it and it gave me the idea of connection pooling.

Mahathi.