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

[ShravaniChanda]

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.

[mceleavey]

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]

Hey @mceleavey 

I have attached the documents.

Assume test excel file a template and using append tool I am joining the different company codes to the path to create multiple paths which eventually helps in creating multiple templates, using the run command the copies get generated. In my original flow there will be multiple copies of templates falls into output folder based on the dynamic company codes from another part of the flow. 

Input folder will have the template. which has configured in formula. 

[mceleavey]

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]

Is this sufficient? Appreciate your help.

[mceleavey]

@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]

@ShravaniChanda 

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

Best, 
PKC

[ShravaniChanda]

this is the output of log

[ShravaniChanda]

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

[chinta · Accepted solution]

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