Skip to Content
author's profile photo Former Member
Former Member

Load Report Failed

Hello,

Could someone please help me on this? I use Crystal Report bundled with VS.NET 2005 and I am getting "Load Report failed" from time to time in production. Most of times it works fine. It seems the problem appears when more people are viewing the reports. The only solution now is to restart the IIS but it becomes very difficult as it is production box. I have assigned full control on c:\windows\Temp to Network Service account, and dispose the Crystal Reports objects when page is unloaded. Any advice will be very appreciated.

Frank

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 05, 2008 at 04:52 AM

    Intermittent under load issues with ASP.NET resolved only by restarting IIS is suggestive of memory fragmentation issues, i.e., long-lived processes may have free memory so fragmented that a alloc of some size may fail, leading to strange IO or loading errors.

    I'd try recycling the IIS app pool more regularly, if you haven't tried that already. A basic guide can be found here:

    [http://technet.microsoft.com/en-us/magazine/cc161040(TechNet.10).aspx|http://technet.microsoft.com/en-us/magazine/cc161040(TechNet.10).aspx]

    Sincerely,

    Ted Ueda

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello Frank,

      The CR.NET creates temp rpt files that it then processes - your post suggests issues with cleanup.

      I'd recommend, if not being done already, more stringent cleanup be done after a Report object is done with:

      crReport.Close();

      crReport.Dispose();

      // If above does not resolve, explicitly invoking a GC cycle afterwards may help:

      // GC.Collect();

      You've indicated that it's not a permissions issue with the Temp folder, and I'm also inferring that the Temp folder still has plenty of space when the issue happens.

      Sincerely,

      Ted Ueda

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.