Failed to Run External Program for a batch file

Having trouble trying to add my first Alteryx Workflow to be scheduled on a server. Getting the error message:
Failed to run external program "\\File_Location_Text\Run_Macros.bat": %1 is not a valid Win32 application. (193) (ToolId: 43)
My workflow using control containers to run a batch file that calls a .vbs script that runs macros in the output workbook. Attached is a screenshot of the configuration of my run command tool. Any help would be appreciated. Thanks!

Alteryx Issue SS.png

Developer Tools

Error Message

Macros

Batch Macro

Run Command

Accepted answers

apathetichell

. 1) share how your input source is configured. share any action tools. 2) share a screen show of your directory where you are drawing it from (and where your scripts are located)- and what is inside of Run_Macros.bat. What does it do with the parameter you are passing in? I can't really help here without more information. My hunch is this is user error or permission error. I cannot identity which.

All comments

apathetichell

where are you writing Run_Macros.bat? does this work locally? Can you remove Run_Macros.bat - and then rerun locally and see if this works? Asking because this looks like you are not creating the .bat file which are calling in this workflow - which is wrong.

MattReif_SE

Run_Macros.bat simply calls to run a .vbs script which runs the macro in my output workbook. Alteryx wouldn't recognize a .vbs in the run command so I had to chain it to get the desired outcome. The .bat is already created but it needed a dummy_txt in order to run as well

apathetichell

are you running mkdir or something somewhere else in your workflow? Alteryx says you need to create your directory first.

SPetrie

Does the dummy file get created when run on server? Does your server account have access to the network path of the batch file and the location of the scripts and outputs for the batch file?

If your default server account doesnt have access to the network locations (which is usually the case unless you changed it) you will need to run the flow with an account that does have access.

MattReif_SE

No, the dummy text is already in the folder, all of which is in the same location including the batch, vbs, text file, and the workbook itself. The fact that it can access the workbook should mean it has access to all of the other files.

apathetichell

No idea - how are you uploading your workbook? Is it a workflow dependency? If so it would migrate to an externals directory. I also don't know if this is phantom message caused by control containers. I can tell you that if I saw this message in an earlier version of Alteryx it would mean either the folder did not exsist, the file did not exsist or Alteryx did not have permission to access it.

MattReif_SE

No, the workbook is stored in the share drive and the workflow replaces a sheet within the workbook.

apathetichell

MattReif_SE

Ended up being permission errors with running macros in a share drive, eventually reworked the workflow to eliminate the macros. Thank you for the help.

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335