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 12.2.1.3.190415 to 12.2.1.4.200304 [Release 12c]
Information in this document applies to any platform.

Symptoms

 When executing a mapping using the "LKM Hyperion Essbase METADATA/DATA to SQL" knowledge module in Oracle Data Integrator (ODI) 12.2.1.3, 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(NativeMethodAccessorImpl.java:62)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  at java.lang.reflect.Method.invoke(Method.java:498)
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(JythonEngine.java:146)
  ...

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

This worked fine in ODI 11.1.1.9, 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 12.2.1.3, the line is now the following:

stagCols = 'TEST_PERIODS=TEST_PERIODS , CDC=CDC , CO=CO , VERSIONS=VERSIONS , XXX=XXX , DATA=DATA '

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
Cause
Solution
 Additional Information
References


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