topic Re: load data error; conflict with the CHECK constraint in Data Management Questions

load data error; conflict with the CHECK constraint

deleted-user-AzQ5lcTQbS2a — Thu, 31 Jul 2014 21:58:44 GMT

Received this error when trying to load data from one FC in a source database to the Local govt information model:

Underlying DBMS error [[Microsoft][SQL Server Native Client 10.0][SQL Server]The INSERT statement conflicted with the CHECK constraint "g65_ck". The conflict occurred in database "lenexaGIS", table "dbo.LOCALDISTRICT", column 'SHAPE'.

I received this error first trying to use the Data Interop tool to load the data, turned to the ArcCatalog Load option during troubleshooting.

SOLUTION:

I ran both an Analyze and Recalculated the spatial index and the load ended up working. I'm leaning more towards the spatial index solution since 1) the error called out the SHAPE field and the name of the spatil index is S65_idx (reference to the g65_ck in the error) which explains why googling "g65_ck" didn't work.

-sp

Re: load data error; conflict with the CHECK constraint

ChrisRobinson — Wed, 22 Jul 2015 22:06:20 GMT

Thank you Stacey, I ran into this same issue and running an analyze and/or recalculating the spatial index worked for me.

Chris

Re: load data error; conflict with the CHECK constraint

Muhammad_Abdul_HadiMuhammad_A1 — Sun, 11 Jun 2017 09:37:23 GMT

This helped me too. v.10.2.2

Re: load data error; conflict with the CHECK constraint

AzinSharaf — Tue, 25 Jul 2017 23:46:50 GMT

I got same error when adding SDE raster dataset into SDE Mosaic Dataset. Deleting and creating MD again fixed the issue.