Output Excel File from Server to Network Drive

shardert

Hi all,

I have a workflow that I want to run regularly on the Alteryx server. It gets its data from a SQL database. The workflow spits out one three sheets into one excel file. I have a Block Until Done tool placed so that its not trying to write to the same file simultaneously. The problem happens when I try to save it to the gallery and run it. Evidently, the Alteryx Server does not have the proper permissions to access the folder to which I'm writing. I get an "Access is denied" error when I run on the server.

I tried changing everything to UNC paths in the workflow dependencies and unchecking the output file under the "Manage workflow assets" menu when uploading to the server. This didn't seem to help. I still get a "Cannot access the folder" error.

I've read through other threads on the community and nothing I've seen seems to address this issue. Unfortunately, I cannot share the workflow.

Does anyone have insight into how this error can be resolved? Any help is appreciated!

LordNeilLord

Hey @shardert 

It sounds like the user credentials that are used to run the workflows do not have permissions to that network folder.

My gallery is configured to run as a specific user account, which intern has permissions to read/write to all of the network drives.

I would suggest that you look at the folder permissions and grant access for the server to those folders