"Duplicate key" errors when running Commerce product synchronization


Description

The following error may occur in the log files when product synchronization is performed in Sitecore Experience Commerce:

ERROR System.Exception: Violation of PRIMARY KEY constraint 'Descendants_PK'. Cannot insert duplicate key in object 'dbo.Descendants'. The duplicate key value is (03a2546b-7d72-438e-97a3-53015e9145ca, 3ec3d14c-4c18-c057-89d8-526d62774084).

Solution

The fix is considered for inclusion in the future update.