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:

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.

Thanks

3 comments:

  1. Are there any dependencies to the table you are trying to update?

    ReplyDelete
  2. Yes there are a number of relationship classes with the CID as the key field. But the only field I'm trying to update is NAME, and this is not a key field in any relationship class.
    Thanks!

    ReplyDelete
  3. Did you ever get this sorted out? The SDE error code -51 suggests a problem connecting to the database, either login or network error

    SE_DB_IO_ERROR (-51)

    A database-level I/O error occurred. You can call the extended error code immediately after this code is returned to inquire about the specific database error code. You should also check the DBMS log files for information.

    ReplyDelete