Server Error "Unable to Open archive for zipping:...The system cannot find the path..."

[calvincarr29]

When I run my workflow outside the Alteryx server it works fine. I have 4 outputs going to the same workbook but 4 separate sheets. 

When I run the workflow on the server I get this 4 times.

"Unable to Open archive for zipping: Q:\Alteryx\CAOutputs\ CA4_Output.xlsx Can't open file: Q:\Alteryx\CAOutputs\ CA4_Output.xlsx: The system cannot find the path specified. (3) (ToolId: 124)"

 

[apathetichell]

Can the server get to the Q drive? does that directory file exsist? if you are trying to overwrite (vs create a file) - the file must already exsist at that location. That would be the first thing I'd look at.

[OTrieger · Accepted solution]

@calvincarr29 
Alteryx server cannot have mapped diver as part of the path. Q: is a mapped drive and not the full path. Why? As the mapped drive is mapped on your computer and who knows what drive Q is set on the server computer, therefore NEVEREVER use a mapped drive to define a path in Alteryx!!!

Always use the full path of the folder and ensure that Alteryx user has access to it.

As long as you are running the automation from Designer you are using your user name to access the folder, the minute that the automation will be saved to the server the user name will differ.