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
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 Study: Successful Magento 2 Data Migration for Kwaaijongens.nl
Regards,
Ubertheme team
Hi,
There was no magento2 sample data . its was fresh magento2 installed and then i ran the tool. But it gave me error
can u reply?
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
