topic Re: Gallery - Error: Append to existing Excel File in Alteryx Server Discussions

Gallery - Error: Append to existing Excel File

Andre88 — Tue, 31 Dec 2019 14:54:53 GMT

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:

Record #1: Tool #236: Error while appending to existing sheet in Excel. File does not exist: D:\Alteryx\Service\Staging\1624_975f5b6f5cec41e2a77c171179f5518f\_externals\10\AddedData.xlsx (Tool Id: 73)

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!!!

Re: Gallery - Error: Append to existing Excel File

vmartinez — Tue, 31 Dec 2019 16:53:30 GMT

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

Re: Gallery - Error: Append to existing Excel File

Andre88 — Wed, 01 Jan 2020 00:29:28 GMT

I already tried that.
I changed it to relative path and has not solved the issue.

Re: Gallery - Error: Append to existing Excel File

jrgo — Thu, 02 Jan 2020 22:10:15 GMT

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 @vmartinez 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

Re: Gallery - Error: Append to existing Excel File

Andre88 — Wed, 29 Jan 2020 09:18:16 GMT

Thanks! 🙂