DSXchange

Hi All,

We have the below issue while loading the data to target table using Bulk load stage

LoadEDWSale..TgtEDWSaleOra: DATEFORMAT='YYYY-MM-DD'.
LoadEDWSale..TgtEDWSaleOra: TIMEFORMAT='hh24:mi:ss'.
LoadEDWSale..TgtEDWSaleOra: MAXRECORDNUM='10000'.
LoadEDWSale..TgtEDWSaleOra: LOADMODE='Automatic'.
LoadEDWSale..TgtEDWSaleOra: DIRPATH='/PX_Scratch1'.
LoadEDWSale..TgtEDWSaleOra: CTRLFILE='edw_sale.ctl'.
LoadEDWSale..TgtEDWSaleOra: DATAFILE='edw_sale.dat'.
LoadEDWSale..TgtEDWSaleOra: DELIMITER='|'.
LoadEDWSale..TgtEDWSaleOra.IDENT1: Row 16334649 cannot be loaded. See next Oracle error message for details.

Error:ORA-26095: unprocessed stream data exists

Please let me know your thoughts on this issue.

Thanks,
Satheesh

What did you find when you googled for that ORA error? I found that it is a known Oracle issue, so it sounds like you should upgrade the client version you are using.