Oracle Bulk Load Stage issue

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

Oracle Bulk Load Stage issue

Post by satheesh_color »

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
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply