Question Re: Crystal runtime error - Load Report Failed in Technology Q&A

Crystal runtime error - Load Report Failed

Former Member — Wed, 03 Feb 2010 18:51:28 GMT

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?

Re: Crystal runtime error - Load Report Failed

former_member11696 — Wed, 03 Feb 2010 18:53:16 GMT

Moving to the correct forum

Re: Crystal runtime error - Load Report Failed

Former Member — Thu, 04 Feb 2010 16:29:58 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Thu, 04 Feb 2010 16:41:38 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Thu, 04 Feb 2010 17:58:56 GMT

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?

Re: Crystal runtime error - Load Report Failed

Former Member — Thu, 04 Feb 2010 18:14:19 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Fri, 05 Feb 2010 03:11:19 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Fri, 05 Feb 2010 05:18:24 GMT

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?

Re: Crystal runtime error - Load Report Failed

Former Member — Fri, 05 Feb 2010 14:53:44 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Fri, 05 Feb 2010 15:06:21 GMT

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?

Re: Crystal runtime error - Load Report Failed

Former Member — Fri, 05 Feb 2010 16:07:39 GMT

they are asked to install something

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

Ludek

Re: Crystal runtime error - Load Report Failed

Former Member — Fri, 05 Feb 2010 16:44:04 GMT

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

</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?

Re: Crystal runtime error - Load Report Failed

Former Member — Fri, 05 Feb 2010 17:40:02 GMT

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?blog=/pub/wlg/14395

Ludek

Re: Crystal runtime error - Load Report Failed

Former Member — Mon, 08 Feb 2010 23:37:14 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Tue, 09 Feb 2010 16:38:29 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Tue, 09 Feb 2010 18:16:33 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Tue, 09 Feb 2010 22:13:56 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Tue, 09 Feb 2010 22:39:04 GMT

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

Re: Crystal runtime error - Load Report Failed

Former Member — Tue, 09 Feb 2010 23:14:26 GMT

No warnings, other related errors before that?

Re: Crystal runtime error - Load Report Failed

Former Member — Wed, 10 Feb 2010 00:40:18 GMT

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?