broken while generating rows

[sdupre]

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.

[bigpoppa]

Have you tried doing the same thing with a simple SQL script? This would isolate the issue to an Oracle error.

- BP