This discussion is archived
2 Replies Latest reply: Mar 8, 2013 1:39 PM by Ayush Ganeriwal RSS

ODI 11g error extracting Essbase metadata

867242 Newbie
Currently Being Moderated
Hello, ODI Experts:

We recently installed ODI version 11.1.1.6 in a windows 2008 server. We created an interface to extract metadata of Custom dimension from an Essbase application but received this error message:
com.hyperion.odi.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: The source column [PARENTNAME] is not valid for dimension [Customer].

We were able to reverse-engineer the Essbase outline (used as the source data store) and the relational table (used as the target data store). Can someone point out what is wrong with our attempt? Thank you in advance!

org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 91, in <module>
     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 [PARENTNAME] is not valid for dimension [Customer].

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points