Error Broekn Pipe in Oracle Enterprise Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sureshdsx1001
Participant
Posts: 11
Joined: Fri Sep 21, 2007 2:23 am

Error Broekn Pipe in Oracle Enterprise Stage

Post by sureshdsx1001 »

Dear All,

I am trying to load data using Oracle Enterprise Stage into a target table [having Primary keys., indexes and partitions]

During the load , i used the upsert functionality based on Primary KEy columns.

I tried loading intially say 50 records, the jobs loads initial say 40 records but rejects the remaining 10 saying " BROKEN PIPE" erorr

Error message look like this
Load_Oracle_dsd,2: /bin/echo: Broken pipe
Load_Oracle_dsd,2: Operator terminated abnormally: received signal SIGSEGV

I have also verified t hat the remaing 10 records which got rejected doesnot have any meda-data mismatch or data quality issues

CAn anyone please advice how to resolve this issue
\

Thanks
Suresh
Suresh G Sampat
johnthomas
Participant
Posts: 56
Joined: Mon Oct 16, 2006 7:32 am

Post by johnthomas »

Look into sqldr error in scratch directory . I guess you are trying to insert a invalid value which oracle is refusing to load
JT
Post Reply