topic Re: Job throws NullPointerException as StandAloneJob, but in Studio the Job is running without Problem in Talend Studio

Job throws NullPointerException as StandAloneJob, but in Studio the Job is running without Problem

Anonymous — Fri, 27 Sep 2019 12:17:24 GMT

Hello talend-Community,

very strange Problem. There is a Job, that runs without any errors in the talend Studio. But when the job is running as Standalone Job, it throws NullPointerException.

Studio ist Open Studio for Data Integration 7.0.1 with jdk1.8.0_221 on Windows 10. The Server for the Standalone Jobs are SUSE Linux also with jdk1.8.0_221.

I`ve tried the jre instead of jdk, export and reimport the job ... absolutely no change of the error. I have no clue, why the job is running fine in studio and as standalone not.

Greetings

Michael

Re: Job throws NullPointerException as StandAloneJob, but in Studio the Job is running without Problem

Anonymous — Fri, 27 Sep 2019 12:49:15 GMT

Hi there Michael,

Can you provide more information on the topics below?

- How is you tMysqlOutput_1 configured? Can you take some screenshots on the component basic and advanced settings?

- What is the job supposed to do?

Regards,

Luiz

Re: Job throws NullPointerException as StandAloneJob, but in Studio the Job is running without Problem

Anonymous — Fri, 27 Sep 2019 14:09:57 GMT

Hello Luiz,

the Job compares new users with existing users in an LDAP and writes the new users in a MySQL DB.

Here the tMysqlOutput_1 setings and a view of the whole job:

tMysqlOutput_1 ist the third component

Re: Job throws NullPointerException as StandAloneJob, but in Studio the Job is running without Problem

TRF — Fri, 27 Sep 2019 14:19:02 GMT

Connect tJDBCConnection to tLDAPInput with OnComponentOK trigger to be sure i's executed before you try to connect to the DB

Re: Job throws NullPointerException as StandAloneJob, but in Studio the Job is running without Problem

Anonymous — Mon, 30 Sep 2019 08:42:03 GMT

Hei TRF,

great, now the Job works standalone too.

Thank you so much!!

Re: Job throws NullPointerException as StandAloneJob, but in Studio the Job is running without Problem

TRF — Mon, 30 Sep 2019 09:10:30 GMT

You're welcome