0: Export failed.,0: write() failed: Broken pipe

Mhasan · Post by **Mhasan** » Fri Sep 14, 2007 2:12 am

Hi

I have source as file reading through sequential stage and able to View the proper data... ..and after that passed through Transformer stage while loading into Orcale enterprize stage (Target is Oracle DB) ... while running this job i got these error please suggest the solution for this

0: Export failed.
0: write() failed: Broken pipe

ray.wurlod · Post by **ray.wurlod** » Fri Sep 14, 2007 3:36 am

Is Oracle on the same machine as DataStage?
In any case, there is one process on node 0 executing the operator associated with the Transformer stage, and another process on node 0 executing the operator associated with the Oracle Enterprise stage. They communicate through a pipe. There are two common ways in which a pipe can be broken - either the pipe has become full (it is being written to faster than it is being read from), or the writing process has ended without sending an "end of data" token. Examine the score to figure out what actual operators are involved, and then devise strategies for debugging what might be occurring. Use the Monitor to ascertain whether stages finished satisfactorily.

sunil.saw · Post by **sunil.saw** » Fri Sep 14, 2007 4:00 am

Hi
we have 2 node cofigration... please explain abt it

ray.wurlod · Post by **ray.wurlod** » Fri Sep 14, 2007 2:49 pm

The number of nodes in the configuration is completely unrelated to a broken pipe, which can occur on any single node or between two nodes.

Abt was an engineer who invented a cogged railway system for steep inclines. There, you have Abt explained, as requested.