broken while generating rows
Posted: Fri Mar 12, 2004 3:07 pm
I am having a problem using the row generator.
I have the simplest possible job that is composed of a row generator and an Oracle stage.
It inserts 9000 rows to a staging table and it works fine.
When I set it to 10 000 row, it dies with the following error message :
write() failed: Broken pipe
I am stumped as to where to begin investigating. Is this a datastage problem, a Unix problem or an Oracle problem ??
Additional info : We have three nodes so it splits data to be generated in 3. All seems well at 3000 rows per node and it dies at 3333 rows per node.
I have the simplest possible job that is composed of a row generator and an Oracle stage.
It inserts 9000 rows to a staging table and it works fine.
When I set it to 10 000 row, it dies with the following error message :
write() failed: Broken pipe
I am stumped as to where to begin investigating. Is this a datastage problem, a Unix problem or an Oracle problem ??
Additional info : We have three nodes so it splits data to be generated in 3. All seems well at 3000 rows per node and it dies at 3333 rows per node.