topic Re: Error while running .bat file on Alteryx server in Alteryx Server Discussions

Error while running .bat file on Alteryx server

harsha384 — Tue, 08 Sep 2020 08:10:41 GMT

Hi all,

I am trying to trigger an event using .bat file in alteryx workflow.

It works fine on desktop.

But while running on gallery , its throwing an error

" The external program "_externals\1\abc.bat" returned an Error code 1'

Any help?

Thanks

Harsh

Re: Error while running .bat file on Alteryx server

tonypreece — Tue, 08 Sep 2020 08:16:01 GMT

I believe for security reasons, Alteryx won't let you run bat files (or anything using Windows Run command) from the server.

Re: Error while running .bat file on Alteryx server

harsha384 — Tue, 08 Sep 2020 10:03:59 GMT

Any solution to it? Is there any way i can resolve it? I have to use .bat file

Re: Error while running .bat file on Alteryx server

Akshu2020 — Tue, 12 Oct 2021 14:48:16 GMT

@harsha384 did you get the solution? if so please share it here, and would really helpful as I'm currently facing the same issue.

Re: Error while running .bat file on Alteryx server

Peachyco — Thu, 14 Oct 2021 11:49:01 GMT

I am able to run my own BAT file, but I had to write the code and place the BAT file in the temp folder. This is for an app that I've published to my company's Gallery. The app always creates a BAK file in the destination folder, so I created a temporary BAT file that deletes that BAK file.

As seen here, I have:

A subroutine that generates the code in the BAT file
An Output Data tool that creates the BAT file in the temp folder
A Run Command tool that runs the BAT file

This is the config of my Output Data:

And this is for the Run Command tool: