topic Re: Essbase Error (10200638): Internal Error in QlikView

Essbase Error (10200638): Internal Error

Mon, 26 Jan 2026 18:19:17 GMT

Hi,

I can pull data into Qlik using the Essbase connector, but it seems that if I choose too large of an intersection, it bombs out with the following error. Are there known limitations when pulling data via the Qlik Essbase Connector?

Essbase Error (10200638): Internal Error: Query output is too large to be executed. Query Result exceeds 2^32 cells.

I have set the following in the Essbase config:

SSPROCROWLIMIT 1000000

Obviously I am just asking for too much data, but how much is too much? I am pretty sure that what I am calling for is no where near 4.3 Billion cells. Is it possible that because I am choosing "Entity" (for a hierarchy tree) that is re-pulls data for alternate hierarchies with the same base entities?

Any information you can provide is appreciated!

Re: Essbase Error (10200638): Internal Error

Chanty4u — Tue, 29 Mar 2016 17:48:23 GMT

chk

http://qonnections.geoqlik.com/GeoQlik/proxy/QvAjaxZfc/opendoc.htm?document=2%20-%20FEMA%20Disaster%20Analysis.qvw&host=QVS@aslw0026&anonymous=true&_ga=1.136260786.2002390356.1459265135

Re: Essbase Error (10200638): Internal Error

Thu, 31 Mar 2016 17:32:44 GMT

Not sure how that applies to my problem, but thanks for a reply anyway