Page 1 of 1
Promote warning to fatal error
Posted: Sun Jun 11, 2006 8:37 am
by vinaymanchinila
Hi,
How do we promote a particular warning to fatal error so that the job aborts, we have a metadata mismatch , instead of generating a warning and dropping the data, we need it to abort.
Or
Is there a way to specify the job to abort after say 10 warnings when runing the job from Control-M.
Thanks,
Posted: Sun Jun 11, 2006 10:10 am
by chulett
Can't help with the 'promote the warning' bit, but I thought that was done via a right-click in the job's log on the warning itself?
Is there a way in PX to say if records go this particular link, abort the job after n of them? In the Server world you can say 'Abort after 1 row goes down this link' which stops the job at the first sign of the problem.
For Control-M and the 'dsjob' command line interface, simply add '-warn 10' to the command to start the job.
Posted: Sun Jun 11, 2006 10:32 am
by vinaymanchinila
Hi
We can demote or supress the warnings but not promote I believe.
The easy way is to use a transformer and use the condition abort on 1 row.
I have not tried the '-warn 10' , will try that, but was thinking if there is away to make a warning convert into FATAL.
Thanks for the inputs.
Posted: Sun Jun 11, 2006 4:36 pm
by ray.wurlod
No.
Posted: Tue Jun 13, 2006 2:17 pm
by pneumalin
vinaymanchinila wrote:Hi
We can demote or supress the warnings but not promote I believe.
The easy way is to use a transformer and use the condition abort on 1 row.
I have not tried the '-warn 10' , will try that, but was thinking if there is away to make a warning convert into FATAL.
Thanks for the inputs.
There is always a way to get what you want. But firstly you may want to identify how do you want to use this Job Abort/Fatal Status?
Posted: Tue Jun 13, 2006 3:06 pm
by ray.wurlod
Not this time. You can detect and escalate, but you can not promote.
Posted: Wed Jun 14, 2006 12:32 am
by kumar_s
Isnt it not possible by message handler?
Or if it is metadata mismatch, collect it in reject link and add a transformer to "Abort after 1 row"
Posted: Wed Jun 14, 2006 1:24 am
by ray.wurlod
(1) No.
(2) This is "detect and escalate", not "promote".