Skip to Content
author's profile photo Former Member
Former Member

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

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).

alt text

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2016 at 08:38 AM

    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-synchronisation-failures

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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.