topic Re: java.lang.NullPointerException Error in Talend Studio

java.lang.NullPointerException Error

RAJ6 — Sat, 16 Nov 2024 09:25:49 GMT

Hi Talend folks,

When I write below expression for particular column. I am Facing "NullPointerException".

How to solve this issues. please tell me?

(row8.Sales.equals("o") && row9.Bun.equals("B"))?
"B" : (row8.Sales).equals("o")?
"D" : (row8.Sales.equals("o") && row9.Bun.equals("B"))?
"B": row8.Sales

ERROR:

Exception in component tMap_3 (LM)
java.lang.NullPointerException
at local_project___java.lm_0_1.LM.tFileInputExcel_2Process(LM.java:19165)
at local_project___java.lm_0_1.LM.runJobInTOS(LM.java:21300)
at local_project___java.lm_0_1.LM.main(LM.java:21126)
[FATAL]: local_project___java.lm_0_1.LM - tMap_3 null

Re: java.lang.NullPointerException Error

vapukov — Wed, 09 Aug 2017 10:20:33 GMT

add check null

(row8.Sales!=null&&row9.Bun!=null)&&(row8.Sales.equals("o") && row9.Bun.equals("B"))?

You need add check null for all important columns

for example - first check - if any of columns null - than null
other variant - define default value for replace null

Re: java.lang.NullPointerException Error

RAJ6 — Wed, 09 Aug 2017 12:31:09 GMT

Thank you @vapukov

Re: java.lang.NullPointerException Error

pradeephc0671 — Tue, 04 Sep 2018 17:41:20 GMT

Hello,

I am experiencing a similar issue when using the sql editor. Do you mind giving more specific details on what you mean by "other variant - define default value for replace null"?

Thanks so much!

Re: java.lang.NullPointerException Error

kyawzin — Sun, 23 Jun 2019 11:00:32 GMT

Dear team,

I have the problem of NullPointerException Error but cause is little different. Please help me on the case.

Let say, I got csv file from other team with 10 columns, comma separated value. But one row has only 3 column's value.

While I load data in tmap, i got the error even though I put isempty or null function in tmap. Please see the image for detail and I saw no comma in one row, when error is start happening.

Capture.PNG

Re: java.lang.NullPointerException Error

Anonymous — Mon, 24 Jun 2019 03:24:02 GMT

Hello @kyawzin

Do your your input columns have null value? Could you please show us your tMap setting screenshot on community?

Best regards

Sabrina

Re: java.lang.NullPointerException Error

kyawzin — Mon, 24 Jun 2019 17:26:20 GMT

Yes of course @xdshi , please see the picture in the attachment.

I have noticed one thing but no idea. You can see in my previous picture, there is no comma in the middle row. Actually there must be comma even though there is no value for the rest of the columns. The error is start happening before that row.

Capture2.PNG

Re: java.lang.NullPointerException Error

kyawzin — Mon, 24 Jun 2019 18:17:58 GMT

@xdshi you can see my output result, some of the row are imported but start from the row which has only two value for 6 columns without comma for the rest column. Example see the line 711400.

Re: java.lang.NullPointerException Error

kyawzin — Sat, 29 Jun 2019 06:02:35 GMT

@xdshi , hi any comment?