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

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?

Output

Schedule

Server

Accepted answers

joannasokolowska

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

All comments

fmvizcaino

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

joannasokolowska

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

fmvizcaino

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

Peachyco

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.

joannasokolowska

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.

joannasokolowska

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

fmvizcaino

Hey @joannasokolowska ,

What is the version of your Alteryx server?

joannasokolowska

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.

fmvizcaino

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

joannasokolowska

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335