Essbase – Maximum number of rows processed [250000] exceeded […] – ver 11.1.2.4


Many times we face this issue while connecting to Smartview and we get error maximum number of row exceeded. The reason being

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.

The issue has been addressed in Essbase 11.1..24.004 PSU as can be seen in Patch Readme:

FIXED DEFECT LIST OF ESSBASE 11.1.2.4.004PSU
21764969 MERGE PATCH FOR BUG 21556292

Action Plan :
=========

  • Apply Essbase Server Patch 11.1.2.4.004 PSU or higher to fix this issue.

Find the latest available patch set for Essbase via KM Doc ID 1396084.1

Thanks,

~KKT~

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s