NullPointerException on a tRunJob

Anonymous — Wed, 09 Mar 2016 14:17:05 GMT

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 :


Thank a lot for your help.

Re: NullPointerException on a tRunJob

Anonymous — Wed, 09 Mar 2016 18:05:40 GMT

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

topic Re: NullPointerException on a tRunJob in Talend Studio

NullPointerException on a tRunJob

Re: NullPointerException on a tRunJob