Fatal Error: Pipe read failed

praburaj · Post by **praburaj** » Tue Sep 30, 2008 1:59 am

Hello,
My job design
dataset -> removeduplicate-> lookup -> database
In this job i am trying to load data to dimension table in sybase db.
when i am loading 100 records its inserting fine.
But i need to insert 8 million records. when i am loading 8 million records i am getting follwoing fatal error

"subArgs={asc}}}(0),0: Fatal Error: Pipe read failed: short read"

"subArgs={asc}}}(0),0: Fatal Error: Tsort merger aborting: Scratch space full"

"APT_CombinedOperatorController(0),6: Fatal Error: Unable to allocate communication resources"
"RMD_STG_PETC_VEHICLE,0: Fatal Error: waitForWriteSignal(): Premature EOF on node etldqsrv Socket operation on non-socket"
what i have to do to solve this error. where i have to change settings?
Please help me
Thanks In Advance

prabakaran.v

ray.wurlod · Post by **ray.wurlod** » Tue Sep 30, 2008 2:03 am

The first thing you have to do is the read the error message carefully. It tells you precisely what's wrong. Second thing is Search DSXchange - maybe someone has solved this particular problem in the past. Indeed, I'm fairly certain they have.

If you do both of these things the remedy will be obvious.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 01, 2008 7:50 am

... and whatever it is you're doing fills the scratch disk. Allocate more.