NULL pointer exception in DATE data type

Eight Stars

NULL pointer exception in DATE data type

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.

Tags (1)
Forteen Stars TRF
Forteen Stars

Re: NULL pointer exception in DATE data type

Share your tMap


TRF
Ten Stars

Re: NULL pointer exception in DATE data type

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

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Eight Stars

Re: NULL pointer exception in DATE data type

PFA

Ten Stars

Re: NULL pointer exception in DATE data type

where is the link with row3 ?

Francois Denis

Tag as "solved" for others! Kudos to thanks!

Eight Stars

Re: NULL pointer exception in DATE data type

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

Seven Stars

Re: NULL pointer exception in DATE data type

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

 

 

 

 

 

Eight Stars

Re: NULL pointer exception in DATE data type

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

Moderator

Re: NULL pointer exception in DATE data type

Hello,

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

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Tags (1)
Seven Stars

Re: NULL pointer exception in DATE data type

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



Eight Stars

Re: NULL pointer exception in DATE data type

Version: 7.0.1

Eight Stars

Re: NULL pointer exception in DATE data type

 

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

Seven Stars

Re: NULL pointer exception in DATE data type

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

 

Seven Stars

Re: NULL pointer exception in DATE data type

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