SDE_GEOMETRYnnnn Table Already Exists

JoseSanchez — Mon, 19 Mar 2018 18:30:29 GMT

Hello everyone,

We are getting an error message when we copy a feature dataset into a SDE SQL Server 2014 geodatabase:

"Failed To Paste ...."

Table Already Exists for SQL.

There is already an object named .SDE-GEOMETRYnnnn in the database"

thanks

Re: SDE_GEOMETRYnnnn Table Already Exists

TinaMorgan1 — Tue, 20 Mar 2018 20:55:30 GMT

Those SDE_GEOMETRYnn tables are created when you create feature classes using GEOMETRY storage. Its a method to store CAD style data.

Where are you pasting this data from? Does it contain data, and if so does that data have CAD like data (true curves)?

As a temporary workaround, and test, can you create a new blank feature class in your SQL Server database, in the feature class creation import the spatial reference and fields from the source data. When the feature is created, can you then load the data using simple data loader?

Workflow:

Connect to SQL Server in ArcCatalog.

Create new feature class-> import spatial reference and fields from source data. Create the feature class using GEOMETRY spatial storage.

Right click the new feature class-> Load-> load data. Import the data from the source feature class.

topic Re: SDE_GEOMETRYnnnn Table Already Exists in Geodatabase Questions

SDE_GEOMETRYnnnn Table Already Exists

Re: SDE_GEOMETRYnnnn Table Already Exists