community
cancel
Showing results for 
Search instead for 
Did you mean: 

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Use Server local drive to read and write files from Gallery workflow

Asteroid

Hi All,

 

I am trying to understand how do I use the Server local drive folders (such as C:\Alteryx\Data\Files) to read flat files as input and also write the outputs - all this after publishing the workflow to the Gallery. I tried doing it but often get file not found error.

 

I will re-attempt this today trying some different method but wanted to know if anybody here has been able to do that. Please let me know if I need to elaborate more on this.

 

 

Thanks,

Sagar

Moderator
Moderator

@sagar_agarwal - often times mapped drives differ in name (C,E) on different machines, so you will want to reference the UNC path instead. You can read more about updating that here.

Sophia Fraticelli
Customer Support Engineer
Alteryx, Inc.
Asteroid

Hi @SophiaF,

 

Thank you very much for your suggestions. I made the changes as mentioned in the article and tried saving the workflow again - only to get this error now. Any ideas how do I fix it?

Few things:

1) I am using the Designer present on the Server to build and publish the workflow. No local desktop Alteryx Designer involved.

2) I had tried changing the "Run As" feature in the Settings - entered the Server credentials at the place. This had fixed this problem but I can't use it since Server credentials (password) is dynamic - it changes everyday.

 

Scheduler Workflow Dependencies.PNGScheduler Workflow Error SQL.PNG

Moderator
Moderator

If you are on the Server machine itself, then setting the Run As is the way to go. Since your password changes everyday, I would recommend working with your IT department to create a domain account specifically for Alteryx that you can set as the Run As; as long as it has the necessary permissions to the folders, this should solve your problem

Sophia Fraticelli
Customer Support Engineer
Alteryx, Inc.
Highlighted
Asteroid

Hello,

 

I have the same problem as @ashkhan , I tried your solution :

change workflow dependencies to ALL UNC

save as my workflow in my company gallery alteryx

and to finish schedule my workflow 

 I have an input file deposit in netowrk folder and I wish I find my output file deposit in network folder 

but i still have the same problem, my workflow run with any error message. but still no output file on the network folder 

 

bug.PNGThank you!!!