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
Solved! Go to Solution.
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.
You are trying to delete (how exactly?) a feature class and a "Rename Failed" is returned?
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.
Thanks.
Correct SQL server participated in replication with another database which was the reason we were unable to delete the FC.