Designer/Gallery: If <Specified Error> on tool, wait 5 seconds, then rerun tool

[PeteLacz]

In my continuation of resolving the following 'Output Data Error' associated with saving multiple tabs to a single excel file on a shared drive. I am looking for a way to rerun a single tool (Not the whole workflow) on the condition of a specified error.

Output Error: The process cannot access the file because it is being used by another process. (32)

I've resolved the error occurring when running the workflow on the designer, however, the gallery works differently and I need a solution.

Is there a way to have an error log output from a tool to accomplish something like this?

If <Specified Error> on tool, wait 5 seconds, then rerun tool with cached data. Attempt X times

Honestly, I think this logic needs to built into the Stock Output Data Tool. The pervasiveness of this error in my workflows since the 2022.1 upgrade has put some burden back on me to run workflows that I built for other users on the gallery. Which defeats the purpose of Alteryx all together for me.

[DavidSkaife]

Hi @PeteLacz 

I assume you're using the Block Until Done tool to ensure one tab has been finished writing to before writing the next tab? That should work fine on the Gallery..

Could you share a screenshot of the end of your workflow so we can assist?

[PeteLacz]

@DavidSkaife 

Yeah, I've tried a lot of different things already. Original thread here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Broken-Output-Tool/m-p/1050335#M260144

I'm basically looking for work arounds that will work in the gallery. As far as the designer is concerned, I can get it to work.

In this image you will just see the standard Output Tool config, and then the Macro config provided in the aforementioned thread.

The saves are all going to a different tab on the same target excel file. And yes, I turn one of the containers off. I don't run both.

Parallel Block until done does not work, Wait counters do not work, unless I probably set them apart at 20 second increments which would turn a 30 second workflow into a 4-5 minute workflow. But I'm not willing to go that route yet. 

[DavidSkaife]

Hi @PeteLacz 

So that looks complex! I assume your workstreams are all independant of each other and cannot be combined..

Just throwing it out there, and picking up from the other thread about the CreW macros and potential solutions; are you able to install the CreW macros on the server, so they are available from within Designer there? Then try and see if the Parallel Block Until Done tool works (i'm making assumptions on why it isn't working, so may be running down the wrong rabbit hole, if i am apologies!)

[PeteLacz]

@DavidSkaife I'll ask our Alteryx Admin if Crew macros can or need to be uploaded into the gallery for us. My understanding was always that the CREW macros would get uploaded along with whatever workflow I was saving, so long as I ensured it was selected under 'Workflow Options>Manage Workflow Assets"

That said, even using the CREW macro for Parallel block until done in the designer had failures. So I'm not optimistic it would work better in the gallery. But I'm all for retesting it.

I had No issues with this in version 2021. So Something changed in 2022.1 and to my knowledge no one has been able to pin point it yet

[Gabacho]

We just had our system upgraded to 2022.1 and I have run into the same issue.  I have tried to convert to batch macros, iterative macro, (this has it's own rediculous error), 'Wait a second, Crew macros. block until done................. Nothing works.

[geraldo]

@PeteLacz 

The block until done bindings are all on the same channel. Isti is not correct.
An output for recording the file
in 2 fly connect to continue the execution in all