Account Hierarchy Does Not Show Correctly In FR Report; Essbase error(1260046): Unknown Member Running FR report (Doc ID 2440424.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Symptoms

Current hierarchy version for the account segment is not available in the cube.

Originally there were issues with the hierarchies around the same time when they changed values that were originally parents, to children, back to parents.
Publish hierarchies process was run each time and the process ended successfully but after the last change the parents were being shown outside
of the expected hierarchy.

Multiple hierarchy related processes were run including un-publishing the hierarchy, auditing it, flattening it and publishing it.
After that the current hierarchy for the account segment is no longer seen in the cube therefore they cannot run FR reports.
When trying to run reports they get the Unknown Member error 4-31000. This value was created since a long time ago.


ERROR
-----------------------
Error when trying to run FR reports:
Error executing query: Error: Internal Essbase JAPI error: [Cannot perform cube view operation. Essbase error(1260046): Unknown Member 4-31000, used in query]

The log file of the Publish Hierarchies program shows the following:

publishTreeVersions(): Exception :: java.lang.NullPointerException
publishTreeVersions()::: Building/deleting versions for the cube failed with
Exception: null...java.lang.NullPointerException
publishTreeVersions()::: Issue should most probably with Essbase connection
being dropped due to any server issue. Please re-run the Program again. If
issue still exists contact Essbase Server administrator.
#################################### publishHierarchyVersions() :publishTreeVerCall End and took 128.437 Seconds############################
PublishHierarchyVersions: Error:: One or more versions did not get published
successfully for Chart Of Account : <CUBENAME> and Segment Account null
Releasing Root AM...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Run FR report and error occurs

Changes

Cause

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