ODI HFM Data Extraction Fails when "Loading - SS_0 - Extract HFM Data" (Doc ID 1304071.1)

Last updated on JULY 28, 2016

Applies to:

Hyperion Financial Management - Version 9.2.0.3.00 and later
Oracle Data Integrator - Version 11.1.1.7.0 and later
Information in this document applies to any platform.
july 2014

Symptoms

When extracting data from an HFM application via ODI when using MS SQL as the staging area the following error is seen in the ODI Operator:

org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
File "<string>", line 1, in ?
com.hyperion.odi.common.ODIHAppException: Arithmetic overflow error converting float to data type numeric.


If an Oracle database is being used as a staging area then the following error is seen in the ODI Operator:

org.apache.bsf.BSFException: exception from Jython:
Traceback (innermost last):
File "<string>", line 1, in ?
com.hyperion.odi.common.ODIHAppException: ORA-01438: value larger than specified precision allowed for this column


If the Sunopsis Memory Engine is being used as the staging area though then the load will complete without errors.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms