topic Re: How to send pushd / popd command using tsystem component ? in Talend Studio

How to send pushd / popd command using tsystem component ?

Anonymous — Tue, 20 Sep 2016 07:59:56 GMT

I am trying to send array of system commands thru tSystem component.
command strings are,
"cmd /c pushd \\\\10.0.100.58\\ConsoleLive\\BI Integration Data\\Backup\\RetailerTextData "
"cmd /c move *.csv importedforgisserver"
"cmd /c popd"

I am getting error as given below.
-------
Exception in component tSystem_1
java.io.IOException: Cannot run program "cmd /c pushd \\10.0.100.58\ConsoleLive\BI Integration Data\Backup\RetailerTextData": CreateProcess error=2, The system cannot find the file specified
-------
Pl. advice.

Re: How to send pushd / popd command using tsystem component ?

Anonymous — Thu, 22 Sep 2016 05:32:05 GMT

There s nothing specific to tSystem component here. Try these things:
- Running this command through command prompt.
- Running single command at a time
This will help you to pin point the error area.

Re: How to send pushd / popd command using tsystem component ?

Anonymous — Thu, 22 Sep 2016 06:16:34 GMT

sankalp.verma wrote:
There s nothing specific to tSystem component here. Try these things:
- Running this command through command prompt.
- Running single command at a time
This will help you to pin point the error area.

Thanks for the input ,
I already tried ,there was no success in that so i have posted it here.

I guess talend can't handle //// continuous characters or i am doing something wrong in sending command.

(ROOT CAUSE : to use UNC path is when talend jobs with mapped network drive is executed manually it runs fine but the same will fail when scheduler tries to run it( windows 2008 R2). So i have to get help of UNC path and pushd popd here.)

Waiting for a reply from talend they are working on the issue.

Thanks.

Re: How to send pushd / popd command using tsystem component ?

Anonymous — Thu, 22 Sep 2016 06:20:49 GMT

In the past I have been able to use "\\\\" UNC paths to execute command using tSystem component. Can you try executing one command at a time?

Re: How to send pushd / popd command using tsystem component ?

Anonymous — Mon, 26 Sep 2016 08:43:22 GMT

sankalp.verma wrote:
In the past I have been able to use "\\\\" UNC paths to execute command using tSystem component. Can you try executing one command at a time?

Yes, it is not giving me errors if i use it as single commands. Thanks.

Re: How to send pushd / popd command using tsystem component ?

Anonymous — Mon, 26 Sep 2016 09:49:25 GMT

Then my idea will be to separate multiple commands with ";" and try to put multiple commands in a batch or script file and call that script file from talend.