One Star

Remote execution error

TIS 4.0.2.r43696
Linux
mysql 5.0 backend
I am trying to get a scheduled job to execute from my execution server. I have been assured by our network team that the execution server can talk to the database servers.
What specifically does "Exception in thread "main" java.lang.NullPointerException" refer to? A specific component?
Is it trying to fires component tMysqlSP_1 over port 10089? That would generate the " java.net.NoRouteToHostException: No route to host" error as traffic is only allowed over 3306. ALso this port changes with each attempted run of the job.
connecting to socket on port 10089
java.net.ConnectException: Connection timed out
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
at routines.system.RunStat.startThreadStat(RunStat.java:195)
at daily_imports.get_data_0_1.GET_Data.runJobInTOS(GET_Data.java:4335)
at daily_imports.get_data_0_1.GET_Data.main(GET_Data.java:4237)
Exception in component tMysqlSP_1
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2001)
at com.mysql.jdbc.Connection.(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at daily_imports.get_data_0_1.GET_Data.tMysqlSP_1Process(GET_Data.java:252)
at daily_imports.get_data_0_1.GET_Data$1.run(GET_Data.java:4368)
Caused by: java.net.NoRouteToHostException: No route to host
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.(Unknown Source)
at java.net.Socket.(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:168)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:262)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1926)
... 13 more
Exception in thread "main" java.lang.NullPointerException
at routines.system.RunStat.sendMessages(RunStat.java:282)
at routines.system.RunStat.updateStatOnJob(RunStat.java:408)
at daily_imports.get_data_0_1.GET_Data.runJobInTOS(GET_Data.java:4415)
at daily_imports.get_data_0_1.GET_Data.main(GET_Data.java:4237)
3 REPLIES
Community Manager

Re: Remote execution error

Hi
Does the job work in the studio? The problem is the communications link failure, please check if the firewall is close.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Remote execution error

Yes I can run the job from the studio. Is there anything in the configuration that could cause the failure? I will go back to my network team, but was curious if there is anything config wise that could affect this?
Port 10089 is listed in the error message, is that related to logging statistics or trying to execute the component?
Community Manager

Re: Remote execution error

Hi
Open the file <Tomcat installation directory>\webapps\Talend administrator deployfolder\WEB-INF\classes\configuration.properties and you will find this parameter:
# The range where find a free port on the Administrator machine, where the job will send the statistics informations during its execution
scheduler.conf.statisticsRangePorts=10000-11000
Make sure the firewalk is close and the port 10000-11000 is open on Administrator machine.
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business