The workflow only works one third of the time - Parallel Block Until Done

Question

Hi there,

I am having an issue with outputting excel file on my workflow.

My workflow looks like attached. Aside from Parallel Block Until Done, I am only using basic tools from Preparation Tools and Summarize Tool.

I have a few tables and I am trying to output those table in one excel file with multiple sheets.

This workflow works perfectly fine only about one out of three times.

I get an error as shown below or Excel file is corrupted other times.

Could anyone help me figure out why this is and how I can make it work every single time I run this workflow?

Thank you for your help in advance!

Sara

hroderick · Answer

If it works for you please mark as solved

Thanks

sakimur1 · Answer

I see, I am working on HDD but I will try on my PC's local drive.

Thank you!

hroderick · Answer

I struggled with the same problem and fixed it by writing to a local mapped drive like c: instead of a shared drive like \serner\folder.

I suspect the shared drives were syncing or backing up or caching writes and interfering with the next sheet.

To copy the finished file from c: to shared, i ran an after run event bat file