My Oracle Support Banner

Socket Closed I/O Error when Executing ODI Process on IBM AIX Agent (Doc ID 733154.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Data Integrator - Version 10.1.3.2.0 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

An Oracle Data Integrator (ODI) process, executed with an Agent on IBM AIX system, loads data with an external program (actually Teradata MultiLoad utility - but this is not a key point).

Occasionally, the execution fails when ODI is waiting for the external program to complete.

When ODI is trying to execute the next step, following message is signaled:

804 : I/O Error, Socket closed. Packet stream write error: local=<IP_ADDRESS>:<PORT> remote=<HOST>/<IP_ADDRESS>:<PORT> cid=<CID> sess=149415457 Thu Jul 03 21:42:18 GMT+01:00 2008java.net.SocketException: There is no process to read data written to a pipe.
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java(Compiled Code))
at java.net.SocketOutputStream.write(SocketOutputStream.java(Compiled Code))
at com.ncr.teradata.jdbc_4.io.TDNetworkIO1_3Impl.write(TDNetworkIO1_3Impl.java:414)
at com.ncr.teradata.jdbc_4.io.TDPacketStream1_3Impl.writeStream(TDPacketStream1_3Impl.java:777)

Note that the same execution always successfully completes on a different IBM AIX machine.

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
Cause
Solution


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