Hello!
One of my workflow output is a Log file (Excel file) in which new data is appended to the existing sheet.
It works OK locally, but when I upload it to the gallery I get this error:
The job XXX did not complete successfully and resulted in the following errors:
It seems like I am saving a temporary file, which I am not. I have specificed by parameter the location of the output (fullpath)
My guess is that, for some strange reason Alteryx creates a temporary file when is run in the Gallery to append new data to an existing file.
Any ideas how to solve this one?
Thank you!!!
Solved! Go to Solution.
hi @Andre88,
My guess is that you need to manage your workflow dependencies.
Managing your Workflow Dependencies is a best practice for sharing because of the frequency that path references become broken when sending workflows between analysts, sharing on the Gallery, or scheduling workflows. The reason for this is that most path references are done specific to the system that a workflow was created on, before the workflow is moved to another location.
Try to change your output path to UNC
Found in the Options > Advanced Options > Workflow Dependencies
You can follow this post for more details
https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Workflow-Dependencies/ta-p/49696
Best,
Vianney
Hi @Andre88
I believe it's because that file is being packaged as an asset file when publishing to your Gallery. You can define which assets should and shouldn't get package when you're saving out to Gallery as illustrated below.
That said, you'll need to ensure that the location of your file is at a location that the servers run-as account has access to. If the file resides on a network share, as @VianneyM had mentioned, you'll need to be sure that the UNC path (\\fileserve\mydepartment\something\myfile.xlsx) is used and not a mapped letter.
Jimmy
Teknion Data Solutions
Thanks! 🙂