topic Re: Invalid directory from server, but works fine from designer in Alteryx Server Discussions

Invalid directory from server, but works fine from designer

champ24 — Tue, 11 May 2021 21:45:59 GMT

Hello Experts,

I have created a workflow that picks up most recent file from sharepoint online and processes as needed, it leverages the directory, sort and sample tiles. The workflow runs as expected when run in designer. However getting errors when publishing to Alteryx server.

I am already setting up workflow credentials when publishing to server and also made sure the alteryx server account has owner permissions on the sharepoint site from where the recent/latest file is being read.

Error:

Invalid Directory "\\sharepoint.com\sites\Teams-PSDExports-20210204110012\Shared Documents\All Details\*.xlsx": The network path was not found. (53) (Tool Id: 49)

Re: Invalid directory from server, but works fine from designer

rkapoor — Wed, 12 May 2021 07:43:46 GMT

@champ24 do you know if the account that the workflow is run by on the Server/Gallery has permission to access the directory?

Also, I'd advise you set the directory paths to use the UNC versions in your workflow.

UNC is Uniform Naming Convention. Basically it removes relative paths (like custom mapped folders/drives) and replaces with their real name.

After you've built and saved your workflow, click: Options --> Advanced Options --> Workflow Dependencies --> All UNC

I also suggest, if you can, test to see if the workflow runs fine on the Alteryx Designer installed on the Alteryx Server machine as a test to see if its a permissions thing.

Re: Invalid directory from server, but works fine from designer

champ24 — Wed, 12 May 2021 12:16:17 GMT

@rkapoor

do you know if the account that the workflow is run by on the Server/Gallery has permission to access the directory?

Yes, Confirmed

Also, I'd advise you set the directory paths to use the UNC versions in your workflow.

UNC is Uniform Naming Convention. Basically it removes relative paths (like custom mapped folders/drives) and replaces with their real name.
As mentioned in the original post, I am using UNC path.

\\sharepoint.com\sites\Teams-PSDExports-20210204110012\Shared Documents\All Details\

After you've built and saved your workflow, click: Options --> Advanced Options --> Workflow Dependencies --> All UNC

Yes, this was selected

I also suggest, if you can, test to see if the workflow runs fine on the Alteryx Designer installed on the Alteryx Server machine as a test to see if its a permissions thing.

Dont have access to alteryx designer on server. But to eliminate the permissions thing I have tested to connect to a single file instead of recent file via directory from server to that location and that worked. But doesnt work when using directory.