topic Re: Is there an issue with tSCPFileExists ? in Talend Studio

Is there an issue with tSCPFileExists ?

Anonymous — Tue, 03 Jan 2017 11:20:26 GMT

I'm using the component tSCPFileExists of talend to check either my file which is in a remote server exists or not. But I'm getting this error

"'ls' is not recognized as an internal or external command "

It seems that talend has a problem with this component !

Re: Is there an issue with tSCPFileExists ?

Anonymous — Wed, 04 Jan 2017 02:48:44 GMT

Hi,
Could you please post your tSCPFileExists component setting screenshot on forum which will be helpful for us to address your issue?
Best regards
Sabrina

Re: Is there an issue with tSCPFileExists ?

Anonymous — Wed, 04 Jan 2017 09:00:28 GMT

This is my tSCPFileExists

And this is my hole job

Re: Is there an issue with tSCPFileExists ?

Anonymous — Wed, 04 Jan 2017 09:11:21 GMT

Hi,
From your screenshots, we see that you are using tjava component in your job. Do you want to print out message on console directly? What does the code look like? Could you please check if there is any error in java line?
Best regards
Sabrina

Re: Is there an issue with tSCPFileExists ?

Anonymous — Wed, 04 Jan 2017 09:17:59 GMT

I'm using tJava to print in my console directly if the file exists or not
Here is the code inside
System.out.println("File name : "+(String)globalMap.get("tSCPFileExists_1_FILENAME"));
System.out.println("Statut : "+(String)globalMap.get("tSCPFileExists_1_STATUS"));

Re: Is there an issue with tSCPFileExists ?

Anonymous — Wed, 04 Jan 2017 09:23:17 GMT

I took a look on the source code generated by Talend, here it is :

StringBuilder command_tSCPFileExists_1 = new StringBuilder();
command_tSCPFileExists_1.append("ls \"").append("E:/coreso")
.append("/").append("a.txt").append("\"");
globalMap.put("tSCPFileExists_1_FILENAME", "a.txt");

Hence Talend execute ls command on the remote machine, I guess it works on Linux based machines and not in windows ones. Is it true ?!
In fact, my remote server is a windows server 😕

Re: Is there an issue with tSCPFileExists ?

Anonymous — Wed, 04 Jan 2017 09:38:03 GMT

Hi,
Could you please indicate on which build version you got this issue?
Best regards
Sabrina

Re: Is there an issue with tSCPFileExists ?

Anonymous — Wed, 04 Jan 2017 09:43:18 GMT

Talend ESB 6.1.1
my mail : aabdellaoui@freedomofdev.com
phone number : 21620394340