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

[Former Member]

Hi,

  I use visual studio 2010 , sap crystal report 11, when I run report on my laptop and staging server many times, it doesn't have any problem, however, after I move to production server, I just run the report several times, it return this error message:

This is part of code:

ConnectionInfo connectionInfo = new ConnectionInfo();
CrystalDecisions.CrystalReports.Engine.ReportDocument boReportDocument;

string rptFile = ((BaseApplicationPage)(this.Page)).Decrypt(this.Page.Request.QueryString["Name"]);

        connectionInfo.ServerName = "XXXX";

        connectionInfo.UserID = "XXXX";
        connectionInfo.Password = "XXXX";

                    boReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                    boReportDocument.Load(Server.MapPath("~/Crystal/" + rptFile));
                    CrystalReportViewer1.ReportSource = boReportDocument;

                    TableLogOnInfos tableLogOnInfos = CrystalReportViewer1.LogOnInfo;
                    foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
                    {
                        tableLogOnInfo.ConnectionInfo = connectionInfo;

                    }

/CrystalReportViewer1.RefreshReport();

I tried to add refreshreport before, however, it popup parameter window everytime when I click on next page on the report, how can I refresh the report without popup parameter window when I click on next page in the report?

Could you tell me how to solve this problem on production server please?  is in hurry because is production server..

Thank you

Kelvin

[former_member183750 · Accepted solution]

Hi Kelvin

From your description you appear to have a number of issues:

1) CR 11 is not supported in VS 2010. You must use SAP Crystal Reports, Developer Version for Visual Studio .NET

2) To be able to run reports using a web app and not get prompted on each page, you have to use sessions. Almost any action on the viewer causes a postback and thus the prompt. See the following KBA: 1985571 - How to use sessions in web applications using the Crystal Reports viewer (the complete cod...

3) For possible sources of the actual error, enter 'maximum job crystal net' in the search box at the top right corner. You will get a number of great resources there. E.g.;

KBA: 1776014 - While opening Crystal Report from .NET Web Application error appears: The maximum report p...

Crystal Reports Maximum Report Processing Jobs ... | SCN

BTW.; if this is a critical issue, consider creating a phone case here:

Crystal Single Case Technical Support - SAP Business Objects US Online Store | SAP Online Store

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member · Accepted solution]

I am using crystal report 2011,

KBA: 1776014 - While opening Crystal Report from .NET Web Application error appears: The maximum report p...

For this one, when I open regedit , I see this:

since I only use ReportDocument, can I increase the number of Browsing of record or Max number of record or others..?

I don't see the PrintJobLimit and I didn't use PrintJobLimit, so..

or

I need to make change here?

regedit

HKEY_LOCAL_MACHINE/SOftware/Crystal Decisions/Report Application Server/InprocServer/ReportDocument

now is -1 for MaxNumofRecord, could I change other number?  what number should I change?  will that affect the production server after I change?

thanks

Thanks

Kelvin

[former_member183750 · Accepted solution]

Hi Kelvin

MaxNumofRecord is not in play here... not sure where that came from?

You are looking to PrintJob.

As for PrintJobLimit - simply create the folder in the registry. It should have been there, not sure why it is not - but creating it will not hurt. You may want to see what Process Monitor tells you re. the PrintJobLimit(?).

Re. CR 2011. This version does not install any SDK, so no, you are not using CR 2011 or CR 11, thus what are you using? Looks like SAP Crystal Reports, Developer Version for Visual Studio .NET, v. 13.x - but you have to be the one that knows...

- Ludek

[Former Member · Accepted solution]

Hi Ludek,

  Thanks,

  yes, it's 13.X CRforVS_redist_install_32bit_13_0_5 this file.

  For the PrintJob, what number should I enter?

  I enter something like this, is OK?

Thanks

Kelvin

[Former Member · Accepted solution]

HI,

  I added the printJob to -1 for

HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET

Framework 4.0\Report Application Server\Server\PrintJobLimit

  However, it still return same problem, so I have code on crystal report page like this, do you think what I need to change ?

public partial class ReportsView
        : BaseApplicationPage
