Error: Output Data (39): Unable to create backup, Access is denied. (5)

[AjaySetty]

Hello Experts,

I have built one workflow with around 5 input files but linking all 6 output sheets into one file, but I receive this error for few outputs like below screenshot.

Does anybody know how to correct this?

[vijaylnyadav]

I have used AMP engine also and block until done but I am facing the same issue.

I want the output in single excel files but more than 12 sheets but facing the same issue.

I am using several block until done and AMP engine also ticked but no progress.

Please suggest some solutions or workflows.

[AjaySetty]

Yes it happens sometimes even after using BUD & AMP, so what I do here is to delete the output and backup file before running and it creates fresh files without issue.

Another thing to check is if you flow is sequential, you need to check if the workflow sequence is not interfering with output file.

[vijaylnyadav]

Here I have more than 14 files that is to be written on a single excel files with different tabs.

My workflow is sequence but still I am facing the same issue.

It successfully runs 2-3 times and after that it is throwing the same error.

after 10 runs 3-4 times success and remaining times error.

Please help me on this.

Thanks

[deepakreddy]

It's pretty simple. For me, I had the output file opened and it gave me this error. When I closed it and ran the workflow, it ran just fine.

[sophabraham95]

@vijaylnyadav were you able to solve this issue? It happens randomly for me as well. When I am writing into 50 files with multiple tabs in each file, 3 or 4 of them fail with the same error, but the remaining are written successfully. And I cannot use the AMP engine solution. But I have used the block until done and batch macro to write. Any suggestions?

error message:

Error: ResidualMacro2 (410): Record #10: WriteToTabMacro (96): Record #3: Tool #14: Unable to create backup of \Output\AAAAAAAA_ALTERYX.xlsx to \\Output\AAAAAAAA_ALTERYX.xlsx.bak: The process cannot access the file because it is being used by another process. (32