How to find the other process accessing the same yxdb file

MartWClimber

Hello Everyone,

For a couple of my Workflows I receive the following error:

 Error - ToolId 27: Error opening the file "[filelocation/filename].yxdb": The process cannot access the file because it is being used by another process. (32)

I know what the error means, the Workflow with this error couldn't access a .yxdb file because an other workflow was using it.

It is a hassle to find out which workflow is using that .yxdb file at the same time.

My question:

Is there a way where I can check to see which workflow is/was using that specific .yxdb file without going to the logs manually and looking for something like;

00:00:03.206 - ToolId X: [filelocation/filename].yxdb|Z records were read from "[filelocation/filename].yxdb"

mbarone

In my experience, and this JUST happened to me again last week, when you get that error, someone physically has the YXDB open on their machine.  They went to the actual YXDB file, and double clicked it to open it.  So it's not a workflow that's locking it.  As long as no one has that YXDB physically open, any number of workflows can read it in and work with it.  I have to put in a request with my IT dept to get them to find out who has it opened (because it's on a shared network drive) and have them force-close it.  And then I remind the users to never double click a YXDB.