"Duplicate key in shape column error" is produced during Upgrade if archiving has been enabled on any feature class or table.
The upgrade routine creates an invalid trigger on the archive table of each dataset on which archiving has been enabled. This causes the 'Duplicate key in shape column' error during upgrade.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM010290
Submitted
July 11, 2007
Last Modified
April 2, 2025
Applies to
No Product Found
Version found
9.2
Version Fixed
9.3
Status
Fixed
The bug has been fixed. See the Version Fixed and Additional Information, if applicable, for more information.
Workaround
Drop the trigger that raises the "Duplicate key in shape column." The name is sp_col_ins_<layer_id>.