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