I am trying to load 11 millions of data into a table for which i am using a manual bulk loader . After inserting 9 million records my job is getting aborted with the error saying
''Abnormal termination of the job''
Explain what you mean by 'manual bulk loader'. Typically that means you're not doing any actual inserting but rather only creating the .ctl and .dat files so sqlldr can be 'manually' invoked afterwards. That as opposed to 'Automatic' mode. And assuming we're talking about Oracle here, which you haven't said.
-craig
"You can never have too many knives" -- Logan Nine Fingers
sl_src_Delta_Consumed_Event_Fd_Job..t_DeltaConsumedEvent:
ORA-01410: invalid ROWID
ORA-02063: preceding line from SL_SRC
Attempting to Cleanup after ABORT was raised in stage sl_src_Delta_Consumed_Event_Fd_Job..t_DeltaConsumedEvent
Again, manual mode in the Bulk Loader stage doesn't insert anything. So is this happening when you manually invoke sqlldr afterwards? Please be specific regarding exactly what it is you are doing.
-craig
"You can never have too many knives" -- Logan Nine Fingers
From previous run
DataStage Job 158 Phantom 4303
Abnormal termination of DataStage.
Fault type is 11. Layer type is BASIC run machine.
Fault occurred in BASIC program JOB.1288847898.DT.1551460110.TRANS1 at address de.