Last updated on APRIL 04, 2016
Applies to:Hyperion Essbase - Version 18.104.22.168.000 and later
Information in this document applies to any platform.
SSPROCROWLIMIT is not working correctly in Essbase Server 22.214.171.124.000
In Essbase 126.96.36.199.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 188.8.131.52 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
Million Knowledge Articles and hundreds of Community platforms