data load capacity for a manual bulk loader

daramanoj · Post by **daramanoj** » Thu Jul 08, 2010 3:17 am

HI,

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''

So can any one help me out in this asap

Thanks in Advance.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 08, 2010 4:24 am

Unfortunately we don't do ASAP. I will let Ray or Craig explain that in detail.

"Abnormal Termination" errors are usually accompanied by other errors.

Try resetting the job and check the "from previous run" message.

daramanoj · Post by **daramanoj** » Thu Jul 08, 2010 4:55 am

apologies for ASAP

I got the error message like this

From previous run:
Datastage Job 113 Phantom 16094
Datastage phantom Finished

chulett · Post by **chulett** » Thu Jul 08, 2010 5:33 am

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.

daramanoj · Post by **daramanoj** » Thu Jul 08, 2010 6:12 am

It means exactly what you have said ...i am using oracle

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 08, 2010 6:22 am

Can you paste the exact error message.

Did you check the log and bad files ?

What happens if you remove the loader and write it to a sequential file ?

daramanoj · Post by **daramanoj** » Thu Jul 08, 2010 7:09 am

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

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Thu Jul 08, 2010 7:16 am

http://dbaspot.com/forums/oracle-server ... elect.html

http://www.dba-oracle.com/t_ora_02063_p ... string.htm

chulett · Post by **chulett** » Thu Jul 08, 2010 7:54 am

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.

daramanoj · Post by **daramanoj** » Thu Jul 08, 2010 8:25 am

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.

chulett · Post by **chulett** » Thu Jul 08, 2010 8:29 am

[sigh]