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

Gallery - Error: Append to existing Excel File

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

Gallery

Error Message

Output

Accepted answers

jrgo

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

All comments

vmartinez

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.