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
Fatal Error: Pipe read failed
Moderators: chulett, rschirm, roy
Fatal Error: Pipe read failed
prabakaran.v
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If you do both of these things the remedy will be obvious.
Last edited by ray.wurlod on Tue Sep 30, 2008 2:10 am, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: