I utilize several "Block Until Done" tools in throughout my workflow to generate an .xlsx file with eleven (11) tabs. I have been running this for 3 years with no issues. However today some of my Output Data (tabs) presented errors:
Output Data (338)
Unable to open file for write: \\**\**.xlsx - Can't open file: \\**\**.xlsx: The process cannot access the file because it is being used by another process. (32)
Output Data (443)
Unable to open file for write: \\**\**.xlsx - Can't open file: \\**\**.xlsx: The process cannot access the file because it is being used by another process. (32)
Output Data (173)
Unable to open file for write: \\**\**.xlsx - Can't open file: \\**\**.xlsx: The process cannot access the file because it is being used by another process. (32)
The file is not open. I rerun the .yxmd and while the error message is the same as above, the quantity may change (1 error; 5 errors; 3 errors), and the Output instances may change (Output Data (167), or Output Data (244)) each to a separate output. They all have Block Until Done earlier in the workflow.
This appears to me to be a timing issue. It is as if the population of a 'tab' has not closed before the next action begins - and therefore presents with an error.
Has anyone had this timing issue with the Block Until Done tool? Any recommendations on a solution?
