topic Re: NullPointer Exception in tMap in Talend Studio

NullPointer Exception in tMap

Raghuram_Puram — Wed, 13 Nov 2019 07:54:33 GMT

Hi Experts,

I have a talend job that throws NullPointer Exception no matter what I try.

Job design goes something like this:

tHiveInput --> tMap --> tHDFS

I did the null check wherever I have used functions for transformations.

tHiveInput-->tLogRow - All records from source are flowing to tLogRow and printed on console.

tHiveInput --> tMap - job throws NullPointer after 1st record itself.

Please help.

Thank you!

Regards,
Raghuram

Re: NullPointer Exception in tMap

manodwhb — Wed, 13 Nov 2019 08:35:40 GMT

@rchinta , what are you doing in tMap. I believe you might have written some expression .

something like below.

for example:-

row1.col1.equals("IND")? "INDIA" :row1.col1

re-write below way ,so that you will not get null pointer exception.

("IND").equals(row1.col1)? "INDIA" :row1.col1

Re: NullPointer Exception in tMap

Anonymous — Wed, 13 Nov 2019 08:51:17 GMT

hello @rchinta

Can you please share more screenshots of Tmap and their datatypes,expression filter

Thanks,

Manish

Re: NullPointer Exception in tMap

Raghuram_Puram — Wed, 13 Nov 2019 09:11:45 GMT

Hi @vitspltalend ,

Please find the tMap below. Input data volume is low, am testing on a dataset of 150 records only.

I have done a debug run also and couldnt come to any conclusion.

Re: NullPointer Exception in tMap

manodwhb — Wed, 13 Nov 2019 09:20:05 GMT

@rchinta , it would be on different files ,where you were not handling null values and trying to check for some other expressions like journal_desc.

Re: NullPointer Exception in tMap

Anonymous — Wed, 13 Nov 2019 10:47:29 GMT

What I usually do is: I copy the job and I delete some fields so I try to find wich field is the problematic one

Re: NullPointer Exception in tMap

Raghuram_Puram — Wed, 20 Nov 2019 12:55:59 GMT

@haralba Thanks for the suggestion, it worked. I tried to check the mappings one by one and found that there was a context variable mapped to one of the fields which value was not assigned/loaded.

Evidently, that column was an Integer type and couldn't take Null values in it.

Removed that mapping and job was working fine.

Re: NullPointer Exception in tMap

Vijay_K_N — Wed, 22 Jan 2020 07:23:03 GMT

How to find null column if we have so many columns in given file

Re: NullPointer Exception in tMap

Anonymous — Wed, 22 Jan 2020 08:49:43 GMT

@lli, you can use tSchemaCompianceCheck to check the Null value base on the schema.

Re: NullPointer Exception in tMap

Vijay_K_N — Fri, 31 Jan 2020 06:19:09 GMT

if we have so many columns how can i manually check....if we put custom defined option in schemacomplaince check there is one option is available i.e nullable ,,why we need to tick all the columns to check if that column have nulls or not