Duplicated online products created from product catalog sync (Stage->Online)

[Former Member]

After product catalog synchronization (Stage->Online), duplicate product code is created in online catalog. From the log, it logs out errors from AbstractItemCopyContext for below 4 source item PKs.

8818939723777, 8818955321345, 8819005882369, 8819197739009

 2016/01/13 16:55:00.577 | INFO  [00009Z49::de.hybris.platform.catalog.jalo.synchronization.CatalogVersionSyncJob] [10.10.112.70] (00009Z49) [CatalogVersionSyncJob] Sync  'product_catalog_US Staged -> Online' (pk:8798091903476) configured 96167 entries for job '00009Z49' (pk:8811343839733) schedule medias: 1
 
 2016/01/13 16:56:56.905 | ERROR [SyncWorker<00009Z49 1 of 2>] [10.10.112.70] (00009Z49) [AbstractItemCopyContext] found ambigous sync timestamps for 8818939723777 and job product_catalog_US Staged -> Online : expected target 8819692404737 but found [8819692371969]
 
 2016/01/13 16:57:14.961 | ERROR [SyncWorker<00009Z49 1 of 2>] [10.10.112.70] (00009Z49) [AbstractItemCopyContext] found ambigous sync timestamps for 8818955321345 and job product_catalog_US Staged -> Online : expected target 8819702169601 but found [8819701841921]
 
 2016/01/13 16:57:46.685 | ERROR [SyncWorker<00009Z49 2 of 2>] [10.10.112.70] (00009Z49) [AbstractItemCopyContext] found ambigous sync timestamps for 8819005882369 and job product_catalog_US Staged -> Online : expected target 8819720355841 but found [8819719897089]
 
 2016/01/13 16:58:58.910 | ERROR [SyncWorker<00009Z49 1 of 2>] [10.10.112.70] (00009Z49) [AbstractItemCopyContext] found ambigous sync timestamps for 8819197739009 and job product_catalog_US Staged -> Online : expected target 8819758170113 but found [8819758137345]

When I search those 4 source item PKs from ItemSyncTimestamp type, I do see that each source item has two target items as shown below. (red box means one source item pk, but they all have two (A), (B) target items each).

When I check duplicate identification from hmc, I see exact same products showing up as duplicated as below.

I've manually deleted those duplicated products but catalog sync keeps creating duplicated items over and over. We have not seen this behavior from hybris 4.6. But since recent hybris upgrade to 5.5, we keeps running into this issue. Does anyone know how to fix this issue?

Thanks, Yong

[Former Member · Accepted solution]

I had the same issue with duplicate CMS Items. You would have to remove the duplicate products from the database and create unique indexes on the database. Please read here what you have to do: http://ecommercecandles.com/en/hybris-ecommerce-platform-main/21-cms-cockpit/59-common-reasons-of-sy...

I still don't know why the sync process creates duplicates items.

[Former Member · Accepted solution]

Thanks for your solution, io. Yeah, I've also thought about database unique index for the product table (which will throw oracle exception when hybris keeps creating duplicate row against the index) but I wanted to see if anyone has a solution for the root cause of this issue. If no one has any other solution. I'll select your answer.

Thanks!