topic Fix a talend in Talend Studio

Fix a talend

CMIDN — Sat, 16 Nov 2024 00:10:32 GMT

Hi,

There is someone who know why this error appeare when i execute my talend and

how can i fix it : Java Exception;tMap_2;java.lang.NullPointerException:null ?

Sincerely

Re: Fix a talend

Anonymous — Tue, 11 May 2021 09:05:05 GMT

Hello,

We need more information to address your issue. What does your job design look like? On which talend build version you got this issue? Any background?

Best regards

Sabrina

Re: Fix a talend

Anonymous — Tue, 11 May 2021 09:15:56 GMT

Usually, this is because you are referencing a column that exist null value in the expression on tMap, a screenshot of tMap is helpful for us to address the issue.

Regards

Shong

Re: Fix a talend

CMIDN — Fri, 14 May 2021 07:59:01 GMT

Hi everybody,

Thank you for your help.

I explain in détail my probléme.

I've main job called “Synchro _Nouveaux_Entrant”

This job has many child jobs.

One of them is "Nouveaux_Entrant_MBA".

So when I carry out the main job it’s send me an error:

Synchro_Nouveaux_Entrants;serveur;6;Java Exception;tRunJob_3;java.lang.RuntimeException:Child job running failed.

java.lang.NullPointerException

at java.math.BigDecimal.compareTo(BigDecimal.java:2625)

The child job which cause this problem is "Nouveaux_Entrant_MBA"

on the screenshot beelow you 'll see his configuration.

As you may see, On this child job we have a tMap_2 component wich cause the issue by sending this error:

Nouveaux_Entrants_MBA;local;6;Java Exception;tMap_2;java.lang.NullPointerException:null;1

When i click on tMap_2 I can’t figure out the colonm which have a null value.

This is the expression on tMap_2 :

diplome.code_statut_inscription== null || !diplome.code_statut_inscription.equals("DEMISSION")

Could you help me please with this ?

Sincerely.

Re: Fix a talend

vbadri — Fri, 14 May 2021 10:58:53 GMT

instead of

diplome.code_statut_inscription== null

try this

Relational.ISNULL(diplome.code_statut_inscription)

and let me know if it works

Re: Fix a talend

Anonymous — Sat, 15 May 2021 00:43:35 GMT

This is an expression used to filter records, to me, the expression should work. For debugging, try to remove this expression and test to see if the error occurs again. Maybe the NPE is caused by other expression, do you have other expression on tMap1?

Regards

Shong

Re: Fix a talend

CMIDN — Sun, 16 May 2021 07:30:45 GMT

Hi,

i've tried yours suggestions.

With this expression : Relational.ISNULL(diplome.code_statut_inscription)

Without expression on tMap2 :

As you may see on the screenshot, i have the same error :

Exception in thread "main" java.lang.Error: Unresolved compilation problems:

When i switch on code tab related to tMap2 there is not error:

find attached the code.

I used on my open studio jre 1.8.0_201 may be it's not the good version?

However i have other expression on tMap1

liste.ID_AURION==null ?

(email.individu_id==null ? null : email.individu_id) :

liste.ID_AURION

Thank you very much for your help.

Re: Fix a talend

Anonymous — Mon, 17 May 2021 05:18:20 GMT

I am sure it is not a Java version cause. There is no error in the code tab, means no compilation error. Don't use the Test button to test the expression, it is not for the whole job. Click the Run button to run the whole job to check if you have the issue again.