// Code-behind class for the ReportsView page.
// Place your customizations in Section 1. Do not modify Section 2.
{
       
      #region "Section 1: Place your customizations here."
    //ReportDocument myReportDocument = new ReportDocument();
    //--CrystalDecisions.CrystalReports.Engine.ReportDocument boReportDocument = new ReportDocument();
    private ReportDocument boReportDocument;
    //ConnectionInfo connectionInfo = new ConnectionInfo();
    private void MyLoad(object sender, System.EventArgs e)
    {
        //test1.Text = "test";
        //Label1.Text = "test";
        string rptFile = ((BaseApplicationPage)(this.Page)).Decrypt(this.Page.Request.QueryString["Name"]);
        ConnectionInfo connectionInfo = new ConnectionInfo();
        connectionInfo.DatabaseName = "XXXX";
        connectionInfo.UserID = "XXXX";
        connectionInfo.Password = "XXXX";
        connectionInfo.ServerName = "XXXX";
       

                    boReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                    boReportDocument.Load(Server.MapPath("~/Crystal/" + rptFile));
                    CrystalReportViewer1.ReportSource = boReportDocument;

                    TableLogOnInfos tableLogOnInfos = CrystalReportViewer1.LogOnInfo;
                    foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
                    {
                       tableLogOnInfo.ConnectionInfo = connectionInfo;

                    }
            

  
    }

    protected void MyLoad_UnLoad(object sender, EventArgs e)
    {
        try
        {
            boReportDocument.Close();
            boReportDocument.Dispose();
            CrystalReportViewer1.RefreshReport();
            CrystalReportViewer1.Dispose();
            //tableLogOnInfo..ConnectionInfo.
            //Session["Report"] = null;
            //Session.Clear();
        }
        catch { }
    }

      public ReportsView()
        {
            this.Initialize();
            this.Load += new EventHandler(MyLoad);
        }

thanks

Kelvin

[Former Member · Accepted solution]

I was Facing the same issue Crystal report version 11.5. After a lot of search I found different soluton like "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\InprocServer increase limit here etc etc but didn't work. Then I just dispose my reprtdic properly problem fixed. In my case after printing/generation report I did this

reportDocument.Close(); 
reportDocument.Clone(); 
reportDocument.Dispose(); 
reportDocument = null;
 GC.Collect();
 GC.WaitForPendingFinalizers(); 

It works for me hopefully it will help you also.

[Former Member]

I was Facing the same issue Crystal report version 11.5. After a lot of search I found different soluton like "HKEY_LOCAL_MACHINE\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Report Application Server\InprocServer increase limit here etc etc but didn't work. Then I just dispose my reprtdic properly problem fixed. In my case after printing/generation report I did this

reportDocument.Close(); 
reportDocument.Clone(); 
reportDocument.Dispose(); 
reportDocument = null;
 GC.Collect();
 GC.WaitForPendingFinalizers(); 

It works for me hopefully it will help you also.

[Former Member]

Hi,

  we can only open 20 report same time, and then return this error message, however, we have over 100 user, they could open more report, we change the registry PrintJob to 1200, tried 250-300 before, and close the crystal report, but still have error message, could you tell me any other way can solve this big problem?

  I also try this:

protected void Page_UnLoad(object sender, EventArgs e)
    {

        try
        {
            boReportDocument.Close();
            boReportDocument.Dispose();

        }
        catch { }
    }

Thanks

Kelvin

[former_member183750]

You're way beyond what a simple CR SDK can do for you. For 100 users, your options are:

1) SAP Crystal Reports Server and obtain more user licenses. Talk to sales to get an idea of the number of licenses you will need. Sales ph: 866-681-3435

Worldwide Office Locations | SAP

2) Web Farm

http://msdn2.microsoft.com/en-us/library/ms225484.aspx

Also, download the CRVS dev help and search for 'farm':

SAP Crystal Reports .NET API Guide

More info re performance is in the following sources:

Crystal Reports 2008 Component Engine Scalability | SCN

http://msdn.microsoft.com/en-us/library/ms225519.asp

http://www.sdn.sap.com/irj/boc/go/portal/prtroot/docs/library/uuid/10b2ebf7-281f-2b10-ffa4-fced75b13...

- Ludek