DSXchange

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

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

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

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.

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

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.!

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.!

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.