process cannot access the file because it is being used by another process
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello everyone,
I have come across situation wherein on every run of Alteryx workflow gives error "the process cannot access the file because it is being used by another process. (32)" in the output tool even though there is no instance of excel file is opened.
Notes:
1. There is no instance of excel is opened
2. Running this workflow on the local system.
3. Same workflow was running fine earlier and there is no change in the system configuration
Earlier all my workflows were running smoothly, any suggestions??
- Labels:
- Error Message
- Output
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Avinesh
Some times working with Excel can be really tricky.
You mention you are running it on the local system, are you outputting to a local drive or a network drive?
If the latter this can be caused due to a little bit of network latency in the way Alteryx streams the data to Excel.
In the drop down box for File Format, if you see Microsoft Excel Legacy please try that, if you don't see that please follow the post in here
If that doesn't work let me know
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JoeS ,
The workflow outputs the data in the local drive only.
Yes, it worked with File Format : Microsoft Excel Legacy but the run time of workflow is increased significantly.
As of now I am proceeding with this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Avinesh
I am glad we managed to get it working, but a little upset it's now slower for you.
Would you be able to share the workflow and I can test my side to see if I can replicate the issue you had?
Thanks
Joe
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @JoeS ,
Sorry for late revert.
I may not be able to share the workflow as it is in the client environment.
Since it looks like some driver issues either w.r.t. Alteryx or Excel drivers, I am in process of reconfiguration of the same. However I will keep you posted here in case it works after this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi, I'm facing the same issue - while trying to modify Excel file using PowerShell script. Could you please tell if you found the solution to this problem. Thank you!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@SowmyaNagaraju wrote:Hi, I'm facing the same issue - while trying to modify Excel file using PowerShell script. Could you please tell if you found the solution to this problem. Thank you!
When you say you are trying to modify using PowerShell how are you doing this in conjunction with Alteryx, via the Run Command tool?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @JoeS ,
Yes! I'm using Run Command tool to trigger PowerShell script. I also tried using event after run but received the same access error. Workflow runs without any error when it's run on Designer, I only face the error while running the flow on Gallery.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah, PowerShell may not be installed and/or allowed to run on the Server. You may be best to reach out to your internal IT team first to check that.
