step6 error CDbCommand failed to execute the SQL

$ php70 -f bin/ubdatamigration run --step=6
Processing in step #6……..
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_address_entity` (`is_active`, `entity_id`, `parent_id`, `created_at`, `updated_at`, `country_id`, `firstname`, `lastname`, `street`, `telephone`, `city`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10)

1 answer

Profile photo of Mall Staff 184060.00 $tone March 26, 2019
Public

Hi there,

Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_address_entity` (`is_active`, `entity_id`, `parent_id`, `created_at`, 

That because your database has existing data before migrate with our tool and you have checked to ‘KEEP ORIGINAL IDs’ in settings in the step #6.
Note: You couldn’t keep original ids of data objects in the step #6 if you have existing data in current M2 instance.
Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Comments