Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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