Crystal runtime error - Load Report Failed

[Former Member]

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 · Accepted solution]

Reports will load for hours or days and then nor reports will load and we get this error:

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.contact_Phone.RunReport() in C:\Inetpub\wwwroot\Development\DLA_INTRANET2\PhoneList\contacts_phone.aspx.vb:line 176 at DLA_Intranet.contact_Phone.searchButton_Click(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Development\DLA_INTRANET2\PhoneList\contacts_phone.aspx.vb:line 73 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) 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.phonelist_contacts_phone_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\hwodar

Form Values:

__EVENTTARGET:

__EVENTARGUMENT:

__LASTFOCUS:

__EVENTVALIDATION:/wEWUQL0iLDLDwKx1vaaCQKtkuWiCgLnrjzCwKQ9aiBwLwoLxMArmGsZgPAu6u14AIAuaI65wBAvLPesNArXU79oNAvWNhd0LArXV28EDAteK5uUBAtHcwuwDAo6oxeUKAo/qqukOAs2j5rAIAvvC7wKApaLzoMCAryS8fILAuiXnoYFAtj10aUEAreG2scJAsLG6K0OAu2zwIwLAsj1ragOAu75oesGAqvTsf8DAujyvJMBAqfSgIAFAs60lvsPAprJsqsOArfChb8KAv7lqaIHAvizu8YNAputxegOAqbH6dILAoG/rqsPAubbxZwLAsfGgd8LAp30k5UHAty3v7oEAuizpuMFAtvm1wFAun5roIJAuP8z44OAvrStL4KArKttb4KAo3pp8APAvCN09cNAoPhpgPAsmP64wOAqmO2sUJAsCwtsQIAvDM3/wEAvC7pZwJAsfG3c4LAvKe0/gJAsXw8TIC6LOidQKixunSCwKFmNybCALpu/6TAwKswOP/BQK369jMBwLDwbHbCwK8q3hCQL9goiwDQKc7tbjBgLx762yBAKpxOmFCgLjwd2bAQKqq2hDALV5SfAwLyzPHWDAL75ICaDgKPi/qeDQL9t9e7DALJuJPAwKbjvtDC0hd0O3uEi/1p4dGLfi5S70OKQ

searchButton:Search

firstnametext:

txtExt:

departmentdd:----

---

All Departments -

---

branchdd:----

---

All Branches -

---

lastnametext:murray

txticcode:

Session Values:

dsphone:

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

[Former Member]

The text I sent you was copied right out of the event viewer - it's all there is. Any ideas would be welcomed.

[Former Member]

No warnings, other related errors before that?

[Former Member]

Nothing that appears to be related e.g. reference set to null - non cyrstal pages - about 10 minutes before the load report failed. Is there anywhere else I can look to see what may be the problem?

[Former Member]

Re-reading this whole thread and this thread having gone past two pages, I think it is time for this to go to a phone support. You can discuss the issue with a technician, do a webex and what ever. Remember, this is not a usual occurance. (the error is common, the solution is usually straight forward). You can obtain a phone case here:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...

Ludek

[Former Member]

Can you tell by looking at the error message whether it's a print engine limit problem. If this is the problem does a more scalable solution allow the existing reports to work w/o further developement.

The first error message we got regarding Crystal was:

Event code: 3005

Event message: An unhandled exception has occurred.

Event time: 2/9/2010 12:34:04 PM

Event time (UTC): 2/9/2010 5:34:04 PM

Event ID: 165a559802914894b990d5cb762647f4

Event sequence: 14872

Event occurrence: 77

Event detail code: 0

Application information:

Application domain: /LM/W3SVC/1/Root/DLA_Intranet-1-129101511165117682

Trust level: Full

Application Virtual Path: /DLA_Intranet

Application Path: C:\Inetpub\wwwroot\DLA_Intranet\

Machine name: DLA-SS-IIS2

Process information:

Process ID: 3108

Process name: w3wp.exe

Account name: NT AUTHORITY\NETWORK SERVICE

Exception information:

Exception type: Exception

Exception message: Load report failed.

Request information:

Request URL: http://dla-ss-iis2/dla_intranet/brokers/brk_BondInventory.aspx?sl=0

