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.
Sorry I meant to direct you to the Project preferences for stats & logs : https://help.talend.com/pages/viewpage.action?pageId=13797155 (and not the job settings) There are various places where stats & logs can be turned on/off. - using the components (for very specific and punctual stats/log needs), - using the job settings - using the project settings. Obviously you had said you had turned it off in the two first places, I was just wondering whether the third place was also off.
I am assuming that one turns off automatic stats and logs by deselecting 'Job Designs' for stats and logs settings within the 'File--> Edit project settings--> Use project settings' of the studio? As far as the image upload is concerned, I did the following: 1. Post Reply 2. show 1 Upload Slots 3 browse for the image file. 4. click OK. No file displayed and did not appear when submitting the reply
Yes, it should turn it off completely indeed.
There might be a bug here. What version are you on?
You could turn it off by unchecking the On Databases box as shown in the screen attached (Testing the upload a screenshot here too).
I have a talend job that had stats and logs set up, It's done by using below navigation
File->Edit Project Properties->Job settings-> stats & Logs
Refer the screen for property settings, while testing in talend studio it was works fine, i can able to see the files where all the stats ans logs are recorded under specified path, But the problem is after exporting the job i cannot get the stats and logs in .txt file, Where it will create for exported job, please advice.
Hi rathinasamyy
From your screenshot, I see you also output the stat&log onto the console, so do you see the stat&logs message printed on the console while executing the job script out of Talend Studio? The window disappear quickly once the job finishes, in order to read the message printed on the console, you can edit the job script and add this word at the last line:
pause
Shong
Thanks Shong,
Where the stat & log files will be stored when i executing the job from outside the TOS ( .bat file)
Because of i noticed when i run the job from TOS it's get stored whatever path i have specified in a above screenshot.
Advice me is there any global settings.
Hi
The path you specify in the File Path filed, see my screenshot. The job script is executed on the same machine where your studio is installed?
Which version are you using? There might be a bug on the version you are using, I just test this issue on the latest version 5.3.1 and it works fine, it output the stat&log message to the specified file.
Shong