Six Stars

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!
  • Data Integration
4 ACCEPTED SOLUTIONS

Accepted Solutions
Employee

Re: Exception in component connectionStatsLogs

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.  

Six Stars

Re: Exception in component connectionStatsLogs

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!

Employee

Re: Exception in component connectionStatsLogs

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.

Employee

Re: Exception in component connectionStatsLogs

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

4 REPLIES
Employee

Re: Exception in component connectionStatsLogs

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.  

Six Stars

Re: Exception in component connectionStatsLogs

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!

Employee

Re: Exception in component connectionStatsLogs

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.

Employee

Re: Exception in component connectionStatsLogs

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