topic Error with inputs and output while running workflow on server in Alteryx Server Discussions

Error with inputs and output while running workflow on server

Nithinpanicker — Wed, 22 Jun 2022 07:11:02 GMT

I have a workflow designed to take inputs and result the outputs to a sharepoint synced to my computer. When uploading this workflow on to the server and running it, I run into errors with the output saying that it cannot access the folder.

Things to note:

I have all filepaths set to relative.

Workflow runs fine when running from designer.

I could use some help regarding how I can set server to read the inputs from right folder instead of the one listed in the error.

Thanks

Re: Error with inputs and output while running workflow on server

AmrMansour — Wed, 22 Jun 2022 08:50:17 GMT

Hi @Nithinpanicker,

Are you sure that your Server machine has access to Sharepoint?

As it's mentioned in this Article: When implementing this to an Alteryx Server, you will need to :

Make sure the mapping is the same for both Client and Server
Provide the Run As user / any specific user's credentials with access to that mapped SP location to read and write from.

Does this work for you,

Cheers,

Amr Mansour

Digital Customer Success

Re: Error with inputs and output while running workflow on server

Nithinpanicker — Wed, 22 Jun 2022 08:58:35 GMT

Hi @AmrMansour,

Thank you for your response. Could you please tell me how I can verify if the mapping is same for client and Server? I am not sure what the second point means.

I am really sorry, I am new to Alteryx and Server.

Re: Error with inputs and output while running workflow on server

AmrMansour — Wed, 22 Jun 2022 09:44:13 GMT

No problem at all.

I invite you to read this thread: Connect and download a Sharepoint Excel File

I believe that we should sync locally in both machines using an identic schema.

For the second point, you should look at this article explaining How Workflow Credentials Work on a Private Gallery.

Please feel free to ask here if you still need any help

Cheers,

Amr

Digital Customer Success

Re: Error with inputs and output while running workflow on server

AmrMansour — Wed, 22 Jun 2022 09:50:04 GMT

Get a look at this too: Integrating SharePoint and Alteryx in your Workflow

Re: Error with inputs and output while running workflow on server

Nithinpanicker — Wed, 22 Jun 2022 10:26:51 GMT

Hi @AmrMansour,

For integrating Sharepoint into workflow, I have followed the same as listed in the link to have the sharepoint synced to onedrive. The issue I have right now is that once I have uploaded the workflow into the server, its not able to read the specified sharepoint filepath and giving me errors.

I am not using any sharepoint specific tools. Just the normal directory and dynamic input to import the file from the synced folder.

Re: Error with inputs and output while running workflow on server

Nithinpanicker — Wed, 22 Jun 2022 10:37:04 GMT

@AmrMansour,

"I believe that we should sync locally in both machines using an identic schema." - Could you please elaborate on how this can be done?

Re: Error with inputs and output while running workflow on server

AmrMansour — Wed, 22 Jun 2022 12:52:58 GMT

For me, it looks like the relative path doesn't exist on your Server machine, Have you tried to use an absolute path pointing to your OneDrive on the Server machine?

Re: Error with inputs and output while running workflow on server

Nithinpanicker — Thu, 23 Jun 2022 04:42:33 GMT

Yes that also gave me the same error, Cannot access the folder.