3763656 - Identifying Out-of-Sync PK Generators Causing Duplicate Primary Key Violations

One or more operations fail with a duplicate primary key(PK) exception similar to the following:

org.springframework.dao.DuplicateKeyException:
Violation of PRIMARY KEY constraint ...
Cannot insert duplicate key in object '<table_name>'.
The duplicate key value is (<PK_VALUE>)

Examples include failures when creating or updating items such as:

• Media
• Address
• Product
• CronJob
• Customer
• Other SAP Commerce item types

Typical log entries may look similar to:

Cannot insert duplicate key in object 'dbo.medias'.
The duplicate key value is (<PK_VALUE>).

or

Cannot insert duplicate key in object 'dbo.addresses'.
The duplicate key value is (<PK_VALUE>).

DuplicateKeyException, Violation of PRIMARY KEY constraint, Cannot insert duplicate key, PKGenerator , KBA , CEC-SCC-PLA-PL , Platform , Problem