topic Synchronize Replica Failed - Cannot Insert Duplicate Key Row in Object in Geodatabase Questions

Synchronize Replica Failed - Cannot Insert Duplicate Key Row in Object

LeviRoberts — Tue, 26 Sep 2017 20:26:46 GMT

I recently started getting the following error:

I've made no changes to my data that I can think of and I can't find any reference online to this error. Anyone have some resources to point me towards?

Re: Synchronize Replica Failed - Cannot Insert Duplicate Key Row in Object

GIS_Solutions — Fri, 12 Apr 2019 07:06:12 GMT

i have a smilar problem, How was did you solved this problem?

Re: Synchronize Replica Failed - Cannot Insert Duplicate Key Row in Object

BirajaNayak — Wed, 17 Apr 2019 21:28:09 GMT

Hi Levi,

We have seen this error before with spatial index corruption.

Try following workflow:

1. In SQL Server Management Studio, run the below query as "dbo" or "sa" user to find the Object_id of the problematic feature class.

select * from sys.indexes where name = ‘S4717_idx’;

2. Then use object_id to identify the feature class:

select * from sys.objects where OBJECT_ID= 'xxxxx';

3. Rebuild the spatial index for that feature class.

Thanks,

Biraja