Job Aborted after loading 1500 records

mallikharjuna · Post by **mallikharjuna** » Mon Sep 06, 2010 12:58 am

Hi All,

My job design Dataset---> Transformer stage----> ODBC stage or OCI (Oracle).

Source has 3000 records, my job is aborted after loading in 1500 records. How to load the remaining records in my target Oracle table?

Another question: I want to load records if the job successfully completes. Is there any option for that in DataStage?

Thanks in Advance.

Sreenivasulu · Post by **Sreenivasulu** » Mon Sep 06, 2010 1:26 am

You can set the transaction size. Setting it to 0 means ALL / None approach

Regards
Sreeni

mallikharjuna · Post by **mallikharjuna** » Mon Sep 06, 2010 2:07 am

Sreenivasulu wrote:You can set the transaction size. Setting it to 0 means ALL / None approach

any other way?

chulett · Post by **chulett** » Mon Sep 06, 2010 6:43 am

Any other way to answer your second question? No.

ArndW · Post by **ArndW** » Mon Sep 06, 2010 10:25 am

We are just guessing as to the likely cause without getting the detailed error message from you. The specific SQL or database error message. It could be your transaction log filling up or any one of a number of possible errors.