ODI HFM Data or Metadata Integration Error "ODI-1133 Agent x detected that the work repository y went down"
Last updated on JANUARY 12, 2018
Applies to:Oracle Data Integrator - Version 188.8.131.52.0 and later
Hyperion Financial Management - Version 184.108.40.206.000 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 220.127.116.11 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.
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