Monday, March 7, 2011

ArcSDE error: Cannot insert duplicate key row in object

I am at my wits' end on this error message.

-I am trying to update a ‘NAME’ field in ‘CONTENT_POINTS’ SDE Feature Class

-I’ve used Attribute Creator to create a fme_db_operation = UPDATE

-Update Key Fields in Feature Type Properties>Parameters is set to NAME

-ArcSDE Mode Of Operation is UPDATE


Error while executing stream update operation for table 'PROFILING.CONTENT_POINTS'.:SDE_ERROR_CODE(-51) Underlying DBMS error. SDE_EXT_ERROR(2601) SDE_ERROR_MSG1(Microsoft SQL Native Client: Cannot insert duplicate key row in object 'PROFILING.CONTENT_POINTS' with unique index 'CID'.) SDE_EXT_ERROR_MSG2()

If I understand this correctly it is saying that I am trying to insert a duplicate key row in the CONTENT_POINTS featureclass.

‘CID’ is the unique ID

I am trying to update, not insert, and so of course there will be the same ‘CID’ because that is the unique ID I am using to update the NAME field with the new NAME form the source file.

I have tried what feels like a million different things to do what should be simple, something I have done many times before.

Any suggestions or help would be greatly appreciated.