Error in step5

Hi,
     Im running the Ub data migration lite in magento2.0.7 but in step 5 it gives below error. How to  rectify this
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ’53’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `mag_catalog_product_entity` (`attribute_set_id`, `type_id`, `has_options`, `required_options`, `entity_id`, `sku`, `created_at`, `updated_at`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7)

4 answers

Profile photo of ubdev Staff 98030.00 $tone January 24, 2019
Public

Hi Vishal, 
It seems your M2 instance has sample data before you proceed migration which caused the issue you mentioned. 
Since our Lite version uses an outdated codebase which has not been maintained for a long time due to our limited resource, please consider moving forward with our Pro version. It will save you pretty much time. 
You can check out a few case studies below to learn more about our Pro version: 

-- Migrating 15,000+ Sales Orders to Magento 2 Using UB Data Migration Pro
-- We did use the Pro version ourself to help Winetasting.com – Migrate 382,047 customer entities to Magento 2
-- And this case study as well -- Freelaunch.nl used UB Data Migration Pro to migrate 230,000 products to Magento 2
-- Case StudySuccessful Magento 2 Data Migration for Kwaaijongens.nl

 
Regards,
Ubertheme team

#1
Profile photo of ubdev Staff 98030.00 $tone January 24, 2019
Public

Hi Vishal, 
We’re biased when referring you to our Pro version. However, due to the outdated codebase of the Lite version as explained, it might lead to various unexpected issues during the migration. So, it mainly helps you have a close look into how the migration process work only. 
Thanks for your understanding. 
Regards,
Ubertheme team

#4

Please login or Register to Submit Answer

Written By

Comments