ODI HFM Data Extraction Fails when "Loading - SS_0 - Extract HFM Data"
(Doc ID 1304071.1)
Last updated on NOVEMBER 09, 2023
Applies to:
Hyperion Financial Management - Version 9.2.0.3.00 and laterOracle 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 |