Hi, @zahinrahman
Please check your file path and maybe already opened by other app or people.
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
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.
@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/td-p/1047104
PanPPAlteryx12-13-2022 12:03 AMHi @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.
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.
@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.
@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?
thanks for your responses. Unfortunately downloading the patch did not remove the error.
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.
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
Additional suggestions can be found here: https://knowledge.alteryx.com/index/s/article/Error-writing-Excel-file-to-Shared-Drive
Hi All,
My workflow has Block until done in few places and was working well. Recently I had to go back to the workflow and adjust some of the formulas that were before Block Until done. After doing so, Block until done doesn't seem to be working and my outputs are trying to write to multiple tabs of the same workbook at the same time.
I've read that the order in which tools are dragged onto canvas matter, but I have not added any new tools, just updated formulas, so not sure would this be counted by Alteryx as changing the order of the tools?
Also, AMP is off, I'm using Alteryx 2022.3 and unable to upgrade to use Control containers, which I know would be a perfect solution.
Any ideas of what went wrong and how to fix it, without rebuilding entire workflow?
