My Oracle Support Banner

ODI HFM Data or Metadata Integration Error "ODI-1133 Agent x detected that the work repository y went down" (Doc ID 1947803.1)

Last updated on JULY 02, 2019

Applies to:

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


A long running load  from ODI to Hyperion Financial Management (HFM) is failing with an error similar to the following (where x is the name of an ODI Agent and y is the name of a work repository) indicating that the connection between the ODI Agent and the work repository went down:

WARNING ODI-1015: Error while updating session status to the repository.
WARNING IO Error: Connection reset by peer: socket write error
ERROR ODI-1133 Agent x detected that the work repository y went down.
ERROR ODI-1243 Session HFM Data Load (889123) fails because work repository y went down

The session stays in running status in the ODI Operator log, because the agent cannot connect to the work repository to update the status of the failed session. The master and work repositories for ODI are on an Oracle database.


If this was working in the past without any problems then the size of the loads and the time taken to complete the loads may have increased.


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

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