Essbase Error (1020051): Maximum number of rows processed [500000] exceeded [502615]

  • Date: November 8, 2013
  • Article by: Joe Malewicki

ISSUE: When running a large spreadsheet refresh or query in Oracle Hyperion Smart View the following error is returned.  When this occurs, the user must close Microsoft Excel and then re-open and re-login to continue working.
ERROR MESSAGE DETAILS:
Oracle Hyperion Smart View for Office, Fusion Edition
Essbase Error (1020051): Maximum number of rows processed [500000] exceeded [502615].
OK
SCREEN SHOT:

essbase-error-1020051

SOLUTION: In the ESSBASE.CFG file add or modify the parameter for the SSPROCROWLIMIT to be a value greater than the maximum rows being requested.  You must restart the Essbase server for the new setting to take effect.  In our example the user has the setting currently at 500,000 rows and the Smart View query was trying to return 502,615 rows.
The ESSBASE.CFG file can be found on the Essbase server:
On a Microsoft Windows platform:
C:OracleMiddlewareuser_projectsepmsystem<#>EssbaseServeressbaseserver1bin
On a LinuxUnix platform:
/<your install location>/Oracle/Middleware/user_projects/epmsystem<#>/EssbaseServer/essbaseserver1/bin

  1. Shutdown the Essbase server service or process.
  2. Backup the current ESSBASE.CFG file.
  3. Add or modify the following parameter:
    1. SSPROCROWLIMIT 600000
  4. Restart the Essbase server service or process.

APPLICABLE VERSIONS: 11.1.2.0, 11.1.2.1, 11.1.2.2, 11.1.2.3, 11.1.2.4

Share me

OWSM Blog Part 1 – Installation and Configuration of DRM Web Services API with Oracle EPM 11.2

  • Date: Nov 18, 2020
  • Article by: Brad Spelman
Read More

October Patch Updates Breaks Shared Services. 11.1.2.4.x

  • Date: Oct 28, 2020
  • Article by: Jeff Henkel
Read More