laptop and a wrench

Bug

Unable to copy-paste a particular feature class in ArcSDE for SQL Server database with ‘GEOGRAPHY’ keyword.

Last Published: August 25, 2014 ArcSDE/Enterprise Geodatabase
Bug ID Number NIM080819
SubmittedMay 15, 2012
Last ModifiedApril 2, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.0
StatusKnown Limit

Additional Information

Microsoft limit.

Workaround

1. Load the bad layer into a GEOMETRY feature class (Named PFGeom bellow).2. Update the Geometry of the bad shape using the Reduce method. This is similar to a Generalize operation.update PFGeom set shape = geometry::STGeomFromWKB(shape.Reduce(0.00001).STAsBinary(), shape.STSrid) where objectid = ######## would be the objectid of the bad shape (or whatever where clause is going to get you just the single bad shape that is failing)This performs a tiny reduction in the number of vertices.3. Using ArcCatalog, copy/paste the PFGeom feature class into the new Geography feature class.

Steps to Reproduce

Bug ID: NIM080819

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options