Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

NullPointerException on a tRunJob

Hello

I've got an exception in component tRunJob.
The idea of my job is to use a tRunJob to call many other jobs.
The main job is Main_Expertise. This job calls Main_Lot. And Main_Lot calls BI16_Lot_Fait.

For information, the whole treatment is working fine with Talend TOS on my VM. Now I use an AIX server. It works fine on DEV environnement, but return me this error on others environnements.

The execution is good, call all jobs without problems. Only after finishing the last job (BI16_Alim_Reglement), the component tRunJob catch the following error :
Exception in component tRunJob_3
java.lang.NullPointerException
    at bi16_expertise.main_expertise_0_1.Main_Expertise.tRunJob_3Process(Main_Expertise.java:4758)
    at bi16_expertise.main_expertise_0_1.Main_Expertise.tPostgresqlInput_1Process(Main_Expertise.java:3462)
    at bi16_expertise.main_expertise_0_1.Main_Expertise.tPostgresqlConnection_1Process(Main_Expertise.java:2540)
    at bi16_expertise.main_expertise_0_1.Main_Expertise.tRunJob_7Process(Main_Expertise.java:2431)
    at bi16_expertise.main_expertise_0_1.Main_Expertise.tRunJob_4Process(Main_Expertise.java:2181)
    at bi16_expertise.main_expertise_0_1.Main_Expertise.runJobInTOS(Main_Expertise.java:5355)
    at bi16_expertise.main_expertise_0_1.Main_Expertise.main(Main_Expertise.java:5038)

I see the job, who insert data in a SQL Server table. Datas are in the table, but a NullPointerException appears.

Here is screenshot of my work
Main_Expertise :                    Main_Lot :                        BI16_Lot_Fait :
0683p000009MHAJ.jpg            0683p000009MHAO.jpg         0683p000009MGTq.jpg                    

Thank a lot for your help.

Labels (2)
1 Reply
Anonymous
Not applicable
Author

This typically happens when you apply a function on a null value, you need to check your columns when you apply any functions.
got an example here : link