Hello, we are migrating Magento 1.9.0.1 to 2.3.5 with data-migration-tool and we have this error:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘9-product-details’ for key ‘EAV_ATTRIBUTE_GROUP_ATTRIBUTE_
SET_ID_ATTRIBUTE_GROUP_CODE’
Seems a bug described here: https://github.com/magento/data-migration-tool/issues/201#issuecomment-361440309
With your pro tool…. Can we avoid this bug? It´s pro tool affected?
Thank you.
6 answers
Hi Corvant,
There’s a high chance that the issue will remain when using our UB Data Migration Pro module. However, we will suggest you a workaround to solve that issue then.
For your information, that issue occurred because your M1 database had a special case on the attribute group names of the attribute set ID = 9. There were at least two attribute groups that had the ‘general’ string in the attribute group’s name of this attribute set.
Regards,
Ubertheme team
Hello, we have this error in step 3:
“CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘741-96’ for key ‘EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID'”
We used your solution, change $attributeGroupCode2 in PHP file at pub/ub-tool/protected/controllers/Step3Controller.php
But don´t change anything…
Hi there,
We used your solution, change $attributeGroupCode2 in PHP file at pub/ub-tool/protected/controllers/Step3Controller.php
We wonder which solution you referred to. It seems you followed from another ticket?
Anyway, could you please re-install our Pro module on a fresh Magento 2 instance? We know this takes you extra time, yet it would be best to ensure data integrity as well as avoid unexpected issue associated with your old instance.
Sincerely,
Ubertheme team
Hello, we deleted all duplicated entries in mysql and now works perfect, thank you.
