Problem with File Geodatabase Locking

[JenniferPhillips]

I am having problems with locks in our file geodatabase. I understand that multiple people cannot edit at one time, and that one person cannot edit while others are viewing the same layers. But we have an issue where once someone is in the map with the layer, and then closes out, it keeps the "sr" lock active, and sometimes an "rd" lock too. This prevents one user from being able to edit that layer, even though everyone else is closed out. Typically, the person already closed out will have to restart their computer to get the lock to finally release. This is a big problem, as you shouldn't have to have everyone restart their computer in order to edit.

Does anyone know how to get around this?

Thank you!

[WilliamCraft]

Understoood; however the funny thing is that only one person is editing. Every other user is simply viewing the file.

Viewing the contents of a file geodatabase OR editing its contents using an Esri product, it doesn't matter which, will produce a .LOCK file inside the file GDB's folder on the file system which can be seen via Windows Explorer.  It will contain some numbers in its filename, one of which refers to the process ID (PID) of the active process connecting to it.  To know which process or application has your FGDB locked, open Task Manager and explore the contents of your GDB folder on the file system using Windows Explorer.  Add the PID field to Task Manager and then compare the process IDs in Task Manager to that of the lock file to identify the culprit.  The presence of the .LOCK file is essentially an exclusive lock and won't allow you to do much else other than view the FGDB contents until it is gone. Killing those connections can be done by ending the process brutally in Task Manager or gracefully closing an application or stopping a GIS service, if applicable. 

Now, if there is no lock file or process holding on to the FGDB, then you probably have a system lock of some sort that hasn't cleared up.  Rebooting should resolve that; but if rebooting isn't possible then you'll need to close the FGDB files manually.  If you have Windows 7 or Server 2008 R2 or higher, then go to the Start menu and type 'fsmgmt.msc', pick the Open Files node, multi-select the files that are open in your FGDB folder, and right click them to close all.

[OlegLukyanov]

Hi,

Is there any way to edit data in file geodatabase with ArcGIS Desktop Basic and share it for viewing with ArcGIS Server map service without stop\start service by user?

It seems I could edit data in personal geodatabase in ArcMap and see changed data in ArcIMS ArcMap service earlier.


Thanks

Oleg

[WilliamCraft]

Hi,

Is there any way to edit data in file geodatabase with ArcGIS Basic and share it for viewing with ArcGIS Server map service without stop\start service by user?

It seems I could edit data in personal geodatabase in ArcMap and see changed data in ArcIMS ArcMap service earlier.


Thanks

Oleg

You can edit the data VALUES of your published object classes using a desktop or web client while the services are running.  I don't think the level of AGS dictates this.  But typically you cant make schema changes to those objects though since services place a lock on them when running.  Technically, you could modify the schema while the service is running if you change the schema locking setting in the service configuration file but unexpected results can occur until you restart the service anyways.

[OlegLukyanov]

"You can edit the data VALUES"

Is it true for ArcGIS Desktop Basic (former ArcView) and file geodatabase? As I understood from previous post it is possible trouble due file geodatabase locks?

Thanks

Oleg

[WilliamCraft]

"You can edit the data VALUES"

Is it true for ArcGIS Desktop Basic (former ArcView) and file geodatabase? As I understood from previous post it is possible trouble due file geodatabase locks?

Thanks

Oleg

I looked at a comparison chart for the basic, standard, and advanced levels of ArcGIS for Desktop.  The standard and advanced levels have "Edit a multiuser enterprise geodatabase" specified as a capability but the basic level does not.  That being said, I'm not sure if that translates into the functionality you're describing.  If you have a seat of ArcGIS for Desktop Basic, give it a try and post your results.  I'm just as curious as you at this point.

[OlegLukyanov]

Sorry,
but we don't have ArcGIS for Desktop Basic now. We have AGD Standard and ArcGIS for Server Stanard for WG.
And I need more inexpensive solution for our new users like file geodatebase editing.

Thanks

Oleg

[TylerVeinot2]

I am haing a similar issue, we have a file geodatabase that we access through ArcGIS 10.6 and QGIS 2.18.x and 3.4.6 and 3.6.1. QGIS was being used to make some simple edits and changes without issue. Suddenly several layers started throwing the error "Failed to Update Row (User does not have permission to execute this operation); No ones user permissions have changed to caused this. My ArcGIS is still able to edit and there are no locks on the data anywhere in the filegeodatabase so we don't understand what the issue is. As it is I am the only one able to edit and this is a huge hindrance because there are more edits than what I can do. I tried compressing/uncompressing, compacting, copying. The only thing that sort of worked was exporting the effected layers to a shapefile, deleting them from the geodatabase, and importing the shapfiles back into the database. Any thoughts on this one?