topic Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog), in Geodatabase Questions

ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JamalNUMAN — Thu, 14 Dec 2017 19:30:33 GMT

ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

I couldn’t figure out why the ArcMap fails to delete a “feature class” (Access denied GDB_System Catalog) knowing that this feature class is not published in ArcGIS Server.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JonathanQuinn — Fri, 15 Dec 2017 17:56:46 GMT

You can try to take a look at the .gbd contents in Windows Explorer and see if there's a .lock associated with a PID on the machine:

The highlighted value is the process creating the lock, for example ArcMap.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JamalNUMAN — Fri, 15 Dec 2017 19:32:55 GMT

Thanks JQuinn.

I can’t find that number in the PID field as shown in the screenshot below. What could be the issue here?

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JonathanQuinn — Fri, 15 Dec 2017 19:36:22 GMT

Hard to say, looks like that PID is 6620, but your screenshot is sorted descending starting at 34620. You don't see anything if you scroll down to 6620?

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JamalNUMAN — Fri, 15 Dec 2017 19:50:45 GMT

Scrolling down doesn’t show that specific number.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JonathanQuinn — Fri, 15 Dec 2017 22:42:16 GMT

Is that a shared path? If so, you can try to open the command prompt as an admin and run openfiles /query to see if anyone is accessing the share.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

ModyBuchbinder — Sun, 17 Dec 2017 06:01:29 GMT

The first element in the lock is the machine name.

Is HPZBOOKG3 the machine you are working on?

If not you should look for process 6620 on HPZBOOKG3 machine.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JamalNUMAN — Sun, 17 Dec 2017 17:49:44 GMT

Correct. hpzbookg3 is my local machine. Nevertheless, the 6620 is not there!

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JoshuaBixby — Mon, 18 Dec 2017 16:28:16 GMT

It appears to be an orphaned lock. Orphaned by what process I can't say, but there are a string of postgres.exe and GeoCortex process in that range, so maybe there was another process from one of them that crashed.

Try running Compress—Help | ArcGIS Desktop Compact—Help | ArcGIS Desktop to see if it clears the lock.

UPDATE: Knucklehead move, linked to Compress instead of Compact documentation.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

Lake_Worth_BeachAdmin — Mon, 18 Dec 2017 17:44:27 GMT

open the admin < manager < Locks dialog box in catalog and remove any locks on the FC then try to delete it. Its being used somewhere, it should also tell you what user/machine owns the file lock.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JamalNUMAN — Mon, 18 Dec 2017 19:08:24 GMT

Thank you guys for the input.

I couldn’t figure out how to go to admin < manager < Locks dialog box in catalog. Where is that?

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

Lake_Worth_BeachAdmin — Mon, 18 Dec 2017 19:14:15 GMT

right click the feature in Arc Catalog

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JoshuaBixby — Mon, 18 Dec 2017 19:15:11 GMT

The OP is dealing with file geodatabases, not enterprise geodatabases.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JoshuaBixby — Mon, 18 Dec 2017 19:15:53 GMT

From your screenshots, it appears you are using file geodatabases, so the functionality described earlier about locks isn't available.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

ChrisDonohue__GISP — Mon, 18 Dec 2017 19:57:46 GMT

The Compact (Data Management) geoprocessing tool also can be handy to employ as one of the side effects of its processing is that it releases locks.

To keep track of locked datasets, ArcGIS places *.lock files in the file geodatabase folder. When a process terminates, the .lock files associated with it are automatically deleted. In some cases, however, such as when a process ends prematurely, .lock files may be left behind in the geodatabase folder. These .lock files are eventually removed by ArcGIS in future sessions as new locks are taken. They are also removed whenever you run the geoprocessing Compact tool or copy and paste the data in the Catalog tree.

File geodatabases and locking—Help | ArcGIS Desktop

Note that the similar-sounding tool in ArcCatalog (Administration, Compact Database) does not have the same lock-releasing capability.

Chris Donohue, GISP

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

Rudy_Stricklan — Mon, 18 Dec 2017 20:25:23 GMT

OK, I know it's been knocked by others as potentially virus-laden (it's not) and a notorious data corrupter (I've never found it to be so), the free utility Unlocker works wonders on locked file geodatabases and many other Windows system files. This site tested Unlocker and found it to be malware- and virus-free, but as always, run it through your own local virus checker and back up your data files first.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

ModyBuchbinder — Tue, 19 Dec 2017 05:16:08 GMT

If the lock file belong to non exists process it should be possible to just delete it in windows.

Re: ArcMap fails to delete a “feature class” in file gdb (Access Denied GDB_System Catalog),

JamalNUMAN — Tue, 19 Dec 2017 18:08:20 GMT

Thank you all.

I tried the Mody’s suggestion and it worked fine