Page 1 of 1

Job aborted after 500 rows?

Posted: Fri Apr 08, 2011 1:29 am
by Nagac
Hi All

I have a job like below

Dataset---->Transformer---->DB2

When i run the job it's got aborted after 500 rows .(total rows were 2000)

Is it possible to start from 501 row??

Posted: Fri Apr 08, 2011 1:41 am
by antonyraj.deva
If you have checkpoint option enabled at the project level, then Yes.

Re: Job aborted after 500 rows?

Posted: Fri Apr 08, 2011 2:24 am
by SURA
Nagac wrote:Hi All

I have a job like below

Dataset---->Transformer---->DB2

When i run the job it's got aborted after 500 rows .(total rows were 2000)

Is it possible to start from 501 row??

What error captured in director?

Posted: Fri Apr 08, 2011 7:52 am
by Ravi.K
Check at transfer level option enabled like "abort after 500 rows"

Posted: Fri Apr 08, 2011 9:13 am
by chulett
They're not asking why it aborted, but rather how to get it to pick up from where it left off when it is restarted. Unfortunately, checkpoints have nothing to do with this, that only affects Sequence jobs and job activites there.

And the answer is - only if you code it in.