Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Crystal Reports Exception: The maximum report processing jobs limit configured by your system administrator has been reached

I'm facing a very buggy issue, in ASP.NET application after viewing the same report many times simultaneously I got this exception:

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

Wait I know there are tons of solutions out there but all of them are not working with me.

  1. I put ReportDocument.Close(); ReportDocument.Dispose(); in CrystalReportViewer_Unload event, and still throw the exception.

    Private Sub CrystalReportViewer1_Unload(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Unload reportFile.Close() reportFile.Dispose() GC.Collect() End Sub

  2. I edit the PrintJobLimit registry in HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\InprocServer and HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\Server to -1 even to 9999, and still throw the exception.

Here is the code snippet where I call my report:

 Table_Infos = New TableLogOnInfos()
                Table_Info = New TableLogOnInfo()
                Con_Info = New ConnectionInfo()

                With Con_Info
                    .ServerName = ConfigurationManager.AppSettings("server_name")
                    .DatabaseName = ConfigurationManager.AppSettings("DB")
                    .UserID = user_name
                    .Password = pass_word
                    .Type = ConnectionInfoType.SQL
                    .IntegratedSecurity = False
                End With

                Table_Info.ConnectionInfo = Con_Info

                If Session("recpt_lang") = "Arabic" Then
                    reportFile.Load(Server.MapPath("/Reports/") & "collectrecpt_new_ar.rpt")
                ElseIf Session("recpt_lang") = "English" Then
                    reportFile.Load(Server.MapPath("/Reports/") & "collectrecpt_new.rpt")
                End If

                For Each mytable In reportFile.Database.Tables

                    mytable.ApplyLogOnInfo(Table_Info)

                Next

                CrystalReportViewer1.ReportSource = reportFile
                CrystalReportViewer1.SelectionFormula = Session("SelectionForumla")
                CrystalReportViewer1 = Nothing
like image 597
Emad Mokhtar Avatar asked Mar 06 '12 08:03

Emad Mokhtar


People also ask

What does this Crystal Reports exception mean?

Crystal Reports Exception: The maximum report processing jobs limit configured by your system administrator has been reached. I'm facing a very buggy issue, in ASP.NET application after viewing the same report many times simultaneously I got this exception:

What is the maximum number of report processing jobs limit?

The maximum report processing jobs limit configured by your system administrator has been reached. This report error appears when Crystal Reports hits the hard limit for the specified number of print jobs. The default number is 75. The IIS must be reset to restart the value to zero (0).

How many times does a crystal report run for each record?

Consider a simple scenario where a Crystal report has 75 records and 1 subreport in details section. In this case the subreport being in details section will run for 75 times, once for each record generating 75 print jobs plus one print job for main report.

What is the default print job limit for Crystal?

Crystal print engine is designed with 75 as a default print job limit. Once this limit exceeds, above issues start to appear.


1 Answers

You have to Dispose your report instance after all. If you Dispose the report after showing it, you will never see the error "The maximum report processing jobs limit configured by your system administrator has been reached" again.

  Dim report1 As rptBill = clsBill.GetReport(billNumber)

  rpt.Print()

  'Cleanup the report after that!
  rpt.Close()
  rpt.Dispose()
like image 52
Developer Avatar answered Sep 17 '22 12:09

Developer