Request path: /dla_intranet/brokers/brk_BondInventory.aspx

User host address: 192.168.12.42

User: DAVIDLERNER\gisler

Is authenticated: True

Authentication Type: Negotiate

Thread account name: NT AUTHORITY\NETWORK SERVICE

Thread information:

Thread ID: 5

Thread account name: NT AUTHORITY\NETWORK SERVICE

Is impersonating: False

Stack trace: at Microsoft.VisualBasic.CompilerServices.Symbols.Container.InvokeMethod(Method TargetProcedure, Object[] Arguments, Boolean[] CopyBack, BindingFlags Flags)

at Microsoft.VisualBasic.CompilerServices.NewLateBinding.LateGet(Object Instance, Type Type, String MemberName, Object[] Arguments, String[] ArgumentNames, Type[] TypeArguments, Boolean[] CopyBack)

at DLA_Intranet.WebAppShare.trdBondReport.Populate(Object crReport, Boolean blnBroker, String OrdBy)

at DLA_Intranet.brk_BondInventory.RunDsReport()

at DLA_Intranet.brk_BondInventory.Page_Load(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)

Custom event details:

For more information, see Help and Support Center at

[Former Member]

Not from this, no. What do you see in the event viewer though? Do you see something like "report was submitted, waiting for next available license"? (I'm paraphrasing here as I do not remeber the exact message, but it's close enough.

Ludek

[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

[Former Member]

Yes it's the active X printing. We're currently delivering it via -

<printControl>

<add key="url" value="http://dla-ss-iis2/crystalreportviewers115/ActiveXControls/PrintControl.cab"/>

</printControl>

but I noticed that the crystalreportviewers115 was set up in ASP 1.1 - I changed it to 2.0 - it seems like it's working.

Is this the best way to deliver the activex printing control?

[Former Member]

That is good. Just an FYI. There is a blog on activeX printing issues here:

http://www.sdn.sap.com/irj/scn/weblogs;jsessionid=(J2EE3417500)ID1617741650DB11112347389125823727End...

Ludek

[Former Member]

Thanks -

When our users try to print out a report - they are asked to install something - they can not install software on their machines - do you have the msi that needs to run for this?

[Former Member]

they are asked to install something

I'll need more info on what this is. ActiveX printing?

Ludek

[Former Member]

I've installed SP 6 on both the development box and the server - I'll see if it helps. I noticed that 2 of our projects have different versions in the web.config

Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

Is this a problem - which version is correct?

[Former Member]

Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" is for the 2.0 framework.

Version=11.5.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" is for the 1.1 framework.

Ludek

[Former Member]

Do I need to change the web.config Version=11.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" or are these parameters the same.

[Former Member]

I've inherited this - so I'm not sure which (if any) service packs are installed. We are using Crystal Reports XI Release 2 Version 11.5.8.82627 and Crystal Reports XI 2 .NET 2005 Server version 11.5.0.0

We also have some software running on the server that is compiled with version 10.2.3600.0 (It was using the integrated crystal from vs 2005)

Are the links you sent for the development machines or the server? Do I also need to install a different server version?

[Former Member]

The version indicates that you are on SP 2...

Re;

Are the links you sent for the development machines or the server? Do I also need to install a different server version?

SP6 will go on the development computer.

Runtime goes on the server. You'll have to decide if you want to use the msm or msi.

CR 10.2 is of no consequence here. No other version should matter as since v 9, all versions are side by side compatible (with the possible exception of CR XI r1 (11.0.x) and CR XI r2 (11.5.x)

Ludek

[Former Member]

Well, you don't mention if you have applied any Service Packs for CR?

Try SP 6;

https://smpdl.sap-ag.de/~sapidp/012002523100015859952009E/crxir2win_sp6.exe

Recompile the app. Then ensure you deploy SP6 runtime.

msm:

https://smpdl.sap-ag.de/~sapidp/012002523100000634042010E/crxir2sp6_net_mm.zip

msi:

https://smpdl.sap-ag.de/~sapidp/012002523100000633302010E/crxir2sp6_net_si.zip

Make sure you are using .close and .dispose on the report objects as you get done with them.

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

[former_member11696]

Moving to the correct forum