Crystal runtime error - Load Report Failed

[#1]

We are running Crystal 11.5 in conjunction with visual studio.NET. We purchased developers licensing for this and we are running Crystal Reports XI Release 2.NET 2005 Server (Version 11.5.0.0) on our iis server. We upgraded from crystal 10 and asp 1.1 to crystal 11.5 and aps2.0 about 2 years ago. Since then, we have had many problems with our existing and new crystal reports. We had no problems prior to the upgrade. Initially we were getting the maximum report exceeded error message - we changed the registry for max reports from 75 to -1. Now we get a load report failed error and have to reset the www service to fix the problem. Is there a fix for this - do we need to upgrade to a different product and if we do, can we use our existing Crystal reports?

[Former Member]

Ludek - SP 6 clearly helped - Monday is a very report intensive day - in the past we had to reset the service 5 or 6 times. We only had to do it once between Thursday night and Monday mid day. Any other suggestions?

URL: http://dla-ss-iis2/dla_intranet/operations/reserve_good_cash.aspx?sl=85

Referer: http://dla-ss-iis2/dla_intranet/operations/reserve_good_cash.aspx?sl=85

IP: 192.168.13.40

Error Message on Inner Exception:Load report failed.

Full Error Message:System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Exception: Load report failed. ---> System.Runtime.InteropServices.COMException (0x80000000): The maximum report processing jobs limit configured by your system administrator has been reached. 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.ReportClass.Load(String reportName, OpenReportMethod openMethod, Int16 parentJob) at CrystalDecisions.CrystalReports.Engine.ReportDocument.EnsureLoadReport() at CrystalDecisions.CrystalReports.Engine.ReportDocument.get_Database() at DLA_Intranet.reserve_good_cash.display_report() in C:\Inetpub\wwwroot\Development\DLA_INTRANET2\Operations\reserve_good_cash.aspx.vb:line 385 at DLA_Intranet.reserve_good_cash.Page_Load(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Development\DLA_INTRANET2\Operations\reserve_good_cash.aspx.vb:line 65 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) --- End of inner exception stack trace --- at System.Web.UI.Page.HandleError(Exception e) at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) at System.Web.UI.Page.ProcessRequest() at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) at System.Web.UI.Page.ProcessRequest(HttpContext context) at ASP.operations_reserve_good_cash_aspx.ProcessRequest(HttpContext context) at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

User: DAVIDLERNER\agrill

Form Values:

__EVENTTARGET:

__EVENTARGUMENT:

__LASTFOCUS:

__EVENTVALIDATION:/wEWKAKZisCGAQKM54rGBgLCi9reAwKUj8fhDAKakYilDALw86GVDwKZnMvlAwL6YyoCgKUgtudBwK2wbTHBgKQ/NFvAvWStNoGAtqplsUMAvygycQJAuG3q68PAsbOjZoFAqvl74QLAujFwJkCAs3cooQIAvWSiJ4NApjxv9wOAvWSnPkFAvWSsNQOAvWSpNYBAvWSuLEKAvv97twGAv790twGAvz97twGAty8tYsBAsWuopUEAty8wYgBAt28tYsBAtK8tYsBAtO8tYsBAu380W8C0pO02gYCt6qWxQwCnMH4rwIC2aHJxAkC85zy/QiB3FRhB8Jo8Ys4eXAzNfwMuuCFA==

txtAccount:

ddBroker:WPIJ

ddBranch:WP

ddReport:All Active Accounts

cv1:_ctl2:_ctl9:1

cv1:_ctl2:_ctl11:AAEAAAD/////AQAAAAAAAAAEAQAAABxTeXN0ZW0uQ29sbGVjdGlvbnMuSGFzaHRhYmxlBwAAAApMb2FkRmFjdG9yB1ZlcnNpb24IQ29tcGFyZXIQSGFzaENvZGVQcm92aWRlcghIYXNoU2l6ZQRLZXlzBlZhbHVlcwAAAwMABQULCBxTeXN0ZW0uQ29sbGVjdGlvbnMuSUNvbXBhcmVyJFN5c3RlbS5Db2xsZWN0aW9ucy5JSGFzaENvZGVQcm92aWRlcgjsUTg/AwAAAAoKCwAAAAkCAAAACQMAAAAQAgAAAAMAAAAGBAAAAA5MYXN0UGFnZU51bWJlcgYFAAAAFUlzTGFzdFBhZ2VOdW1iZXJLbm93bgYGAAAAClBhZ2VOdW1iZXIQAwAAAAMAAAAICAEAAAAIAQAICAEAAAAL

cv1:_ctl2:_ctl13:

cv1:_ctl2:_ctl15:100

hdsl:85

cv1:_ctl5:_ctl3.x:13

cv1:_ctl5:_ctl3.y:5

Session Values:

For your Information: This error has been logged in the Database table Intranet_server__error_log

[Former Member]

Look at the event viewer. Any messages there? Depending on how "intensive" a day it was, it may be you are running into the print engine limit and going with a more sclable solutioin will be your only option.

Ludek