
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Fix a talend
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
instead of
diplome.code_statut_inscription== null
try this
Relational.ISNULL(diplome.code_statut_inscription)
and let me know if it works

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
