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 Marketplace to Marketplace [Release 19 to 21]
Hyperion Essbase - Version to [Release 11.1 to 21]
Information in this document applies to any platform.


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.


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

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