Broken Pipe Error

adis · Post by **adis** » Mon Aug 24, 2009 10:49 am

Hello,

I am trying to find out the reason for the following error -

Write to dataset failed: Broken pipe

Appreciate any help about why this might be occuring.

Thank You!

chulett · Post by **chulett** » Mon Aug 24, 2009 12:00 pm

First question is always going to be - did you search here for that message? Did none of the matches found help you out?

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Aug 24, 2009 1:18 pm

Broken pipe is when one stage fails in a link which either produces or consumes data.

This is generally accompanied by an abort on a stage.

Is there any more error message available in your logs ?

Sreenivasulu · Post by **Sreenivasulu** » Mon Aug 24, 2009 1:58 pm

You might have lost network connectivity to the databases / datastage/ file server during the course of the job run.

Regards
Sreeni

adis · Post by **adis** » Mon Aug 24, 2009 2:55 pm

Sainath.Srinivasan wrote:Broken pipe is when one stage fails in a link which either produces or consumes data.

This is generally accompanied by an abort on a stage.

Is there any more error message available in your logs ...

Hi Sainath,
Yes, that was the reason. I was looking for it, actually the job was failing due to a error in one of the transformers, when trying to convert StringToDecimal and eventually was resulting into Broken Pipe error message, but the log never said "error converting Decimal_from_string" or anything.

Thanks for your help!