Solved

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

Posted on 2012-03-31
5
1,085 Views
Last Modified: 2012-05-10
We have been trying to figure out why we are getting that error on our application server.  I am assuming that it is because report objects are not properly disposed off.

I am trying to recreate this error message that "The maximum report processing jobs limit configured by your system administrator has been reached."

I've changed the registry key 'PrintJobLimit' to 3 and viewed the report more than 50 times.
I've also tried clicking on the print icon of the crystal report and exported it to the pdf file with more than 10,000 pages.
I tried this on the reports without disposing the object. Yet I dont get that error.

Why?  Am I missing something?
0
Comment
Question by:shahjagat
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 37791730
You are a single user so you are reusing the existing connection.

Try it from 6 machines with 6 different users

mlmcc
0
 

Author Comment

by:shahjagat
ID: 37791816
Thanks mlmcc

But which existing connection? Can you please explain? How is that related to the PrintJobLimit?

I'm using Push method to load the report.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 200 total points
ID: 37791878
I don't fully understand the issue.  It is related to viewing/rendering reports.
Crystal uses a "connection", not sure what that really means but it has to do with the dlls that render the report.

In general the connection is required only for a few seconds as data is read and the report is rendered.
Applications can be written so the connection is only in use during the brief interval it is required.  In general the connection remains open the entire time you are viewing the report.  Thus if you have several people viewing reports, you may end up using all the connections.

I don't know what the tricks are to release the connection other than when you close the report and delete the objects the connection is freed up.I work for a company that provides a report portal that releases the connection as soon as possible after the rendering is complete.  I am not on the development team so I don't know how it is done.  I know it allows more people to view reports simultaneously than other methods.

I don't believe the SDKs that come with Crystal provide the capability.  I believe it requires an OEM/partner relationship wit SAP/Crystal.

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

947 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now