Error on Delta migration Step 5

Hello
I have this error 
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’

Please advice 
Thanks 

4 answers

Profile photo of Mall Staff 142250.00 $tone June 1, 2020
Public

Hi there,

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’

Please provide me more details information about that error message, I will help to check further and get back you then.
Regards,
Mall.

#1
Profile photo of Harry Zampetoulas 560.00 $tone June 1, 2020
Public

Hi Mall
This error come by running delta from the Magento admin (there is not other info)
Now i run again step 5 from the cli (php7.3 -f bin/ubdatamigration run --step=5 --mode=update;) but is going very slow, I will waiting if an error come up and i come back to you
thanks
 

#2
Profile photo of Harry Zampetoulas 560.00 $tone June 1, 2020
Public

Hi Mall
This is what i get:
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_link_attribute_int` (`value`, `value_id`, `product_link_attribute_id`, `link_id`) VALUES (:yp0, :yp1, :yp2, :yp3)

#3
Profile photo of Mall Staff 142250.00 $tone June 2, 2020
Public

Hi there,

Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘11874’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_link_attribute_int` (`value`, `value_id`,

That issue occurred because you checked the ‘KEEP ORIGINAL IDs’ settings in step #5 of our module while you had newly added products in M2 after the first migration. 

Please run the following SQL query in your M2 database to delete the duplicated record ID (11874) in the error message that you saw:

Delete From catalog_product_link_attribute_int Where value_id = 11874;

+ Once done, you continue with the data migration in step #5 using this command:
php7.3 -f bin/ubdatamigration run --step=5 --mode=update

Regards,
Mall.

#4

Please login or Register to Submit Answer

Written By

Comments