Essbase Server 184.108.40.206.000 Returns Error "Maximum number of rows processed  exceeded [...]". When SSPROCROWLIMIT is Set in Essbase.cfg to a Value Greater Than 500,000
Last updated on APRIL 04, 2016
Applies to:Hyperion Essbase - Version 220.127.116.11.000 and later
Information in this document applies to any platform.
SSPROCROWLIMIT is not working correctly in Essbase Server 18.104.22.168.000
In Essbase 22.214.171.124.000, this setting does not work for values > 500,000.
Essbase always returns the error "Maximum number of rows processed  exceeded [......]".
If the value of SSPROCROWLIMIT is > 500000, Essbase seems to go back to the default of 250000.
The documentation for 126.96.36.199 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