NULL pointer exception in DATE data type

[Anonymous]

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.

[TRF]

Share your tMap

[fdenis]

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

[Anonymous]

PFA

[fdenis]

where is the link with row3 ?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

IMG1.jpg
IMG2.jpg

[Anonymous]

Hello,

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

Best regards

Sabrina

[Anonymous]

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