Stop usage of stats and logs

[Anonymous]

I have a talend job that had stats and logs set up to a database in the stats and logs tab of the job. The server that the database was on has been decommissioned. I tried to turn off the stats and logs in the job and the job runs successfully from the studio. However, if the shell script for the job is run, it returns "java.sql.SQLException: Network error IOException: Connection refused" error and the jdbc driver show the following:
dbDriver:net.sourceforge.jtds.jdbc.Driver
url:jdbc:jtds:sqlserver://usa0128as009:1433//AMC;appName=RAW;
userName:gmorey
password teelers1
dbConnectionName tatsAndLog_Shared_Connection

This is the server and database that has been decommissioned. Can you tell me what I need to do to resolve this? I need to be able to run the shell script.

[Anonymous]

Hi,
Did you export your talend job as the article said How to export Jobs.
Best regards
Sabrina

[Anonymous]

Hi
Are you sure you have re-export the job script and run it? and there is no DB component point to the same DB in the job?
Shong

[Anonymous]

Since I can't seem to be able to upload an image of the export, here
are the settings that I used on the Export Jobs window:
Job version: 0.1
Export type: Autonomous Job
Options: All boxes are checked
User routines box checked and All in the pulldown
Export Dependencies box checked
Apply to children box checked
Linux is the context type

The job was re-exported and run. There actually are no DB components in this job...it appears to be trying to utilize the AMC database on the decommissioned server that was used for stats and logs. stats and logs settings have been turned off, and there are no tStatCatcher, tLogCatcher or tFolwMeterCatcher components in the job.
Any help would be appreciated.

[Anonymous]

Hi,
For registered users, I realize the image upload feature is only available when clickin on "post reply" (not through the quick post")
This would be easier for you and more convenient for other users to address your issue quickly.
Best regards
Sabrina

[Anonymous]

I tried using 'Post reply' and it did not work.
Can anyone please help me with the stats and logs issue?

[Anonymous]

Hi,

I tried using 'Post reply' and it did not work.

Did you notice the limitation :"Limits: 20 images per post, each image must be less then 1024x768 pixels and 200 KB "?
Best regards
Sabrina

[Anonymous]

Yes. The file is less than 1024x768 pixels and less than 200KB.

[Anonymous]

Hi gmorey,
Check out your Studio preferences to see if the automatic stats & logs are turned off:
https://help.talend.com/pages/viewpage.action?pageId=13797754#Raa97258
If needed, turn this off and reexport your job.

Off topic: can you detail your issue with the image upload here. I can't reproduce. You clicked "Post reply" and selected the number of image slots but couldn't complete the operation?

[Anonymous]

I am reposting the error. I turned off stats and logs setting and am not using any of these components.
This are the steps taken prior to the error.
1. Turned off stats and logs in the job tab of the job. The stats and logs previously used usa0128as009 as the host.
2. Exported job as an autonomous job with Linux context.
3. .sh file was run on server and produced the error stated below. Please note that usa0128as009 is a server that has been decommissioned.
Child job return 1. It doesn't terminate normally.
Exception in component connectionStatsLogs
java.sql.SQLException: Unknown server host name 'usa0128as009'.
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:401)
at net.sourceforge.jtds.jdbc.ConnectionJDBC3.<init>(ConnectionJDBC3.java:50)
at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at routines.system.SharedDBConnection.getConnection(SharedDBConnection.java:63)
at routines.system.SharedDBConnection.getDBConnection(SharedDBConnection.java:131)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.connectionStatsLogsProcess(SendMailFTPFileExists.java:1424)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.preStaLogConProcess(SendMailFTPFileExists.java:570)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.runJobInTOS(SendMailFTPFileExists.java:3970)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.main(SendMailFTPFileExists.java:3822)
Caused by: java.net.UnknownHostException: usa0128as009
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:195)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:529)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:307)
at net.sourceforge.jtds.jdbc.SharedSocket.<init>(SharedSocket.java:257)
at net.sourceforge.jtds.jdbc.ConnectionJDBC2.<init>(ConnectionJDBC2.java:311)
... 10 more
Exception in component talendStats_DB
java.lang.NullPointerException
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.talendStats_STATSProcess(SendMailFTPFileExists.java:2625)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.runJobInTOS(SendMailFTPFileExists.java:3983)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.main(SendMailFTPFileExists.java:3822)
Exception in component talendStats_DB
java.lang.NullPointerException
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.talendStats_STATSProcess(SendMailFTPFileExists.java:2625)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.runJobInTOS(SendMailFTPFileExists.java:4022)
at raw2.sendmailftpfileexists_0_1.SendMailFTPFileExists.main(SendMailFTPFileExists.java:3822)
Please help!