Running a .bat file from Execute Command Fails

Seyed · Post by **Seyed** » Wed Mar 19, 2014 12:24 pm

Hi all,
I am trying to run a .bat file from an execute command stage in a job sequence. I keep getting the 'The system cannot find the file specified' message. This is even after I fully qualify the file. Does anyone know what I am doing wrong?

Here is what I have put in the 'ExecCommand' tab in the Execute Command stage. I even tried it by putting the entire line inside single or double quotation marks.

Code: Select all

D:\DataStageProcessing\AFS\Output\TableCompare1.bat

Below is the error message that is resulted:

Code: Select all

@Execute_Command_9): Executed: D:\DataStageProcessing\AFS\Output\TableCompare1.bat
Reply=1
Output from command ====>
The system cannot find the file specified.

Thank you for your help,

Seyed

chulett · Post by **chulett** » Wed Mar 19, 2014 12:51 pm

What drive letter is DataStage installed on - something other than D:?

Seyed · Post by **Seyed** » Wed Mar 19, 2014 1:15 pm

Hi Craig,
Thank you for your help. I just checked, the installation is also on D:\ drive but on D:\DataStage7.5 folder.

Seyed

chulett · Post by **chulett** » Wed Mar 19, 2014 1:49 pm

Wanted to check as you can't execute a command on a drive letter without switching to that drive first. What does the .bat do? Guessing the error is from an internal step as the error would be different if it wasn't finding the batch file itself:

Code: Select all

'whatever' is not recognized as an internal or external command, operable program or batch file.

Seyed · Post by **Seyed** » Wed Mar 19, 2014 2:31 pm

Hi Craig,
Thank you for the information. I checked errors on the server's event viewer and didn't notice any errors that coincides with the time I tried running the job sequence.

Here is the content of the .bat file.

Code: Select all

type tableNotFound1.txt | find /v /c "ZZZZZZ" > alpha.txt

Thanks again,

Seyed

chulett · Post by **chulett** » Wed Mar 19, 2014 2:54 pm

The type function can't find "tableNotFound1.txt" - fully path it or "cd" to the directory where it lives first to use that relative path.

chulett · Post by **chulett** » Wed Mar 19, 2014 9:27 pm

Just to complete this, the CWD or Current Working Directory of any running job is the base Project directory of the job. That is where it is looking for your file.

Seyed · Post by **Seyed** » Thu Mar 20, 2014 7:21 am

Hi Craig,
Thank you for helping me with this. With help from your input, I was able to resolve this issue by doing the following:

In the job sequence:
In the Execute Command stage, I typed the following in the 'Command' box,

Code: Select all

\\servername\d$\DataStageProcessing\AFS\Output\TableCompare1.bat

In the .bat file:
Next, I did a remote desktop to the server and then using Windows Explorer, I located the .bat file 'TableCompare1.bat' and changed the line to the following:

Code: Select all

type D:\DataStageProcessing\AFS\Output\TableNotFound1.txt | find /v /c "ZZZZZZ" >  D:\DataStageProcessing\AFS\Output\alpha.txt

These changes solved this problem.

Thanks as always for helping us in this Forum.

Continued Success,

Seyed