Issue Running Python via Alteryx Gallery Scheduler

Question

Hi Team,

I’ve built an Alteryx workflow that uses the Run Command tool to execute a Python script (see attached configuration snippet).

The workflow runs successfully when executed manually on the VM. However, when scheduled through Alteryx Gallery using my EID and password, it fails with the following error:

********"Failed to run external program "C:\Program Files\Python313\python.exe": The system cannot find the file specified. (2)"**********

We also tried using a .bat file to set the Python path and execute the script, but that didn’t resolve the issue.

Could you advise on how to make this work when scheduled in Gallery?

Regards,

Siddharth

jrlindem · Answer

Agree with @abacon, there are many things on gallery that need to be available and enabled for this to work:

* Run Command for the server (and enabled for any drive paths you're accessing)* You'll also need to make sure you filepaths are UNC format

* Python needs to be enabled for your Gallery
* Your Gallery needs to be mapped to see the .py files* Library management is also going to be something you have to manage on the server side

Ultimately, what you're trying to do should be possible but you'll need to work with your admins to ensure all the different features are on, available, and your commands match UNC paths, etc.

With all that said, can you re-create the .py script into an Alteryx workflow and slim down the python-specific pieces to leveraging the Alteryx Python Tool?  You may have more long-term success that way instead of bridging between Alteryx and Python using Run-Command.

dreldrel · Answer

Agreed with @abacon, could you go "C:\Program Files\Python313\" on your machine and see if you have python.exe there?

abacon · Answer

@SiddharthHW Is python installed to that location on the gallery machine? It is looking for that specific file, and my guess is the python executable is in another file location on the gallery machine.

Bacon