Max processing time or Max records limit reached (Crystal Reports Server)

[Former Member]

Although my report runs fine from with Crystal Reports (designer), I get an error when I try to run it from the Crystal Reports Server portal.

I get an error u201CMax processing time or Max records limit reachedu201D.

How can I solve this problem?

Iu2019m accessing a DB2 database on an iSeries Server thru ODBC. I know that the report uses a lot of data. Therefore I have set u201Callow query timeout yesu201D within the ODBC data source. The data connection itself is not the problem, I have no problem running other reports on the same connection.

PS. A do not know whether or not this is the right forum for my post. I first posted within "Java Development - BusinessObjects Enterprise, BusinessObjects Edge, Crystal Reports Server" but I did not get any response.

[former_member183750]

Actually, the best place to ask this question will be the [Business Objects Enterprise Administration|; forum.

The Java forum would be ok, if you are using the Java SDK (e.g.; creating your own app in Java).

Ludek

[Former Member]

I'm not using Java SDK.

Could you pleas tell me were I can best post questions concerning Crystal Reports Server?

[Former Member]

I solved this problem thru the properties of CrystalReportsProcessingServer.

I have increased the value for Database Records Read When Previewing or Refreshing.

[nscheaffer]

This just solved my problem.  One difference is that we are on 4.1 SP01 Patch 6 and while there is a CrystalReportsProcessingServer this setting was actually in the CrystalReports2013ProcessingServer.  For some reason our Development and Production environments were set to "0" (unlimited), but our QA environment was set to "20000".

Thanks,

Noel

[DellSC]

FYI, the CrystalReportsProcessingServer handles Crystal for Enterprise reports and the CrystalReports2013ProcessingServer handles reports that were created in the "classic" version of Crystal.

-Dell

[Former Member]

I'm missing something here.  I've got this same problem, but I have no idea where to find this CrystalReportsProcessingServer property.  Most say it's in the CMC, but I don't see if anywhere in any of the settings in my CMC.  Can somebody give me some direction to find this property?  Hopefully it will help somebody else as well.

[Former Member]

I found the answer to my problem:

1) Log onto the CMC

2) Goto "Servers" in the dropdown menu

3) Expand "Service Categories"

4) Select "Crystal Reports Services

5) In the right window will be listed the currently running services.  The 2 services that Dell mentioned are in there under "Description":  CrystalReportsProcessingServer and CrystalReports2013ProcessingServer

Hope this helps somebody else.