Error: The process cannot access the file because it is being used by another process (32)

[Boontida]

Dear all, 

When my workflow is located on my computer, it can be well run and no error is shown. 

However, after I change the workflow location from my computer to the share drive. After running the workflow, I have found the error message "Error creating the file: The process cannot access the file because it is being used by another process. (32)".

Note:

1. My input and output is located in share drive.

2. I use the workflow similar to this post  Alteryx: Excel Templates with Blob Tools – Intersections and Overlaps (wordpress.com)   and the error message is shown on Blob Output.

Could you please advise the solution to fix this error ?

Thank you so much in advance.

[DataNath]

@Boontida with the issue coming from the use of a share drive connection, have you checked that the file isn’t already in use? This could be colleagues having the file open or even other programmes referencing/using the file whilst Alteryx is trying to.

[Boontida]

Dear @DataNath 

I've checked that nobody opens the file or uses the file.

[DataNath]

@Boontida are you able to give a bit more information as to what the output is? This error tends to happen when a user or process is using the file i.e. Tableau/Qlik etc. as well as another person. It can also happen when you have AMP engine enabled but more information can probably help us to pinpoint the issue better.

[Boontida]

Dear @DataNath 

My output is excel and we do not use AMP engine.

This is my workflow that is applied from this post: Alteryx: Excel Templates with Blob Tools – Intersections and Overlaps (wordpress.com)

The 1st formula tool has been set as below.

The 2nd formula tool after block until done has been set as below.

Then, the blob input is shown below.

And, the blob output is shown below. 

After running the workflow, the error message shows that >>> Error creating the file "xxxx" (as indicated in the path for blob field): The process cannot access the file because it is being used by another process. (32)".

Kindly suggest please.

Thank you so much.

[DataNath]

@Boontida in that article, it looks as though the blob part for moving the template is done straight away from the input data tool and the overwrite step is the only thing coming from the Block Until Done tool (output 2). Have you tried that? Also, can you confirm which part of your workflow tool 32 is? 

[jacklindenberg]

Did you end up finding a solution to this error? I'm facing the same exact problem

[pmaddox015]

I had the same problem. in my case i found that an output file had already been created from the template for the date in question. the solution was to delete the previously created output file and re-run. It appears that it does not overwrite an existing file.