Crystal Reports Viewer SP36 - Load report failed in SAP Crystal Reports

[Nirab]

Hi,

I am getting below error on our prod servers when users try to generate crystal reports.

Load report failed. 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)

The crystal report runtimes which are installed on server are below. Apart from below we do not have any other crystal related software installed on server -

• SAP Crystal Reports runtime engine for .NET Framework (32 bit) - 13.0.36.5040
• SAP Crystal Reports runtime engine for .NET Framework (64 bit) - 13.0.36.5040

We have below configuration on our servers -

• OS - Windows Server 2022
• IIS 10
• RAM - 16 GB

Some key notes-

The "Load report failed" issue is intermittent. When the issue comes for any report , our support team recycles the IIS app pool and the error usually not comes for some time (but it appears again after some days/ hours).

The issue comes up on many of our servers, but it is quite frequent for those of our clients who have huge volume data in reports. We have some other downloadable CSV reports apart from crystal reports.

We have a good and ample disk size on each of our servers.

Workaround tried so far -

PrintJobLimit - Currently it is set to 75 (default) on our servers. We tried modifying this to 500 and even -1 but this not resolves the issue.

Temp folder permissions - Permissions seems ok on our servers. Also the issue is intermittent so the reason of permission issue can be ruled out.

Report Code Cleanup / Object Disposition - We are using below code lines in our Page_Unload event for report object disposition -

Reportdocument.Close()

Reportdocument.Dispose()

Please advise on what I should do to permanently remove this load report failed error for my clients.

Thanks in advance.

SAP Crystal Reports viewer