Exception in component connectionStatsLogs

Irshad1 — Thu, 20 Jul 2017 04:34:10 GMT

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!

Re: Exception in component connectionStatsLogs

Anonymous — Thu, 20 Jul 2017 08:26:33 GMT

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.

Re: Exception in component connectionStatsLogs

Irshad1 — Thu, 20 Jul 2017 15:01:02 GMT

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!

Re: Exception in component connectionStatsLogs

Anonymous — Sun, 23 Jul 2017 14:31:06 GMT

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.

Re: Exception in component connectionStatsLogs

Anonymous — Sun, 23 Jul 2017 14:31:53 GMT

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

topic Exception in component connectionStatsLogs in Talend Studio

Exception in component connectionStatsLogs

Re: Exception in component connectionStatsLogs

Re: Exception in component connectionStatsLogs

Re: Exception in component connectionStatsLogs

Re: Exception in component connectionStatsLogs