Essbase Server Returns Error "Maximum number of rows processed [250000] exceeded [...]". When SSPROCROWLIMIT is Set in Essbase.cfg to a Value Greater Than 500,000

(Doc ID 2119288.1)

Last updated on APRIL 04, 2016

Applies to:

Hyperion Essbase - Version and later
Information in this document applies to any platform.


SSPROCROWLIMIT is not working correctly in Essbase Server

In Essbase, this setting does not work for values > 500,000.

Essbase always returns the error "Maximum number of rows processed [250000] exceeded [......]".

If the value of SSPROCROWLIMIT is > 500000, Essbase seems to go back to the default of 250000.

The documentation for says that SSPROCROWLIMIT still can be set to > 500000, although it is discouraged for performance reasons.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms