DSXchange

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

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