Exception in component talendStats_DB

One Star

Exception in component talendStats_DB

I've tried to uncheck the use stats and use logs from project setting but still failing. Can you please let me know how to solve this?
Exception in component connectionStatsLogs
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
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:411)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1117)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:350)
at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2408)
at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2445)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2230)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
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:411)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)
at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
at award_historical. _historical_0_1. _historical.connectionStatsLogsProcess( _historical.java:3942)
at award_historical. _historical_0_1. _historical.preStaLogConProcess( _historical.java:908)
at award_historical. _historical_0_1. _historical.runJobInTOS( _historical.java:6890)
at award_historical. _historical_0_1. _historical.main( _historical.java:6683)
Caused by: java.net.UnknownHostException: daspgsql-01
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$1.lookupAllHostAddr(Unknown Source)
at java.net.InetAddress.getAddressesFromNameService(Unknown Source)
at java.net.InetAddress.getAllByName0(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at java.net.InetAddress.getAllByName(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:249)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
... 20 more
Exception in component talendStats_DB
java.lang.NullPointerException
at award_historical. _historical_0_1. _historical.talendStats_STATSProcess( _historical.java:5305)
at award_historical. _historical_0_1. _historical.runJobInTOS( _historical.java:6902)
at award_historical. _historical_0_1. _historical.main( _historical.java:6683)
Exception in component talendLogs_DB
java.lang.NullPointerException
at award_historical. _historical_0_1. _historical.talendLogs_LOGSProcess( _historical.java:4458)
at award_historical. _historical_0_1. _historical.tWarn_1Process( _historical.java:1225)
at award_historical. _historical_0_1. _historical.tJava_1Process( _historical.java:1120)
at award_historical. _historical_0_1. _historical.runJobInTOS( _historical.java:6911)
at award_historical. _historical_0_1. _historical.main( _historical.java:6683)
Exception in component talendStats_DB
java.lang.NullPointerException
at award_historical. _historical_0_1. _historical.talendStats_STATSProcess( _historical.java:5305)
at award_historical. _historical_0_1. _historical.runJobInTOS( _historical.java:6940)
at award_historical. _historical_0_1. _historical.main( _historical.java:6683)
6817 milliseconds
disconnected
disconnected
One Star

Re: Exception in component talendStats_DB

Hi,
It seems that your job still has the stats & logs enabled and whenever you are trying to execute it from outside studio (probably on different machine) it is failing due to invalid database connection details configured in the in the project settings section.
So before exporting your job uncheck stats & logs option in project settings and save it properly.
Make sure your project settings looks like below after disabling them.


Then try to execute the job from the outside studio either through terminal or command line.