My Oracle Support Banner

Smart View Retrieval Error: “Essbase Error (1020004): An error [1200601] occurred in Spreadsheet Extractor” and “Not enough memory for formula” (Doc ID 2979312.1)

Last updated on OCTOBER 17, 2023

Applies to:

Essbase for OCI Marketplace - Version 19.3.0.0.0 Marketplace to 21.5.2.0.1 Marketplace [Release 19 to 21]
Hyperion Essbase - Version 11.1.2.4.000 to 21.5.0.0.0 [Release 11.1 to 21]
Information in this document applies to any platform.

Symptoms

Getting below error when retrieving data in Smart View:

[ERROR:32] [CFW-601] [CFW] [ecid:<ecid>] [tid: <tid] [REQ_ID: <REQ_ID>] [DBNAME: <dbname>] Not enough memory for formula execution of member [member]. Set MAXFORMULACACHESIZE configuration parameter to [3254]KB or change formula of the member and try again.
[ERROR:32] [SSE-4] [SSE] [ecid:<ecid>] [tid: <tid>] [REQ_ID: <REQ_ID>] [DBNAME: <dbname>] An error [1200601] occurred in Spreadsheet Extractor.

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


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