Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

The external program "%temp%\script.bat" returned an error code: 1

ShravaniChanda
8 - Asteroid

When i try to run command it is throwing an error. 

Error  The external program "%temp%\script.bat" returned an error code: 1

 

The same configuration worked in another workflow without any errors but in another flow it is showing errors.

ShravaniChanda_0-1623144112142.png

 

10 REPLIES 10
mceleavey
16 - Nebula

Hi @ShravaniChanda ,

 

we're going to need more information. Is your .bat file being dynamically created or are you just picking up a set file?

If it's being dynamically created check the formula tool that is creating the script to ensure you are using the correct logic.

Check the output file itself to ensure the output is what you need.

 

We need more information to help with this.

 

M.

ShravaniChanda
8 - Asteroid

Hey @mceleavey 

 

mceleavey
16 - Nebula

Hi @ShravaniChanda ,

 

thanks for that.

Can you please provide the error, as in the actual screenshot of the error?

I assume the error is on the Run Command tool.

 

M.

ShravaniChanda
8 - Asteroid

Is this sufficient? Appreciate your help.

 

ShravaniChanda_0-1623146806927.png

 

mceleavey
16 - Nebula

@ShravaniChanda , no problem.

Yes, that's good. Can you try outputting the file to a non-temp location then opening it in Wordpad. This will show you the actual structure of the file and may help us understand what is wrong.

 

M.

chinta
7 - Meteor

@ShravaniChanda 

 

Why not use Blob tools to do the same? I can provide additional info if interested. 

 

Best, 
PKC

ShravaniChanda
8 - Asteroid

ShravaniChanda_0-1623148098821.png

this is the output of log

ShravaniChanda
8 - Asteroid

I have never used that.my ultimate goal is to create copies.

 

chinta
7 - Meteor

I think you are better off using the Blob tools. @JosephSerpis has a blog showing the method. I have provided the link to it, but the site seems to be down at the moment. Check if you can access it later. 

Link: https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

 

Hope it helps

 

- PKC

Labels