topic Re: Feature Dataset do not delete (SDE) in Data Management Questions

Feature Dataset do not delete (SDE)

DavidAlvarez — Tue, 10 May 2011 12:03:41 GMT

I have three feature datasets in an SDE (version 10) that i can not delete. They were tie to an old database that do not exist any more. I am using Multiple DB on one SQL instance.

Any suggestion on how I can delete those feature datasets?

Thank you,

David

Re: Feature Dataset do not delete (SDE)

JakeSkinner — Wed, 11 May 2011 11:04:45 GMT

Could you explain how these feature datasets were tied to other geodatabases? Did they participate in a replication? What is the error you receive when you try to delete the feature datasets?

Re: Feature Dataset do not delete (SDE)

DavidAlvarez — Wed, 11 May 2011 11:48:24 GMT

Hi Jake,

I inherit an SDE. Right now I am in the process of cleaning, standardizing the some feature classes and reconciling the different version.
The problem that i have is the following: If I look the data through ArcCatalog I see three feature datasets (They are empty). But if I look the data through the SQL management Studio, the database used to store those feature does not exist anymore.

We are using a one SQL instance to Multi-DB.

Thank you,

David

Re: Feature Dataset do not delete (SDE)

JakeSkinner — Wed, 11 May 2011 11:54:15 GMT

In SQL Server Management Studio, open the 'sde.GDB_ITEMS' table. Under the 'Name' column see if you see the Feature Datasets listed there. It will be in the format "<database name>.<owner name>.<Feature Dataset name>". If they exist here, they will exist when viewing the database in ArcCatalog.

Re: Feature Dataset do not delete (SDE)

DavidAlvarez — Wed, 11 May 2011 12:03:43 GMT

Hi Jake,

I see them on the table . How i can delete them completely?

Thank you,

David

Re: Feature Dataset do not delete (SDE)

JakeSkinner — Wed, 11 May 2011 12:08:30 GMT

Log onto the geodatabase as the feature dataset owner. Then right-click on the feature dataset > Delete.

Re: Feature Dataset do not delete (SDE)

DavidAlvarez — Wed, 11 May 2011 12:14:27 GMT

Jake,

If i use ArcCatalog. The delete is faded

Re: Feature Dataset do not delete (SDE)

JakeSkinner — Wed, 11 May 2011 12:42:01 GMT

This is most likely because you are not connected to the database as the feature dataset owner. Look at the feature dataset name. It will be in the following format <database name>.<owner>.<feature class name>. Ex:

Planning.Vector.Parcels

In the above example, Vector is the owner. Next, I would check to make sure I'm connected to the database as Vector by right-clicking on the database > Connection Properties. If 'Vector' is not listed under 'username' I would change this and specify 'vector' for the username and it's corresponding password.

Re: Feature Dataset do not delete (SDE)

DavidAlvarez — Wed, 11 May 2011 13:20:39 GMT

I am Log-in as the adminitrator and still can not delete them.

Example.

TroutCreek.DBO.Model

Re: Feature Dataset do not delete (SDE)

JakeSkinner — Wed, 11 May 2011 13:22:13 GMT

Try creating a new feature class called test. Does it appear as:

TroutCreek.DBO.Test

Re: Feature Dataset do not delete (SDE)

DavidAlvarez — Wed, 11 May 2011 13:42:30 GMT

I can not connect to the TroutCreek database. DB does not exist.

Re: Feature Dataset do not delete (SDE)

JakeSkinner — Wed, 11 May 2011 15:03:33 GMT

You can delete the empty feature datasets within SQL Server Management Studio. Before doing so be sure to make a database backup of your SDE geodatabase. After the backup is created you can run the following query:

use SDE
delete from sde.GDB_ITEMS where Name = 'TroutCreek.DBO.Model'

Re: Feature Dataset do not delete (SDE)

DavidAlvarez — Wed, 11 May 2011 17:38:29 GMT

Hi Jake,

Thank you, I was able to delete the feature datasets. They do not appear any more when i log-in using ArcCatalog.

When I was checking the SDE.GDB.ITEMS, I Notice that the records for the features classes that were inside the feature datasets. When I try to delete them i get the following error.

A problem occurred attempting to delete row 3.
Error Source: Microsoft.SqlServer.managemnet.Data
........ "sde.sys.geometry" is invalid

(See attach graph)

Re: Feature Dataset do not delete (SDE)

JakeSkinner — Wed, 11 May 2011 17:47:26 GMT

It appears that the feature datasets were not empty. Deleting table entries within SQL Server Management Studio is a last resort. When it comes to feature classes, there are a slew of other table entries/tables that need to be deleted as well.

Attempting to delete other table entries can seriously corrupt your database. I would recommend restoring your database backup and contacting tech support. They will be able to determine why the feature datasets are still existing even though the database has been deleted.

Also, I would recommend using a single geodatabase model in the future. I find they are much easier to maintain.

Re: Feature Dataset do not delete (SDE)

sreeharinair — Wed, 18 May 2011 15:49:19 GMT

check the following tables and if there is any entry belongs to the deleted table/layer/dataset then remove those.

select * from sde_object_locks
select * from sde_object_ids
select * from sde_table_locks
select * from sde_table_registry
select * from sde_layers
select * from sde_layer_locks
select * from sde_layer_stats
select * from sde_column_registry
select * from sde_geometry_columns
select name from GDB_ITEMS