topic Re: [resolved] Abort a job in Talend Studio

[resolved] Abort a job

sunbaj — Thu, 26 Jun 2014 09:31:29 GMT

I need to abort the job if any row in an excel file contains null. Basically I have a input file with 3 columns. My requirement is that if any of the 3 fields contain null then the job should abort.
How do I achieve this.

Re: [resolved] Abort a job

sunbaj — Thu, 26 Jun 2014 09:37:07 GMT

I actually had this condition in my tMap and I was expecting it to fail automatically when the field value was Null but to my surprise it did not.
row2.Category.equals("Transfer to Self") ||row2.Category.equals("Fixed") || row2.Category.equals("Credit")?"0":"1"

Re: [resolved] Abort a job

Anonymous — Thu, 26 Jun 2014 10:13:45 GMT

Hi,
The expression in tMap should be

Condition?value if true: value if false

.
Are you looking for

row2.Category==null || row2.Category.isEmpty())?"1":"0"

.
Best regards
Sabrina

Re: [resolved] Abort a job

sunbaj — Thu, 26 Jun 2014 10:20:12 GMT

No I am not looking to bypass the Null or Empty condition. I want to actually abort the job itself as I need to then manually correct the file and then reprocess it again.
This is something that I amlooking into
row2.Category==null || row2.Category.isEmpty())?Abort the Process ubsequent conditions

Re: [resolved] Abort a job

sunbaj — Thu, 26 Jun 2014 14:41:57 GMT

Any suggestions please ???!!!!

Re: [resolved] Abort a job

gorotman — Thu, 26 Jun 2014 15:21:30 GMT

Hi,
do you need to abort the job immediately?
If you don't, you can write rows that contain null values to a reject flow (out of tMap). Thus you can abort job if number of rows in reject file is >0.

Re: [resolved] Abort a job

sunbaj — Thu, 26 Jun 2014 15:31:03 GMT

I wanted to avoid this option but if there is no other way then possibly will have to go this route.

Re: [resolved] Abort a job

Anonymous — Thu, 26 Jun 2014 17:00:31 GMT

hi all
use if condition that check number of row in the flow
tDie if == 0 , something else if not.

((Integer)globalMap.get("tLogRow_1_NB_LINE")) == 0

ps : in advanced setting of tDie you've got an option permiting to stop the job immedialtly
regards
laurent

Re: [resolved] Abort a job

Anonymous — Fri, 27 Jun 2014 05:40:13 GMT

That option is called Exit JVM.
Vaibhav

Re: [resolved] Abort a job

Anonymous — Fri, 27 Jun 2014 10:07:11 GMT

Hi sunbaj,
Is there any update for your issue?
Best regards
Sabrina

Re: [resolved] Abort a job

sunbaj — Sat, 28 Jun 2014 08:09:22 GMT

Sorry for the late response as I was travelling.
I basically wrote the records in a file where any of the fields were null and then checked for the record count in the file and aborted the process accordingly.