This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
My workflow is shown error code as "unable to open file for write: Cannot access file because it is being used by another process". I suspect it's related to the block until done tool that's being placed. The weird thing is that every time I have the same error code but shown on different output. I have a block until done tool inserted in front of all the outputs. Can someone please help?
You have two ( in the first screen) parallel flows with the tools Block Until Done and the order between these flows can not be controlled. You need to modify the workflow so all flows will be coming from one Block Until Done tool. But this will require a lot of modification in your workflow. I would suggest another alternative - Parallel Block Until Done. This is a special macro that should solve your problem
place theBUDtool in the workflow branch with the lowest numbered Input tool ID. This ensures every subsequent branch waits to run until the previous branch is done and the tool works as expected. (click on each Input tool to see the Tool ID in the Configuration pane).
Parallel Branch Execution and Tool Run Order
Some workflows read from a file and then write back to it. This requires sequencing to ensure that the read is complete before the write can start. Similarly, a workflow that wants to write several sheets in one XLSX file needs to write the sheets one at a time. Alteryx Designer provides aBlock Until Done (BUD)tool to help partition the work into phases that won’t get in each other’s way. Same workaround is applicable for Email tool when you use output file(s) from previous branch(es) as attachment. You need to wait once data processing is complete and then add as attachment to the Email tool.
When you work on a workflow with multiple branches (largely separate streams from inputs to outputs), place theBUDtool in the workflow branch with the lowest numbered Input tool ID. This ensures every subsequent branch waits to run until the previous branch is done and the tool works as expected.
Tonya Smith Sr. Technical Product Manager, Alteryx Engines
Hi, thank you for the help. I have just used the parallel BUD tool to replace the two BUD tools that you circled. It ran successfully once but now it encountered the same problem again. Where can I put the parallel BUD tool in this case?
@wenyg you have 3 flows. With one parallel BUD tool, as you have in your screenshot, you do not control the order between 1 and 2, but only between 1/2 and 3. You need to add one more parallel BUD tool. So it should look like this