Block until done tool doesn't work

[zahinrahman]

[flying008]

Hi, @zahinrahman 

Please check your file path and maybe already opened by other app or people.

[zahinrahman]

thanks for your response. That input file is not open. Effectively I have 4 different tabs I want to output the data to. Only one of the tabs are actually created, while others show the error in the screenshot. So the workflow is running as it outputs that one tab

[jdminton]

I ran into this issue as well. There are workarounds, but there was a patch released to fix this issue. Please see the licenses and downloads page to update.

[Qiu]

@zahinrahman 
I could not find the patch that @jdminton mentioned

But better check this two

1. Try to turn off the AMP engine if you have it on.

2. As statement from this post, the matter of placing Block Until Done tool maters

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Unable-to-open-file-for-write/...

---

---

 

 PanPP

Alteryx

‎12-13-2022 12:03 AM

Hi @VaishnaviGinni 

When using the Block Until Done tool, make sure the tool is dragged first onto the Designer canvas before dragging in the output tools.

When using the block until done tool, the order in which the tools are placed in the workflow matter.

Hope this helps! Please like the post if it does.

---

[jdminton]

@Qiu this is the patch. I'm not sure why you don't see it. I understand that placement can matter, but it doesn't always matter. Furthermore, using it to output multiple sheets to the same Excel file, it shouldn't matter if there isn't a dependency. The error @zahinrahman is getting was the error that I was experiencing before working with support to find this patch. I can confirm the patch fixes the issue.

 

[Qiu]

@jdminton 

THank you for the input and it is indeed there.

I was looking around the the newly revision.

I do have a question that can we be sure that @zahinrahman is using this particular version so the patch can work?

[zahinrahman]

thanks for your responses. Unfortunately downloading the patch did not remove the error. 

[jdminton]

I might have jumped ahead of myself. I was thinking this was the block until done issue. Can you share your entire workflow or image of the entire workflow? This can happen with multiple Excel outputs. You must have a block until done tool in place before each output if they are going to the same Excel workbook.

[MRapp]

I have the exact same issue. Suddenly, the workflow doesn't continue after "block until done" tools. More disappointing, Alteryx doesn't give you a proper error message. I only figured out three weeks later running a weekly report that the data doesn't get updated.

The moment I turn off the AMP engine, it works again...
I am on Version: 2023.1.1.200 Patch: 1