Unable to overwrite files?

[cjw0813]

Hi,

I have a workflow that's overwriting several existing files. 

The workflow runs fine with Designer, or if I run the app locally. But I get the "Can't open file...Access Denied" error whenever I try to run it from the gallery.

Has anyone come across the issue?

[fmvizcaino]

Hi @cjw0813 ,

Are you opening and saving the same file in the workflow, or are you saving multiple sheets in the same Excel file?

If that is the case, you need to use the control containers or block until done (older versions) to order the saving process.

Even though it is working on your Designer, it may not work elsewhere because Alteryx doesn`t have a specific order for processing the tools. So maybe on the Server, the same file is being opened twice at the same time, whereas in your Designer, it is not.

Let me know if this is your case or if you have a different issue.

Best,

Fernando Vizcaino

[cjw0813]

Thank you for your reply.

I tested with control container,  parallel block, etc.. and it does not work.

I'm having the issue with the ones that's not in anywhere else in the workflow. If the file with the same full path exist, it would say "access denied"

[fmvizcaino]

Oh, ok, got it!

I missed the most important reason, which is the server not having access to the files. Where are the files located? Are they in a shared folder?

The files must be accessible by the server, which means the files must be located in a shared folder.

For both the server and you to have access to the shared folder, you must use the UNC path and uncheck the assets in the assets windows when you publish the workflow to the server.

https://knowledge.alteryx.com/index/s/article/Paths-and-Alteryx

https://knowledge.alteryx.com/index/s/article/Assets-and-Packaging-Workflows-1583460636757

Best,

Fernando Vizcaino