"Error Essbase 1200712: Internal error: Query is allocating too large memory > 4gb" in FRS Report (Doc ID 2581778.1)

Last updated on JUNE 26, 2023

Applies to:

Symptoms

When attempting to run FRS report,
the following error occurs.

ERROR
-----------------------
Error executing query: Error: Internal Essbase JAPI error: [Cannot perform
cube view operation. Essbase Error(1200712): Internal error: Query is
allocating too large memory ( > 4GB) and cannot be executed. Query allocation
exceeds allocation limits.]

STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps:
1) Navigate to FRC

2) Select FRS Report

3) Run the report

4) Experience error

5) Customer disables Essbase Queries use MDX in Financial Reporting Studio

6) Report opens but drill down no longer works

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.