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:
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.