From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

How to send pushd / popd command using tsystem component ?

Highlighted
One Star

How to send pushd / popd command using tsystem component ?

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.

Highlighted
One Star

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

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.
Highlighted
One Star

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

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.
Highlighted
One Star

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

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?
Highlighted
One Star

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

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.
Highlighted
One Star

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

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. 

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog