topic Re: unable to execute command using tSystem component in Talend Studio

unable to execute command using tSystem component

Anonymous — Sat, 16 Nov 2024 08:31:45 GMT

Hello

I am able to execute the following aws command at my local machine's command prompt:

aws s3 ls s3://pmassieh.talend.s3.bucket

However when I attempt to execute the same command from the tSystem component inside a job that runs on the same local machine:

I get error:

Am I missing anything here ?

Appreciate your help

Thanks

Patrice

Re: unable to execute command using tSystem component

Anonymous — Tue, 20 Mar 2018 20:22:56 GMT

Have you tried changing your aws command to include it's full path? I suspect that aws is not in your PATH variable.

Re: unable to execute command using tSystem component

Anonymous — Tue, 20 Mar 2018 21:06:31 GMT

yes in the tSystem Component I set the home directory where the aws executable resides . See screen shot, but still to no avail...

Re: unable to execute command using tSystem component

Anonymous — Tue, 20 Mar 2018 22:47:59 GMT

That is the location where cmd is started. I don't believe it will be where cmd's working directory will be when it opens.

Re: unable to execute command using tSystem component

Anonymous — Tue, 20 Mar 2018 23:13:33 GMT

How do I find out the commands working directory then ?

Re: unable to execute command using tSystem component

Anonymous — Wed, 21 Mar 2018 00:11:56 GMT

I can't test this as i don't have AWS on my machine and I am using a Mac (so the command will be different), but this may work for you....

"cmd /c \"c:program files/Amazon/AWSCLI/awscli/aws\" s3 ls s3://" + context.S3_Bucket

Re: unable to execute command using tSystem component

Anonymous — Wed, 21 Mar 2018 07:40:59 GMT

Thanks Rich

I tried that:

"cmd /c \"C:/Program Files/Amazon/AWSCLI/awscli/aws\" s3 ls s3://" + context.S3_Bucket

but still getting :

So looks like the space is the issue and is not being recognized...

Re: unable to execute command using tSystem component

Anonymous — Wed, 21 Mar 2018 09:43:48 GMT

Yes the space in the name is what would cause that, but I was hoping the quotes would prevent that causing an issue. As they would if you were to actually use that command in the command-line. The other thing to try is to add the path to AWS to your PATH operating system variable. Do that, restart Studio and run your original attempt and it should work.

The tSystem component is arguably the worst implemented component by Talend. I seldom use it and use Java instead because it makes things unnecessarily complicated. The other thing to try is to prepare a .bat file (maybe using your Talend job) and call it from the tSystem. Then you simply have to carry out a simple call and leave the .bat to do the hard work.

Re: unable to execute command using tSystem component

Anonymous — Wed, 21 Mar 2018 12:36:01 GMT

Thanks Richard. I will try that. Thanks for your help so far.