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

[Anonymous]

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

[Anonymous]

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 

[Anonymous]

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

[TRF · Accepted solution]

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

[Anonymous]

Hei TRF,

great, now the Job works standalone too.

Thank you so much!!

[TRF]

You're welcome