ODI Data Load to Essbase Fails on the "Load data into essbase" Step of IKM with: Analytic Server Error(1003014): Unknown Member
Last updated on APRIL 19, 2018
Applies to:Hyperion Essbase - Version 18.104.22.168.00 and later
Information in this document applies to any platform.
***Checked for relevance on 02-Jul-2014***
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,  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.
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