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!
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.
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
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.
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.
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.
. 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.
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.
