Unable to copy-paste a particular feature class in ArcSDE for SQL Server database with ‘GEOGRAPHY’ keyword.
Last Published: August 25, 2014ArcSDE/Enterprise Geodatabase
Bug ID Number
NIM080819
Submitted
May 15, 2012
Last Modified
April 2, 2025
Applies to
ArcSDE/Enterprise Geodatabase
Version found
10.0
Status
Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
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.