0

I am migrating the data from Magento 1 to magento 2.4.1 by running the following command

php bin/magento migrate:data --reset vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.0.1/config.xml

But it throws the following error and stopped migration

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '137-24' for key 'CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_VAL_ID_ENTT_ID'

please refer to the attachment

enter image description here

Improve this question
1
  • Hey, backup the database, but I think you can truncate that table with no problem should be catalog_product_entity_media_gallery_value_to_entity or something similar, when I did the migration I truncated that table
    – Rui Silva
    Dec 23, 2020 at 10:12

1 Answer 1

Reset to default
0

Solution:

Add the catalog_product_entity_media_gallery_value table inside the ignore document section of both source and destination in map.xml, and then proceed migration it works like charm

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.