Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Error while running .bat file on Alteryx server

harsha384
8 - Asteroid

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

4 REPLIES 4
tonypreece
10 - Fireball

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

harsha384
8 - Asteroid

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

Akshu2020
7 - Meteor

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

Peachyco
11 - Bolide

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

 

Untitled.png

 

This is the config of my Output Data:

Untitled2.png

 

And this is for the Run Command tool:

Untitled3.png