ODI Data Load to Essbase Fails on the "Load data into essbase" Step of IKM with: Analytic Server Error(1003014): Unknown Member (Doc ID 1513793.1)

Last updated on JULY 29, 2016

Applies to:

Hyperion Essbase - Version 9.3.1.0.00 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jul-2014***

Symptoms

When running a data load to Essbase in ODI:

1. The data load is failing on the 'Load data into essbase' step of the interface.

2. The following is being seen in the error log along with the contents of a rejected row (where x is a member name in the source data - see note 1088139.1 for details of enabling logging for Essbase KMs):

Cannot end dataload. Analytic Server Error(1003014): Unknown member [x] in Data Load, [0] Records Completed

If you are using non-ASCII characters in your member names and you are sure that your metadata exists then you may want to check note 1307155.1 to see if that applies.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms