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 11.2.0.0.000 to 11.2.9.0.000 [Release 11.2]
Information in this document applies to any platform.
Essbase Aggregate Storage Option (ASO) application

Symptoms

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
-----------------------
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.

 

 

Changes

 

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
Changes
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.