SAP Knowledge Base Article - Preview

3381704 - Error on Ambiguous Unique Keys for Catalog Synchronization when there is a Target Counterpart - SAP Commerce


When attempting to synchronize, either manually or through a full sync, an error occurs and the following exception is found in the logs:

An exception occurred during synchronization for item: <PK of Item> of type:<ItemType>","name":"de.hybris.platform.jalo.JaloSystemException","cause":"de.hybris.platform.servicelayer.exceptions.ModelSavingException: [de.hybris.platform.servicelayer.interceptor.impl.UniqueAttributesInterceptor]:ambiguous unique keys {catalogVersion=CatalogVersionModel (<Catalog Version PK>), <Item Attribute key> = <Item Attribute key>} for model <TypeModel> (<unsaved>) - found * item(s) using the same keys"

The ambiguous item, whether checked on SyncDump, is under the Creation dump of Scheduled Items, but since it has a counterpart on target catalog, it should've be under Update (when a linking itemsynctimestamp exists) or Connect (when a linking itemsynctimestamp doesn't exist):

#Schedules for root type '<Type Code>'
#file: '<PK of Job>_<Type Code>_remove_4061061814756435203.csv'
#file: '<PK of Job>_<Type Code>_create_13500522471482506744.csv'
<PK of Source Item>;;;;                                                                      <----- It's listed here
#file: '<PK of Job>_<Type Code>_update_2478853404756408016.csv'
<PK of Source Item>;<PK of Target Item>;<PK of Timestamp>;;          <----- But should've been listed here
#file: '<PK of Job>_<Type Code>_connect_9650654000305839789.csv'
<PK of Source Item>;<PK of Target Item>;;;                                       <----- Or here

Also, on the Job Configuration (Multithreaded Synchronization), there's an ad-hoc user with restrictions (Personalization Rules), like the following:



"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."



  • SAP Commerce
  • SAP Commerce Cloud


SAP Commerce Cloud all versions ; SAP Commerce all versions


Commerce, ccv2, full, sync, catalog, duplicated, identifier , KBA , CEC-SCC-PLA-PL , Platform , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.