Block Until Done Tool - Receiving Unable to Open File for Write Error

[Mahendra1997]

Dear Community,

I am a beginner in Alteryx and am facing difficulty in understanding why I continue to receive an error message, despite utilizing the "Block Until Done" tool for all the outputs that write to the same file (as shown in the screenshot below). When attempting to modify the placement of the "Block Until Done" tool within the workflow, then I'm getting multiple errors instead of one for other output tools that write to the same file.

 

I would greatly appreciate your help in resolving this issue. Attached is the workflow for reference.

Best Regards,

Mahendra

[binuacs]

@Mahendra1997 What are the error messages you are receiving while running the workflow?

[Mahendra1997]

@binuacs I'm receiving the following error: "Unable to Open file for write"

[Bren_Spill · Accepted solution]

@Mahendra1997 - Generally, you want to have the Block Until Done tool in the workflow at the earliest point where data is splitting into multiple streams. I can see a couple of places in your workflow where you can add/move tools:

1 - In the bottom portion of the workflow, the data splits into three streams of data, writing five outputs. You have two Block Until Done tools immediately after the Sort tool, these can be combined into one as per screen shots below. The Block Until Done tool further on in that stram of data looks to be correctly placed.

2 - The T output of these filter tools is sending data to different sections of the workflow where outputs are written. You can also try placing Block Until Done tools after the T output to see if that helps

I haven't been able to test this out as the workflow dependencies are not saved as all relative. But hopefully this is helpful.

Thanks

[Mahendra1997]

@Brendan_Spillane - Thanks a lot for the help. It worked😊