Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Irshad1
Contributor II
Contributor II

Exception in component connectionStatsLogs

Hi All

 

I am getting below error while executing my job:

 

[statistics] connecting to socket on port 3599
[statistics] connected
Exception in component connectionStatsLogs
java.sql.SQLException: Unknown server host name 'AHC-MSDBSQLBI02'.
      at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:427)
      at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
      at java.sql.DriverManager.getConnection(Unknown Source)
[FATAL]: talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM - connectionStatsLogs Unknown server host name 'AHC-MSDBSQLBI02'.
      at java.sql.DriverManager.getConnection(Unknown Source)
      at routines.system.SharedDBConnectionLog4j.getConnection(SharedDBConnectionLog4j.java:88)
      at routines.system.SharedDBConnectionLog4j.getDBConnection(SharedDBConnectionLog4j.java:166)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.connectionStatsLogsProcess(t_SFTP_GET_HLTHSTRM.java:974)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.preStaLogConProcess(t_SFTP_GET_HLTHSTRM.java:497)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.runJobInTOS(t_SFTP_GET_HLTHSTRM.java:4861)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.main(t_SFTP_GET_HLTHSTRM.java:4696)
Caused by: java.net.UnknownHostException: AHC-MSDBSQLBI02
      at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
      at java.net.PlainSocketImpl.connect(Unknown Source)
      at java.net.SocksSocketImpl.connect(Unknown Source)
      at java.net.Socket.connect(Unknown Source)
      at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288)
      at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:251)
      at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:331)
      ... 9 more
Exception in component talendStats_DB
java.lang.NullPointerException
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.talendStats_STATSProcess(t_SFTP_GET_HLTHSTRM.java:2846)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.runJobInTOS(t_SFTP_GET_HLTHSTRM.java:4873)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.main(t_SFTP_GET_HLTHSTRM.java:4696)
[FATAL]: talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM - talendLogs_DB null
[FATAL]: talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM - talendStats_DB null
[FATAL]: talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM - talendLogs_DB null
Exception in component talendStats_DB
java.lang.NullPointerException
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.talendStats_STATSProcess(t_SFTP_GET_HLTHSTRM.java:2846)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.runJobInTOS(t_SFTP_GET_HLTHSTRM.java:4911)
      at talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM.main(t_SFTP_GET_HLTHSTRM.java:4696)
[FATAL]: talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM - talendStats_DB null
[FATAL]: talend_default.t_sftp_get_hlthstrm_0_1.t_SFTP_GET_HLTHSTRM - talendLogs_DB null
[statistics] disconnected
Job t_SFTP_GET_HLTHSTRM ended at 15:26 19/07/2017. [exit code=1]
 
Please let me know where can I change the DB server name.
 
Thanks!
Labels (5)
1 Solution

Accepted Solutions
Anonymous
Not applicable

This is in the Talend Stats and Logs settings.  Either in Project Properties or in the Job General Settings. Most often it is in the Project Properties.  

View solution in original post

4 Replies
Anonymous
Not applicable

This is in the Talend Stats and Logs settings.  Either in Project Properties or in the Job General Settings. Most often it is in the Project Properties.  

Irshad1
Contributor II
Contributor II
Author

Thanks for the response, it was helpful. however is there a way to change the project properties from the TAC so that all the users connecting the talend studio will have access to same stats & logs database?

 

 

Thanks in Advance!

Anonymous
Not applicable

The configuration definition is done in the project (i.e. project properties) which is stored in SVN/Git as part of the project. And that configuration is embedded in all the jobs when the jobs are compiled.  Hence, there is nothing specific to TAC here.  The only link will be through context variables.  If you use context variables for the hostname, port, username, password and database, you can pass the values of those context variables in the TAC because they will be exposed as context variables of the job.  Hence, you can set different AMC database for different environments, or even just different jobs at runtime on the Job Conductor.

Anonymous
Not applicable

BTW, If you change it in the project, everyone will get the new properties when they open the project in the studio.