Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Using a bat file to delete not working in Gallery.

VoodooUser
5 - Atom

Hello all

 

I created a simple workflow that works in Designer. However when I transition the workflow to Gallery I get the below error. Any insights into the problem?

 

• The external program "C:\ProgramData\Alteryx\Service\Staging\3084_a30d3d5654fd47b7a80bd0aeff6a7b5d\_externals\1\DeleteFileWDrive.bat" returned an error code: 1 (ToolId: 3)

 

I have tried the following

- Making sure the service account has access to the drive

- Making sure the .bat file runs on the VM logged in as the service account

3 REPLIES 3
apathetichell
20 - Arcturus

What is the .bat file doing. Working under the assumption that the Server can find the .bat file - is there perhaps something inherrent in the file which the server can't do?

SPetrie
13 - Pulsar

Have you verified if the bat is actually doing what it should be doing when you run it on server? Sometimes a bat will run and do its work as expected, but the return code can be misinterpreted by alteryx and its displayed as an error.

If the bat is actually deleting the files as expected, you may just need to union in 'exit /B' as the last line of your batch file to bypass return code errors.

VoodooUser
5 - Atom

The .bat file is simply deleting a file. I've logged into the VM and ran the .bat file, works perfectly fine. 

Labels
Top Solution Authors