Fix a talend

[CMIDN]

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

[Anonymous]

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

[Anonymous]

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

[CMIDN]

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.

[vbadri]

instead of

diplome.code_statut_inscription== null

 try this

Relational.ISNULL(diplome.code_statut_inscription)

and let me know if it works

[Anonymous]

Hi

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

[CMIDN]

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.

[Anonymous]

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.