My Oracle Support Banner

Knowledge Module "LKM Hyperion Essbase METADATA/DATA to SQL" Incorrectly Generates Column Names with Spaces (Doc ID 2647656.1)

Last updated on MAY 15, 2020

Applies to:

Oracle Data Integrator - Version to [Release 12c]
Information in this document applies to any platform.


 When executing a mapping using the "LKM Hyperion Essbase METADATA/DATA to SQL" knowledge module in Oracle Data Integrator (ODI), it fails with the following error: 

ODI-1590: The execution of the script failed.
Caused By: org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
File "<string>", line 2, in <module>
  at com.hyperion.odi.essbase.ODIEssbaseDataReader.getAppData(Unknown Source)
  at com.hyperion.odi.essbase.AbstractEssbaseReader.extract(Unknown Source)
  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  at sun.reflect.NativeMethodAccessorImpl.invoke(
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(
  at java.lang.reflect.Method.invoke(
com.hyperion.odi.essbase.ODIEssbaseException: com.hyperion.odi.essbase.ODIEssbaseException: The source column TEST_PERIODS is invalid.The metadata in the calculation script data file does not match with the source datastore metadata. Since the source datastore is of multiple data columns type, the data column dimension used in the source datastore should match the dimension on which the DataExportColHeader is set in the calculation script.
  at org.apache.bsf.engines.jython.JythonEngine.exec(

The Hyperion Essbase column names with spaces are wrongly generated by the knowledge module.

This worked fine in ODI, where the following line was generated:

stagCols = 'C1_TEST_PERIODS=Test Periods , C4_CDC=CDC , C5_CO=Co , C2_VERSIONS=Versions , C3_XXX=XXX , C6_DATA=Data '

In ODI, the line is now the following:



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
 Additional Information

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.