Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Monday, March 13, 2017

Essbase Error (1020051): Maximum number of rows processed[250000] exceeded [250000]

During Adhoc Analysis( Zoom in to next level) in  Smart View you may encounter the below error:
Essbase Error (1020051): Maximum number of rows processed[250000] exceeded [250000]



Issue:
Essbase is configured to restrict 250000 rows.










Fix:-

To increase the limit from 250,000 to 500,000 or above update the essbase.cfg with the below parameter.


echo "SSPROCROWLIMIT 500000" >> essbase.cfg


epmprod#>grep SSPROCROWLIMIT essbase.cfg
SSPROCROWLIMIT 500000

No comments: