ERROR when running .bat file in "After Run" event

Hi All,

I have created a batch file to rename files after processing in a workflow.

I followed the instructions in this article:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Batch-Files-in-Alteryx-Part-1-Creating-bat-files/ta-p/15397

When I try to run this batch file in the events area of the workflow as "After Run", I get the following error:

Error: Designer x64: The Designer x64 reported: Error running Event #1: The external program ".\Test Workflow\Test Rename\2020-01\rename_files.bat" returned an error code: 1: The system could not find the environment option that was entered. (203)

With community search I found some discussions but unfortunately no feasible solution.

Can anyone help?

Thanks,

Michael

Workflow

Events

Run Command

Accepted answers

ChrisTX

Take a look at the workflow "run_command_code.yxmd" in this post:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/how-to-update-Run-configuration-using-Actions-tool/m-p/392453#M71917

All comments

ChrisTX

See this suggestion: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Bat-script-error/td-p/486262

Add a Pause in your BAT file.

Can you post the text in your BAT file?

AbhilashR

Hi @MichaD, as @ChrisTX suggested, see if you are able to run the batch file from command prompt to begin with.

As an alternative approach, you could also use the Run Command tool to execute batch files. I had put together this solution (attached) for another community post a couple of days ago, but should be a good reference in this case too. I too did get an Error code 1 a couple of times building this solution, and found the issue was that my source folder location was empty.

I am not sure my input here is adding much value, but thought I'll present an alternate approach and what worked for me.

fileWrite.zip

MichaD

Good hint, I will try to run it from the command prompt first.

I'll also give the Run Command approach a try.

Thanks @ChrisTX @AbhilashR

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703