Delete a feature class

478
3
Jump to solution
03-01-2020 10:21 PM
YatharthSah
New Contributor II

Hi All,

I am unable to delete a feature class from an enterprise Geo-database (SSMS 2012)

The error message being displayed here is :

Failed to rename the object . Underlying DBMS error:

Cannot rename the table because it is published for replication.

-Please be noted that all the services have been stopped prior to deleting the FC.

-This feature participated in Replication previously. However the replication has now been removed and the feature data set has been deleted(even though the feature dataset deleted, I was unable to delete/rename the feature class).

Here is the screenshot:

Any help on this would be highly appreciated.

Regards

Yatharth

0 Kudos
1 Solution

Accepted Solutions
ColinWerle1
Esri Contributor

Hi Yatharth,

Did it participate in SQL Server replication or enterprise geodatabase replication? Objects published via SQL Server replication cannot be dropped or renamed. This could be expected behavior and may not have to do with the geodatabase itself. If you want to delete or rename a feature class that participates in SQL Server replication you would first have to remove the object from the publication, or disable replication.

View solution in original post

0 Kudos
3 Replies
JoshuaBixby
MVP Esteemed Contributor

You are trying to delete (how exactly?) a feature class and a "Rename Failed" is returned? 

0 Kudos
ColinWerle1
Esri Contributor

Hi Yatharth,

Did it participate in SQL Server replication or enterprise geodatabase replication? Objects published via SQL Server replication cannot be dropped or renamed. This could be expected behavior and may not have to do with the geodatabase itself. If you want to delete or rename a feature class that participates in SQL Server replication you would first have to remove the object from the publication, or disable replication.

0 Kudos
YatharthSah
New Contributor II

Thanks. 

Correct SQL server participated in replication with another database which was the reason we were unable to delete the FC.

 

0 Kudos