Topic
No replies
SystemAdmin
SystemAdmin
17917 Posts
ACCEPTED ANSWER

Pinned topic Autoloader Broken pipe failure

‏2005-10-27T01:37:06Z |
We are using Informatica ETL tool to autload 4 million rows into a table. The hardware we are runningon is a 30 processor p690 with AIX 5.x. We are running UDB ver 7.2. We are getting the following error and the database is shutting down immediately.
Here is the autoload log file message

READER_1_1_1> FR_3071 Maximum Line sequential buffer length is 65662.
WRITER_1_1_1> WRT_8167 Start loading table INVC_ADJ_RESN at: Wed Oct 26 17:33:24 2005
WRITER_1_1_1> Wed Oct 26 17:37:51 2005
WRITER_1_1_1> WRT_8216 External loader error. Broken pipe
WRITER_1_1_1> Wed Oct 26 17:37:51 2005
WRITER_1_1_1> WRT_8215 External loader error. The External loader process 15982618 exited prematurely.
WRITER_1_1_1> Wed Oct 26 17:37:51 2005
WRITER_1_1_1> WRT_8174 Error while flushing the buffer to output file [/edw/css/logs/autoload_logs/invc_adj_resn11.out]. Error
message is Broken pipe, data buffer [1|37437856|1|1|88|1|37437856|1|1|85|U01|A|1|37437856|1|1|89|0|0|0|0|0|
WRITER_1_1_1> WRT_8047 Error: External loader process 15982618 exited with error 101