User receiving error in gallery but workflow owner does not

Question

I have a workflow that I developed for users to run in the gallery/server. It has input macros and an output to XLSX. When I run this on my desktop or the gallery, it runs fine for me. However, when my end user runs it – they receive a variety of errors. We are using the exact same input files. I’m not having luck in my research on this issue.

I’ve already tried to grant additional permissions to the user by adding them to various Connections but these are connections that are not used in this workflow. Attached are my workflow and the error messages.

AlteryxWorkflowShare.png

ErrorsKO.png

gawa · Answer

@tracie_wood It might be because of the Credential. In your Alteryx Server, do you configure setting so user are prompted to specify their Credential? If so, user's Credential(as Windows user) might not have permission to read input Excel and/or output Excel files.

If this is the case, here is the workaround:

1) if 'Run As' is configured in the Worker setting and its account has sufficient permission, use 'Run As' account

*it depends on what option is selected in Assets=>Workflow Credentials Settings in admin menu

2) Share the Credential of system account or service account, that has sufficient permission, to those users and let them use that Credential when running WFs

3) Simply give those users sufficient permission to input/output Excels