Error with migration

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

Profile photo of ubdev Staff 65720.00 $tone July 9, 2020
Public

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

#2
Profile photo of Corvan IT 160.00 $tone July 13, 2020
Public

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…

#3
Profile photo of ubdev Staff 65720.00 $tone July 13, 2020
Public

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

#4
Profile photo of ubdev Staff 65720.00 $tone July 13, 2020
Public

Hi there, 
We’ve just replied to you via another ticket here, please check and follow up with us there.
Regards,
Ubertheme team

#6

Please login or Register to Submit Answer

Written By

Comments