Intermittent Failure When Loading Data into Hyperion Financial Management (HFM) Using ODI. (Doc ID 1450553.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion Financial Management - Version 9.3.1.0.00 and later
Information in this document applies to any platform.

Symptoms

When running an ODI data load to a Hyperion Financial Management (HFM) application the following is occuring intermittently:

org.apache.bsf.BSFException: exception from Jython:
Traceback (most recent call last):
 File "<string>", line 3, in <module>
at com.hyperion.odi.hfm.ODIHFMAppWriter.loadData(ODIHFMAppWriter.java:265)
at sun.reflect.GeneratedMethodAccessor1992.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)

com.hyperion.odi.common.ODIHAppException: com.hyperion.odi.common.ODIHAppException: Error occurred in driver while connecting to Financial Management application [ApplicationName] on [Cluster] using user-name [User].

If you check the hfm.odl.log on your HFM server you will have an entry indicating that a consolidation started some time before the data load began but has not yet completed:

[EPMFM] [NOTIFICATION:16] [HFM] [ecid: disabled,0] [Org: oracle] [hostingClientId: ] [group: N] [host: ] [pid: xxx] [tid: HFM Message] [userId: User] [file: CHsvDSCalculate.cpp] [line: Line 11586] [version: ] [appName: ] [devString: ] [paramString: ] ApplicationName Consolidation Started id:xxxxxx;POV; Consolidation type:ALLWITHDATA

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