My Oracle Support Banner

Financial Reporting (FR) Report With Function Bottom Of Hierarchy Returns Error 'Error Executing Query: Error: Internal Essbase JAPI Error: [Cannot Execute Report. Essbase Error(1013033):ReportWriter Exit Abnormally]' (Doc ID 2876354.1)

Last updated on JUNE 16, 2022

Applies to:

Hyperion BI+ - Version to [Release 11.2]
Information in this document applies to any platform.
Essbase Aggregate Storage Option (ASO) application


When attempting to run an FR report which contains an advance member selection function of "Bottom of hierarchy <member_name>" in a column, the following error occurs.

Error executing query: Error: Internal Essbase JAPI
error: [Cannot execute report. Essbase Error(1013033):
ReportWriter exit abnormally]

From FR Web Studio's Task->Data Query Optimization Settings, the following changes had no effect in correcting the error.

  1. Change default "Database Connection Server" to "Report Server" option.
  2. Change default Essbase Queries use MDX "Combine queries using WITH MEMBER" to "Use separate queries" option.
  3. Uncheck the box for "Essbase Queries use MDX" option.






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.