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 |