Last post Sep 05, 2012 06:45 AM by Ajay2707
Jul 26, 2012 09:52 AM|dsouzajohnson23|LINK
I have web application(.NET 2.0 VS2005), which uses CR 10.2
Like many others, we are intermittently getting "The maximum report processing jobs limit configured by your system administrator has been reached" exceptions while generating Crystal Reports in PDF Format from our Asp.Net code.
Many experts suggested that, the print job limit is controlled by the registry key called “PrintJobLimit”. We checked the registry of our production Windows 2003 server but didn’t find this entry.
Now my questions are,
Thanks in advance.
Jul 26, 2012 10:05 AM|Mudasir.Khan|LINK
1) Default is 75
2) yes you may add the key and test no issues but have a backup first.
Jul 26, 2012 10:10 AM|dsouzajohnson23|LINK
Does that mean, default 75 has been hardcoded in Cystral Engine OR it picks that value from any config file?
Jul 30, 2012 10:55 PM|rushelp|LINK
Yes, crystal reports has set the default value to 75. A lot of people may suggest to increase the number from 75 to whatever number you need, however it's not a good practice. You may still do that if you want, however there's a different solution.
After you load your crystal report file, make sure you close it properly. Recently I had the same issue. This code will fix it.
Aug 02, 2012 09:23 AM|Ajay2707|LINK
The same issue I face in my last project, Yes we can set that value in.
HKLM\SOFTWARE\Business Objects[Version#]\Report Application Server\InProcServer\PrintJobLimit
Still it is problem face, we found the good thing is iis restart. But latter I know that is not good thing.
Actually as above say, your connection must close.
When your report open , there is connection or thread generated from this limit.
if you continue with this without closing the old report. OS throw the error this.
So check in entire solution that report must close , database connection also close.
You do not show in Windows 2003 server , because you do'not have rights. In any server version this rights(like registry) only have admin.
Aug 02, 2012 09:26 AM|Ajay2707|LINK
Sep 03, 2012 09:39 AM|dsouzajohnson23|LINK
Thanks for your response. I have changed the registry value from 75 to 150 in our TEST environment but the challenge I am facing is I am unable to reproduce the issue. We want to ensure that the change has taken place and has indeed doubled the capacity
of handling the active sessions.
Is there any way we can programmatically monitor the active Crystal Report Print Job Session count on server?
Or is there any tool that can be used to load test the Print Job limit?
I tried multithreading and generated hundreds of reports simultaneously but still could not reproduce the issue.
Sep 03, 2012 10:52 AM|Ajay2707|LINK
As early said, This is the simultaneously hitting couner value of crystal report to server. we can say it is the reporting engine maximum load value. The detail description you can find in this link.
As in this article said, everytime the report hit the engine also if the subreport exist it also work as a one report. So when engine not to process further or stuck, at that place engine throw the error.
There is so many solution, but best is as I have experience that proper opening and closing connection of report programatically at runtime.
Sep 04, 2012 02:59 AM|dsouzajohnson23|LINK
This is not what I am looking for. I am interested to know if programatically we can determine what is the current Print Job Session Count on Server to monitor the pattern and determine which particular report is eating up the maximum sessions.
Second thing, I want to perform load testing of CR so wanted to know if there is any tool or using .net code we can do it.
Sep 05, 2012 06:45 AM|Ajay2707|LINK
The below link is you answer you.
For Second question of .