Essbase Server 11.1.2.4.000 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 11.1.2.4.000 and later
Information in this document applies to any platform.

Symptoms

SSPROCROWLIMIT is not working correctly in Essbase Server 11.1.2.4.000

In Essbase 11.1.2.4.000, 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 11.1.2.4 says that SSPROCROWLIMIT still can be set to > 500000, although it is discouraged for performance reasons.

Cause

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