<\/HEAD>
When performing operations on a feature class in a corporate geodatabase, the following error is displayed:<\/P>
<\/P>
Underlying DBMS error [[Microsoft][SQL Server Native Client 1x.x][SQL Server]The INSERT statement conflicted with the CHECK constraint "g65_ck". The conflict occurred in database "GBDX", table "dbo.B", column 'SHAPE'.<\/P>
<\/P>
Solution: Rebuild spatial indexes.<\/P>
<\/P>
To rebuild or recreate a spatial index on a feature class from the <\/SPAN>Feature Class Properties<\/SPAN> dialog box, do the following:<\/P>Start <\/SPAN>ArcMap<\/SPAN> <\/SPAN>and open the <\/SPAN>Catalog<\/SPAN> <\/SPAN>window or start <\/SPAN>ArcCatalog<\/SPAN>.<\/LI>In the catalog tree, connect to the geodatabase or database that contains the feature class for which you want to modify the spatial index.For corporate geodatabases or databases, connect as the data owner to rebuild indexes.<\/P><\/LI>Right-click the feature class and then click <\/SPAN>Properties<\/SPAN>.<\/LI>Click the <\/SPAN>Indexes<\/SPAN> tab.<\/LI>How you modify the spatial index for the feature class depends on the type of spatial data contained in the feature class.For feature classes that use geometry storage in <\/SPAN>SQL Server<\/SPAN>, click <\/SPAN>Recalculate<\/SPAN> <\/SPAN>to allow ArcGIS to set the grid size.<\/LI>For feature classes that use ST_Geometry in <\/SPAN>Oracle<\/SPAN>, click <\/SPAN>Rebuild<\/SPAN>.<\/LI>Click <\/SPAN>Delete<\/SPAN> <\/SPAN>to delete the spatial index and then click <\/SPAN>Create<\/SPAN> <\/SPAN>to create a new one for feature classes in any of the following locations:File geodatabases<\/LI>PostgreSQL<\/SPAN><\/LI>Db2<\/SPAN><\/LI>Informix<\/SPAN><\/LI>Netezza<\/SPAN><\/LI>Teradata<\/SPAN><\/LI>SQLite<\/SPAN><\/LI>Azure SQL Database<\/SPAN><\/LI>Feature classes that use geography or binary storage in <\/SPAN>SQL Server<\/SPAN><\/LI>Feature classes that use binary storage or SDO_Geometry in <\/SPAN>Oracle<\/SPAN><\/LI><\/UL>The index you rebuilt reflects current data.<\/LI><\/UL><\/LI><\/OL><\/BODY><\/HTML>
