2 Replies Latest reply: Mar 8, 2013 3:39 PM by Ayush Ganeriwal-Oracle RSS

    ODI 11g error extracting Essbase metadata

    867242
      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].