Exception in component talendStats_DB

Anonymous — Wed, 18 Feb 2015 23:42:54 GMT

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

Re: Exception in component talendStats_DB

_AnonymousUser — Thu, 19 Feb 2015 09:57:34 GMT

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.

topic Exception in component talendStats_DB in Talend Studio

Exception in component talendStats_DB

Re: Exception in component talendStats_DB