Monday, December 5, 2011

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

Recently I had to find a solution for the above error during the development process of several crystal reports.

This occurs due to maximum number of concurrent report processes. Finally, I could find two ways to overcome this error.  I personally recommend the 2nd type because it’s the most accurate and effective way of solving this problem.

Method 01:

Simply you can increase the registry key value “PrintJobLimit” at the “[HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\InprocServer]” (Crystal Reports 13.0).

This will solve your problem temporary, but it will occur again and again. Some people say that you will get unlimited number of print jobs when you set this value to -1, but in my case that didn’t happen.


Method 02:

Properly manage your document objects. That means make sure to close and dispose all your document objects when you leave a page. You could easily achieve this by doing it in “Page_unload” event.

rptMyReport objRptMyReport;

protected void Page_Load(object sender, EventArgs e)
{
If (objRptMyReport  ==  null)
objRptMyReport = new rptMyReport();
}

Use your document objects as you want…
But, make sure to dispose them…

protected void Page_Unload(object sender, EventArgs e)
{
 objRptMyReport.Close();
 objRptMyReport.Dispose();
}

This will be permanently resolved this issue.

Good Luck!!!
Happy Programming :)

1 comment:

  1. I have try your solution but now print button is not working.

    ReplyDelete