topic Re: Job started producing java.lang.NullPointerException error in Talend Studio

Job started producing java.lang.NullPointerException error

JM39 — Sat, 16 Nov 2024 02:00:23 GMT

Hello, I really need some help with this because it's really driving me mad. I had two jobs which previously (around a week ago) were running perfectly. I haven't changed the input file or anything else. Today I go to run it and it produces the dreaded java.lang.NullPointerException error.

I have an excel input file. I think what's causing the issue is this part in my tMap

row2.CountryCode.equals("")?
"MAIN_PURCH" :
(row2.CountryCode.equals("GB"))&&row1.Postcode!=null ?
row1.Postcode :
row2.CountryCode+"_MAIN_PURCH"

What I'm saying here is if the country code is blank, then MAIN_PURCH, else if

the country code is GB and the postcode is not null then use the postcode, else

Country Code+Main_PURCH

Appreciate any input!

I imagine I'm going to be told there's null values in my source data, but what I don't understand is that I haven't changed the input file & it was running before.

Re: Job started producing java.lang.NullPointerException error

Anonymous — Wed, 01 Jul 2020 14:53:43 GMT

Try this...

row2.CountryCode==null || row2.CountryCode.equals("")?
"MAIN_PURCH" :
(row2.CountryCode.equals("GB"))&&row1.Postcode!=null ?
row1.Postcode :
row2.CountryCode+"_MAIN_PURCH"

It sounds like your CountryCode may be null instead of an empty String.

Re: Job started producing java.lang.NullPointerException error

Anonymous — Wed, 01 Jul 2020 14:53:43 GMT

Try this...

row2.CountryCode==null || row2.CountryCode.equals("")?
"MAIN_PURCH" :
(row2.CountryCode.equals("GB"))&&row1.Postcode!=null ?
row1.Postcode :
row2.CountryCode+"_MAIN_PURCH"

It sounds like your CountryCode may be null instead of an empty String.

Re: Job started producing java.lang.NullPointerException error

JM39 — Mon, 06 Jul 2020 09:22:15 GMT

That's worked, thank you!

Re: Job started producing java.lang.NullPointerException error

JM39 — Mon, 06 Jul 2020 09:22:15 GMT

That's worked, thank you!