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
Highlighted
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch