"The maximum report processing jobs limit configured by your system administrator has been reached."

Question

I am using VS 2005 Beta2. My website (C#, ASP.NET 2.0) worked ok. But after I run it several times,  i got an exception when loading the report ( MyReport.load(reportPath) ):
 
"The maximum report processing jobs limit configured by your system administrator has been reached."

Then I restart my pc, and it works again.

Can anyone tell me what is the problme in my project? Do I need to configure anything? Thanks!

auhe

Answer 1

Hello Auhe,

Do you have code to close or dispose the Report Document (MyReport in your case)?

It sounds like you have multiple report documents open with the report engine. 

Here is a link to the online help that talks about how to optimize scalability:

http://support.businessobjects.com/library/docfiles/cr/granville_beta/html/crconsdkfundamentalsscalability.htm

Keith - Business Objects

Answer 2

My users have been receiving this error intermittently ever since we upgraded to Crystal Enterprise XI and Crystal Reports XI. I'm using the same ASP.Net App and C# code, but have replaced the .dll refrences to use the new Business Object managed framework assemblies. I never had this problem with Crystal X. Are there settings somewhere that can be changed to fix this?

Answer 3

Basically the error means that there is too much load on the reporting engine.  Starting in v10 (suprised you haven't seen this in v10,, or there is more load now), the reporting engine was optimized for greatest report throughput.  There are specific reg keys that control this optimization. 

By default, the print job limit is set to 75 print jobs.  When a load is placed on the application it can hit the 75 print jobs and 

cause the above error.

 

Report Objects stored in Sessions would be counted as a PrintJob.

Main reports would count as a PrintJob.

Subreports would each count as a PrintJob.

 

The print job limit is controlled by the following reg key:

HKEY_LOCAL_MACHINE\SOFTWARE\CRYSTAL DECISIONS\10.0\REPORT APPLICATION SERVER\SERVER\PrintJobLimit

 

You can try increasing this number to stop the error from happening.  This may stop the error from occurring temporarily but as load increases, you find this error will start to occur again.  You are better to look at scaling your application by adding more hardware to the system.

*Do not increase it more than necessary since it can degrade the machines performance.

WARNING: Any modification made to the registry must be made carefully as it can cause your system to fail.

Answer 4

The link provided not longer exist.  Here is the new link to BO.

http://support.businessobjects.com/forums/message.asp?fid=251&mid=149497

Don't forget to do a myreport.close and then do a myreport.dispose for the Report Document.

Just as a note raising the PrintJobLimit from the default of 75 to ?  will not prevent the error from occurring.  You must close and dispose the reportdocument.

 

Answer 5

Here is my blog post and the approach we use is listed there.

http://geekswithblogs.net/technetbytes/archive/2007/07/17/114008.aspx

 

Answer 6

 

I'm passing the same problem. Any aditional help?

Answer 7

 

I have been using Crystal since it was owned by Seagate Software.  Over the last 10 years, I've seen it's reliablity and scalablity decline.  The IDE addin is buggy, the report engine is lacking and the deployment is a royal pain.  Their support is laughable (as anyone who has tried to call them for it can attest).  I'm really sad to see it slip into the state it's in now since I've been an avid user for so long.  The fact of the matter is that it's an aging product which simply isnt keeping pace with the new development platforms available to developers.  A prime example is it's inablity to deal with nullable types.

 

Just this year our company has decided to no longer develop on the Crystal Reports platform.  I'm will not promote any other products, I will however offer a suggestion to the community.  Avoid COM Interop at all costs.  There are an increasing number of very good reporting packages that are 100% .Net, no interop required.  Some are even able to convert some (not likley all) of your Crystal .rpt files to their format.

 

Answer 8

I also faced same problem but I did not restarted PC. Instead just we have to delete some report files from temp folder(C:\Documents and Settings\YourUsername\Local Settings\Temp) with the extension rpt. It worked for me...