topic Re: Unexpected NullPointerException in tMap in Talend Studio

Unexpected NullPointerException in tMap

Anonymous — Tue, 11 Jun 2019 14:27:14 GMT

Hi Talend Community, i really need your help.

I don't understand why i get a NullPointerException.

Here is my job :

First of all, i read all the datas from an excel file that is the input of the tMap below :

Let's focus on the EntreeProjet output because this is where the problem come from.

Untill now, there is no problem. The outputexcel_4 look like i want.

Here it comes...

I read the previous outputExcel on a lookup connection of the tMap below :

And i when i execute the job, i get the below error :

I desactivated all the other components.

I know what means a NullPointerException but i really don't understand why i get one here.

I have another output with the same schema but different datas and there is no problem.

Thank you in advance. If you need more information, ask me.

Re: Unexpected NullPointerException in tMap

TRF — Tue, 11 Jun 2019 14:36:43 GMT

Click the upper left button in the tMap component ("Setup the configurations of tMap") then untick the option "Die on error".

This will add an output flow called ErrorReject. Redirect this flow to a tLogRow component, it could help you to discover the origin of the exception.

Re: Unexpected NullPointerException in tMap

Anonymous — Tue, 11 Jun 2019 14:48:58 GMT

I get this output.

That's inetresting because, all the rows that i want to go in the tPivotToColumnsDelimited are going. But all the others get a nullPointerException.

Re: Unexpected NullPointerException in tMap

TRF — Tue, 11 Jun 2019 15:07:31 GMT

Based on your previous post it seems you take care of the "EntreeProjet" field but what about the "date" field?

If this field is null you'll get an NPE.

Re: Unexpected NullPointerException in tMap

Anonymous — Tue, 11 Jun 2019 15:18:02 GMT

This field can't be null. There is always a date for every row.

As i told, all the rows i want are well send to the tPivotToColumnsDelimited like all my others output.

Why, here, are there a conflict with the rows not matching the join filter ?

Is it not the principle of this type of join to only get the rows matching and discard the others ?

Thank you in advance.

Re: Unexpected NullPointerException in tMap

Anonymous — Tue, 11 Jun 2019 15:29:57 GMT

Ok my bad TRF. You were right. I added a filter to get only the rows where date is not null and it's working as expected.

I don't really understand where the date can become null but the problem is solved so thank you !

Re: Unexpected NullPointerException in tMap

TRF — Tue, 11 Jun 2019 15:32:18 GMT

Great!

Thank you for Kudo and to have marked your case as Solved.