topic Re: NULL pointer exception in DATE data type in Talend Studio

NULL pointer exception in DATE data type

Anonymous — Tue, 26 Jun 2018 14:24:36 GMT

Getting NULL pointer exception in DATE data type field.

There is a join in my tMAP, but DATE field is straight move. DATE field is having DATE date type in both input and output.

Re: NULL pointer exception in DATE data type

TRF — Tue, 26 Jun 2018 14:27:44 GMT

Share your tMap

Re: NULL pointer exception in DATE data type

fdenis — Tue, 26 Jun 2018 14:30:15 GMT

did you have any variables?
did you have any filter on date?

Re: NULL pointer exception in DATE data type

Anonymous — Tue, 26 Jun 2018 14:31:13 GMT

PFA

Re: NULL pointer exception in DATE data type

fdenis — Tue, 26 Jun 2018 14:37:08 GMT

where is the link with row3 ?

Re: NULL pointer exception in DATE data type

Anonymous — Tue, 26 Jun 2018 14:38:47 GMT

i just added it, but i tried earlier. Even after the link, the null exception error is coming. Ignore the join. Please suggest me on NULL pointer exception in DATE data type

Re: NULL pointer exception in DATE data type

Anonymous — Tue, 26 Jun 2018 16:03:27 GMT

Hi,

I just had a look at the TMap you have shared.

It looks the data comes from multiple tmaps.

I believe your source in the attached is an output of another tmap.

Can you please share the whole screenshot of of job?

Can you also share the data journey of the columns you have mapped for those 2 date columns ?

What data type is the actual source of those date columns?

Cheers!

Gatha

Re: NULL pointer exception in DATE data type

Anonymous — Wed, 27 Jun 2018 05:20:03 GMT

this error pops up when i join the tMAP with a DB table. Please have a look.

IMG1.jpg
IMG2.jpg

Re: NULL pointer exception in DATE data type

Anonymous — Wed, 27 Jun 2018 07:38:18 GMT

Hello,

Could you please also indicate on which talend build version you got this issue?

Best regards

Sabrina

Re: NULL pointer exception in DATE data type

Anonymous — Wed, 27 Jun 2018 08:30:14 GMT

Hi,

Are you getting values in tlogrow when you don't have a connection?

I guess EXCEL is the key issue I guess.
Can you please right click on Excel cell where you have got the Date values and check their format and check if it's date. Pls make sure it matches with what you have in the Excel Metadata schema.

You can remove the tmap and null check up and map it directly.

Cheers!
Gatha

Re: NULL pointer exception in DATE data type

Anonymous — Wed, 27 Jun 2018 12:48:17 GMT

Version: 7.0.1

Re: NULL pointer exception in DATE data type

Anonymous — Wed, 27 Jun 2018 12:52:54 GMT

Please find the attached screenshot which has the date format in excel source file.

DAS2.jpg

Re: NULL pointer exception in DATE data type

Anonymous — Wed, 27 Jun 2018 15:41:58 GMT

With your current setup can you please remove the transformations you have defined in TMap for all date coloumns and try.

Re: NULL pointer exception in DATE data type

Anonymous — Wed, 27 Jun 2018 15:42:08 GMT

With your current setup can you please remove the transformations you have defined in TMap for all date columns and try.