Error writing to pipe: Broken pipe

Tej · Post by **Tej** » Thu Aug 21, 2008 12:19 am

HI,
This is the below error is displayed, when try to run a job,
Acutally the job is loading the data into teredata table from the dataset.
Using TERADATA STAGE(TDM LOAD PX STAGE) after creating the file.rpt the below error is displayed

Please do the needful...

APT_CombinedOperatorController,0: Fatal Error: Fatal: Could not write row to data file in stage JOB NAME.TABLE Name
Error writing to pipe: Broken pipe

Thanks in advance,
Tej

keshav0307 · Post by **keshav0307** » Thu Aug 21, 2008 12:22 am

first of all disable combination. and then check if you have write permission to the output directory path

Tej · Post by **Tej** » Thu Aug 21, 2008 12:33 am

keshav0307 wrote:first of all disable combination. and then check if you have write permission to the output directory path

Yes, i have access, am working in test region
but am run the jobs from the Autosys
not from the job level
please do the needful

ArndW · Post by **ArndW** » Thu Aug 21, 2008 12:51 am

Tej,
in this case it would make more sense for you to act as suggested, check to see if you have write permissions or perhaps if there is no space on the device.

Tej · Post by **Tej** » Thu Aug 21, 2008 3:51 am

ArndW wrote:Tej,
in this case it would make more sense for you to act as suggested, check to see if you have write permissions or perhaps if there is no space on the device. ...

Actually there is no issue in permission, i have the permissions, and the disk space is cleaned

Thanks in advance

hamzaqk · Post by **hamzaqk** » Thu Aug 21, 2008 9:52 pm

Which teradata stage are you using ? This is a common error if your using the MLoad stage. The reason is associated with huge volumes of data. Try unchecking the "Use Named Pipe" option and run the job again. Should be ok.!

hamzaqk · Post by **hamzaqk** » Thu Aug 21, 2008 9:54 pm

Which teradata stage are you using ? This is a common error if your using the MLoad stage. The reason is associated with huge volumes of data. Try unchecking the "Use Named Pipe" option and run the job again. Should be ok.!

toshea · Post by **toshea** » Tue Aug 26, 2008 4:14 pm

The "Error writing to pipe: Broken pipe" message means that the Teradata MultiLoad stage is still writing to the named pipe, but the MultiLoad utility has stopped reading from the named pipe because it aborted for some reason. Check the MultiLoad report file and see if it contains any information on the reason why it aborted.