how to access directory situated on different server through TDF ?

[Anonymous]

Hi,

I have a job in TDF 6.3.1 which contains following design -

So I am fetching parameters from tFileInputdelimited_1and store in Global variable and pushed it into tFileOutputRaw_1,to create a output file.

But I want to create this output file to the directory situated on another server,but i have not access to that server by my credentials .

That's why I uses the output file path with Username who has the access to that server like this

"file:\\\\Servername\\c$\\Talend\\6.3.1\\cmdline\\studio\\out.txt"

But I am unable to create or access that direcotry.

Can any one suggest me what i have missed? Suggest me the solution pls..

Any how I want to access that directory otherwise I will not able to call  commandline.bat  file reside on that Server through tSystem_1 component.

Kindly reply soon....!

Thanks,

Vaibhav

[vapukov]

I can't understand - what command You try to use

make all simple 

all work, attached same .bat file as on previous example:

[Anonymous]

Sorry...!  I have attached wrong snapshot of tssh component.

I am just running tSSh component to print a message just for testing purpose that tSSh works or not  but I am not getting any result.

No action is performed when I run the job ,it simply running for long time for a printing a msg  and job is not terminates.

[Anonymous]

Hi ,
I am still facing the issue while executing .bat file on remote server by my local machine using tSSh componnent.

Is there any extra setting in tssh component? That I missed bcz I had checked log files of my Kpym Telnet SSh server, I am able to Login there with my provided credential like host name,Username etc.

But After that it hangs for long time .I am not
even able to print msg using echo command

Kindly suggest if possible...!

[vapukov]

it is not real time process, all printed after

most of jobs oriented for run from scheduler - so it problem not actual for 99,999% of cases ... just forget

[Anonymous]

Hi,

Sorry for inconvenience ...! Just last time clear my doubt if possible.

I have changed my approach , I don't know why but in my case tSSh not working.

Hence I build my job and copy the zip File to my remote server .In that zip File I get my job's .bat file . I want to run following multiple commands by tSystem in Single command option

tSystem_1 code:new String[]{"cd C:\\Talend\\6.3.1\\cmdline\\studio","CALL commandline_test.bat"} 

I can now execute my job over my remote server over cmd ,as I get results from tFileOutputRaw_1 in which I set C:\Talend\6.3.1\cmdline\studio path for output File, but I got below error in tsystem Component -->

Exception in component tSystem_1
java.io.IOException: Cannot run program "cd C:\Talend\6.3.1\cmdline\studio": CreateProcess error=2, The system cannot find the file specified
at java.lang.ProcessBuilder.start(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at java.lang.Runtime.exec(Unknown Source)
at avasf.auto_publish_n_deploy_job_0_1.Auto_Publish_N_Deploy_Job.tSystem
_1Process(Auto_Publish_N_Deploy_Job.java:3342)
at avasf.auto_publish_n_deploy_job_0_1.Auto_Publish_N_Deploy_Job.tFixedF
lowInput_1Process(Auto_Publish_N_Deploy_Job.java:3185)
at avasf.auto_publish_n_deploy_job_0_1.Auto_Publish_N_Deploy_Job.tFileIn
putDelimited_1Process(Auto_Publish_N_Deploy_Job.java:2665)
at avasf.auto_publish_n_deploy_job_0_1.Auto_Publish_N_Deploy_Job.tSetGlo
balVar_1Process(Auto_Publish_N_Deploy_Job.java:3632)
at avasf.auto_publish_n_deploy_job_0_1.Auto_Publish_N_Deploy_Job.runJobI
nTOS(Auto_Publish_N_Deploy_Job.java:7934)
at avasf.auto_publish_n_deploy_job_0_1.Auto_Publish_N_Deploy_Job.main(Au

Thanks,

Vaibhav

[Anonymous · Accepted solution]

Hi,

Finally issue resolved .I build my local talend job and include home directory with the path as same as the path on remote server where commandline.bat file resides.

Building talend job and execute .bat file of that job on remote server after copying zip file of job on the server. This Works fine for me. I refer following topics- 1) http://etladvisors.com/2014/05/06/windows-deployment-and-scheduling-of-talend-jobs/

2)https://community.talend.com/t5/Design-and-Development/Using-tSystem-to-launch-a-batch-via-remote-co...

Thanks,
Vaibhav