NullPointerException using date in tMap

One Star

NullPointerException using date in tMap

Hi,
I am running a job with several tPostgresqlnput component, a tMap and 2 tPostgresqlOutput. The tMap is managing reject for the inner join in one of the tPostgresqlOutput. In this tMap I am managing date data: creating date, changing date format or just insert date data from the input to the output (see screenshots).
When running the job, after retreiving data, the tMap failed with this error:
Exception in component tMap_1_TMAP_OUT
java.lang.NullPointerException
at java.util.Calendar.setTime(Calendar.java:1070)
at java.text.SimpleDateFormat.format(SimpleDateFormat.java:859)
at java.text.SimpleDateFormat.format(SimpleDateFormat.java:852)
at java.text.DateFormat.format(DateFormat.java:316)
at routines.TalendDate.formatDate(TalendDate.java:33)
at insee_sirene.establishment_data_step1_0_1.establishment_data_step1.tPostgresqlInput_1Process(establishment_data_step1.java:8002)
at insee_sirene.establishment_data_step1_0_1.establishment_data_step1.runJobInTOS(establishment_data_step1.java:17321)
at insee_sirene.establishment_data_step1_0_1.establishment_data_step1.main(establishment_data_step1.java:17209)
disconnected
Job establishment_data_step1 ended at 09:31 06/04/2009.

Do you know how I can get more information about where and what the errors occurs exactly?
Regards,
Y.
One Star

Re: NullPointerException using date in tMap

Hi,
The issue come from the inner join as I am using a date (and convert date -> string) as join key.
Y.
One Star

Re: NullPointerException using date in tMap

Last post : I changed the field type to "string" for the two fields used as key for the innner join. It seems that using function in the inner key is not allowed.
Y.

15TH OCTOBER, COUNTY HALL, LONDON

Join us at the Community Lounge.

Register Now

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch