My Oracle Support Banner

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

Last updated on JULY 01, 2021

Applies to:

Oracle Fusion General Ledger Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References

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