My Oracle Support Banner

ODI Metadata Extract from Essbase Error: "com.hyperion.odi.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: The source column [ColumnName] is not valid for dimension [Dimension]." (Doc ID 1531996.1)

Last updated on MARCH 27, 2024

Applies to:

Oracle Data Integrator - Version 11.1.1.5.0 to 11.1.1.5.0 [Release 11gR1]
Hyperion Essbase - Version 11.1.2.1.000 to 11.1.2.4.049 [Release 11.1]
Information in this document applies to any platform.

Symptoms

When extracting metadata from an Essbase application the following error is seen on the "Begin Essbase Metadata Extract" step:

org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "", line 89, in
at com.hyperion.odi.essbase.ODIEssbaseMetaReader.validateSourceMetadata(Unknown Source)
at com.hyperion.odi.essbase.ODIEssbaseMetaReader.validateExtractOptions(Unknown Source)
at com.hyperion.odi.essbase.AbstractEssbaseReader.beginExtract(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

com.hyperion.odi.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: The source column [ColumnName] is not valid for dimension [Dimension].

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.