Using a bat file to delete not working in Gallery.

Question

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

VoodooUser · Answer

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

SPetrie · Answer

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.

apathetichell · Answer

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?