ODI Studio Disappears And Session Remains In Running State When Loading Data Into HFM (Doc ID 1457997.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Symptoms

When using ODI Studio on a 64-bit machine it is possible to do reverse engineering, but during data load the ODI Studio user interface disappears. After re-opening ODI Studio the session remains in status 'running'.

In studio.log file we can find the following entries:

[ERROR] [ODI-1217] [] [tid: 13] [ecid:0000JQu_Y67FS8T5qBL6iY1FYyoI00000O,0:2500] Session Load_data_statutory (356001) fails with return code 7000.[[
ODI-1226: Step Load_data_statutory fails after 1 attempt(s).
ODI-1240: Flow Load_data_statutory fails while performing a Integration operation. This flow loads target table HFMData.Changes

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