Preconditions
- Migrating from Magento 1.9.3.10
- Migrating to Magento 2.3.5-p1 using Data Migration Tool
Steps to reproduce
- Run Settings migration as usual
- Run Data migration as usual
Expected result
- Migration with no errors or integrity step failing with details
Actual result
Integrity constraint violation: 1062 Duplicate entry 'XX-XXX' for key 'EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID'
Additional notes
I have 44 attribute sets in my M1 database. This error only comes up with 2 of those (Attribute set IDs 9 and 12).
I've already checked my M1 & M2 databases and there are no duplicated entries as the error says. Also, this was recognized as a bug on a previous version of Data Migration Tool.
The suggested solution was comment/remove remove a method at Migration/Step/Eav/Data.php
and add the attributes manually to the sets.
Is there a official / tested fix for this or somebody knows what it means? (Again, there are no duplicated entries)
Note: Here is a list with some of the attribute_set_id
/ attribute_id
combination which fails.
Integrity constraint violation: 1062 Duplicate entry '9-110' for key 'EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID'
Integrity constraint violation: 1062 Duplicate entry '9-503' for key 'EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID'
Integrity constraint violation: 1062 Duplicate entry '9-863' for key 'EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID'
Integrity constraint violation: 1062 Duplicate entry '12-111' for key 'EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID'
(The same happen to almost all attributes assigned to attribute sets 9 and 12).