topic Re: Error on gallery when running workflow with change file/table name option in Alteryx Server Discussions

Error on gallery when running workflow with change file/table name option

joannasokolowska — Wed, 13 Oct 2021 16:30:38 GMT

Hi all,

I have the issue with the workflow with Change file/table name. The workflow works without any issue when run in Alteryx designer but when schedule on Alteryx gallery error appears. Please see prtscreens of the workflow and error message.

Any suggestions?

Re: Error on gallery when running workflow with change file/table name option

fmvizcaino — Wed, 13 Oct 2021 18:00:00 GMT

Hey @joannasokolowska ,

Only to understand, when saving to your gallery, are you using network paths (\\networkpath\file.xlsx) or your own personal folders (D:\folder\file.xlsx)?

Best,

Fernando Vizcaino

Re: Error on gallery when running workflow with change file/table name option

joannasokolowska — Wed, 13 Oct 2021 18:29:16 GMT

I use network drive (not personal folder). I save there also other outputs from this workflow but the issue is only with this one.

Re: Error on gallery when running workflow with change file/table name option

fmvizcaino — Wed, 13 Oct 2021 19:44:15 GMT

I can see two possibilities there.

1. You are using more than one input/output for that same file and when saving to the Gallery, the workflow can run the tools in a different order giving that error.

2. Unknown error caused by a bug. In that case, I would suggest you to create a simple workflow with a brand new output tool with that same configuration and see how that goes.

Best,

Fernando Vizcaino

Re: Error on gallery when running workflow with change file/table name option

Peachyco — Thu, 14 Oct 2021 04:30:54 GMT

Are you using that output file as input somewhere else in the workflow? You might need to put some "Block Until Done" tools along the way to make sure that the workflow is done with drawing from the file before trying to write to it.

You might also try the CReW macro "Parallel Block Until Done" on your two output files. This would make sure that your workflow focuses on outputting to one file at a time, as opposed to trying to write to both at the same time.

Re: Error on gallery when running workflow with change file/table name option

joannasokolowska — Thu, 14 Oct 2021 10:47:09 GMT

Hey, the output is not using in other workflows. Initially there was block until done but the same error was appearing.

The issue is that Alteryx is trying to write output files in the same file but different TABs.

Re: Error on gallery when running workflow with change file/table name option

Peachyco — Thu, 14 Oct 2021 11:18:08 GMT

@joannasokolowska : If you're writing to the same file, then the CReW macro "Parallel Block Until Done" might work for you. I know that it does for me.

In this workflow, I'm writing to two different sheets in the same Excel file:

Re: Error on gallery when running workflow with change file/table name option

joannasokolowska — Thu, 14 Oct 2021 15:35:35 GMT

Hey I eventually redesigned the workflow and added at the end many block until done tools and many output tools. This eliminated the error!

Thanks,

Asia

Re: Error on gallery when running workflow with change file/table name option

fmvizcaino — Mon, 18 Oct 2021 14:58:12 GMT

Hey @joannasokolowska ,

What is the version of your Alteryx server?

Re: Error on gallery when running workflow with change file/table name option

joannasokolowska — Mon, 18 Oct 2021 15:26:07 GMT

Hey - I am not sure how to check it . When I click on the Server Help button it opens this site - > https://help.alteryx.com/20213/server.

Re: Error on gallery when running workflow with change file/table name option

fmvizcaino — Mon, 18 Oct 2021 16:45:01 GMT

Hey @joannasokolowska ,

Thanks!

Only so you are aware, you can see your Alteryx server version going in your profile and on the version tab.

Best,

Fernando Vizcaino

Re: Error on gallery when running workflow with change file/table name option

joannasokolowska — Mon, 18 Oct 2021 18:40:38 GMT

Thanks for the tip. This is the version we have: