My Oracle Support Banner

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

Last updated on JUNE 22, 2022

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.

Changes

 

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
Changes
Cause
Solution


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