Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

The process cannot access the file because it is being used by another process.

Niki_90
6 - Meteoroid

I've had an Alteryx workflow scheduled with the scheduler for a long time now. Recently, I've been getting the same error each night when trying to write out.

"The process cannot access the file because it is being used by another process."

 

- The file I'm trying to output is a qvx.

- I find it hard to believe someone would have this file open since limited users have access to Alteryx.

- The file is written to a shared drive.

- My workflow is linear, so using a block tool is not the issue here.

 

I'm not sure what else to do besides rename the file, which did successfully output, but it would just be tedious to then fix it in the scheduler and all documentation.

 

Thanks for any help!

13 REPLIES 13
Aura_P
5 - Atom

This worked for me. Thank you!

aavillatoro
5 - Atom

I went through this issue when inputting file into a workflow but it was because i had the file opened in another application, so just make sure the file is only opened in Alteryx. 

haphan_tran
7 - Meteor
Genevieve
8 - Asteroid

There is now a new solution: the Conditional Containers. They allow to run the AMP engine and save about 3-4 times the time.

You need to put your output tool alone in a control container and then daisy chain them. In this way Alteryx will run one container at a time.

Personally I also name the control container with their step order: Output 1 of x, output 2 of x etc.

The first control container will receive the dataflow in the container and only run once it has all the data, the second container will receive the dataflow once the first container has finished, etc. It is the Use case #1 in Conditional Containers.

Labels