Background documentation-1452: Duplicate secondary key Locate this document in the navigation structure

 

Explanation

Several table rows already exist with the same values in the specified columns when a UNIQUE definition is specified, when the column attribute UNIQUE is used or when a UNIQUE definition is specified in the CREATE INDEX statement.

User Response

Do not use UNIQUE; or make sure that only one table row contains a certain combination of values in the specified columns. The error message specifies the column or multiple-column index already containing the specified values.