Error deleting feature class, disappears from catalog but table remains in SQL Server

485
2
Jump to solution
02-04-2019 01:43 PM
KarynKerdolff
New Contributor III

I have a workgroup SDE geodatabase running on ArcGIS Server Workgroup 10.4.1 with a Microsoft SQL Server Express 2012 backend. I get a new parcel dataset every so often that I load into the SDE by importing it into a feature dataset in the SDE as "parcels_new," exporting the old "parcels" feature class to a file gdb for archiving, deleting "parcels," and finally renaming "parcels_new" to "parcels." 

This morning, it gave me an error when I tried to delete the old parcel feature class in Pro 2.3 (which I foolishly clicked past without screenshotting it) and, IIRC, said it couldn't delete it due to it being in use (I did have another project open in the background with that feature class added). However, the "parcels" feature class no longer shows up in the Catalog pane or in ArcCatalog. When I try to rename a new feature class to the old name in Pro, it throws error 999999. When I try to rename it in Arc Catalog 10.4.1, it says the new name "is already in use as an object name and would cause a duplicate that is not permitted." Maps that already had the "parcels" feature class added as a layer continue to work as if the feature class was still there. 

When I look at the tables in SQL Server Manager, the dbo.PARCELS table is still there (along with dbo.PARCELS_NEW), and dbo.PARCELS still shows up in the dbo.SDE_table_registry table. Part of me hopes that I can just delete the dbo.PARCELS table directly in SQL Server, but I'm sure that would be a Bad Idea. 

Any suggestions on how to force delete the old "parcels" feature class and clear out this weird db logjam?

0 Kudos
1 Solution

Accepted Solutions
Asrujit_SenGupta
MVP Regular Contributor

Some similar Threads:

Clean up orphaned records in the SDE repository tables 

https://community.esri.com/thread/187623-unable-to-delete-a-feature-class-from-arccatalog 

My suggestion:

1. Take a database backup before doing anything

2. Try creating a Table, named PARCELS, using SQL Server Management Studio

3. If Step-2 works, open ArcCatalog, check whether you can see this Table and try deleting it

4. If Step-2 doesn't work, Delete the existing PARCELS table from SQL Server Management Studio and then try Steps 2 & 3.

If you are not very sure of the above, get on a call with Esri technical Support and let them guide you through it after necessary troubleshooting...

View solution in original post

0 Kudos
2 Replies
Asrujit_SenGupta
MVP Regular Contributor

Some similar Threads:

Clean up orphaned records in the SDE repository tables 

https://community.esri.com/thread/187623-unable-to-delete-a-feature-class-from-arccatalog 

My suggestion:

1. Take a database backup before doing anything

2. Try creating a Table, named PARCELS, using SQL Server Management Studio

3. If Step-2 works, open ArcCatalog, check whether you can see this Table and try deleting it

4. If Step-2 doesn't work, Delete the existing PARCELS table from SQL Server Management Studio and then try Steps 2 & 3.

If you are not very sure of the above, get on a call with Esri technical Support and let them guide you through it after necessary troubleshooting...

0 Kudos
KarynKerdolff
New Contributor III

Thanks for the links. At first it didn't work, but after getting on the phone with ESRI and truncating away any locks, I realized I was looking for the table in a feature dataset, when it was really living at the "root" of the SDE. I don't know if it was there after I first tried the steps above, or after working with ESRI, but it's back and working nonetheless.

Not-so-pro-tip for future reference: the re-created feature class won't show up in a feature dataset, so don't forget to look through the whole catalog tree for it.

0 Kudos