Memory Error on Large Queries
Data source types: Oracle Essbase, Oracle Essbase
When running large MDX queries against an aggregate storage database, you may run in to the following "out of server memory" error:
![Error message returned when running a large MDX query against an aggregate storage database: Error processing request. Please check log for details. Essbase Error (1200766): The number f query result cells exceeds the limit [1000000] set by the QUERYRESULTLIMIT configuration setting.](img/essbase_mdx_error_aso_102x8f43020a.jpg "Error message returned when running a large MDX query against an aggregate storage database: Error processing request. Please check log for details. Essbase Error (1200766): The number f query result cells exceeds the limit [1000000] set by the QUERYRESULTLIMIT configuration setting.")
To resolve this issue, raise the limit in QUERYRESULTLIMIT in essbase.cfg. See QUERYRESULTLIMIT in the Technical Reference for Oracle Analytics Cloud - Essbase for instructions on this configuration setting.
Note:
The information in QUERYRESULTLIMIT applies to both Essbase and these Essbase versions: 11.1.2.4.008, 11.1.2.4.505, and 11.1.2.3.508_22314799.