Server Unavailable

  • 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.

     

  • 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"

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

     

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

    http://psawant.blogspot.com

  • Hi

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

    Mahathi.

  • 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.

  • 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

  • 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.

  • This should be helpful...

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

     

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

    http://psawant.blogspot.com

  • 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?

  • Hi Prakash Sawant

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

    Mahathi.

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

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