Load Report Failed Error - Crystal XI and .NET

[Former Member]

We have been getting the “Load Report Failed” error messages after moving a large number of reports to the web.  The errors happen intermittently, sometimes once or twice a day, without any particular pattern.  We can’t re-produce the problem in our Test or Development environments even though we used the production machine image. 

We are currently using CrystalXI with .Net and we are not using Crystal Report Server.  To fix the problem, we usually have to reset the app pool for the problem to go away.  We looked at all the suggestions posted on this site and tried different things like using ProcMon but couldn't see anything. Does anyone have any new suggestions to troubleshoot/resolve this issue?

Here are some error messages that we typically get.

Example 1

1. System.Exception: Load report failed. ---> System.Runtime.InteropServices.COMException (0x800002AD): Error in File C:\WINDOWS\TEMP\IndividualProjectDetail {2323425D-5BB4-43FF-B5AE-1DF82F4FFB55}.rpt:

The request could not be submitted for background processing.

   at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()

   --- End of inner exception stack trace ---

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()

   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)

   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)

   at CrystalXI._Default.BuildReport(String AppName, String ReportName, TableLogOnInfo crLogonInfo, ReportDocument crReportDoc, String Type) in C:\SourceCode\CrystalXI\Development\Source\Default.aspx.cs:line 170

   at CrystalXI._Default.PrepareReport() in C:\SourceCode\CrystalXI\Development\Source\Default.aspx.cs:line 103

   at CrystalXI._Default.Page_Load(Object sender, EventArgs e) in C:\SourceCode\CrystalXI\Development\Source\Default.aspx.cs:line 38

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Example 2

1. System.Exception: Load report failed. ---> System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

   at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()

   --- End of inner exception stack trace ---

   at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()

   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)

   at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename)

   at CrystalXI._Default.BuildReport(String AppName, String ReportName, TableLogOnInfo crLogonInfo, ReportDocument crReportDoc, String Type) in C:\SourceCode\CrystalXI\Development\Source\Default.aspx.cs:line 170

   at CrystalXI._Default.PrepareReport() in C:\SourceCode\CrystalXI\Development\Source\Default.aspx.cs:line 119

   at CrystalXI._Default.Page_Load(Object sender, EventArgs e) in C:\SourceCode\CrystalXI\Development\Source\Default.aspx.cs:line 38

   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)

   at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)

   at System.Web.UI.Control.OnLoad(EventArgs e)

   at System.Web.UI.Control.LoadRecursive()

   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

[saurabh_pathak · Accepted solution]

Could you please provide following:

1. Are you using XI R2?What is the patch level?
2. Visual Studio being used by you?
3. What happens if you store reportclientdocument object in Session?
4. Are you serializing and deserializing reportclientdocument by any chance?
5. OS where application is deployed? x86 or x64

~ Saurabh

[Former Member · Accepted solution]

Thank you for your reply!  Please see the answers below.

1. Are you using XI R2?What is the patch level?  No service pack
2. Visual Studio being used by you?  Yes, we are using VS 2010
3. What happens if you store reportclientdocument object in Session? We haven't tried that.  Do you think that would make a difference?
4. Are you serializing and deserializing reportclientdocument by any chance? No
5. OS where application is deployed? x86 or x64 - Application run on X86 machine