Solved

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

Posted on 2012-03-31
5
1,081 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
This video discusses moving either the default database or any database to a new volume.

772 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

10 Experts available now in Live!

Get 1:1 Help Now