Hi,
Delta Migration is not working for “Customers” and throwing the following error:
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2926’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_entity` (`group_id`, `store_id`, `is_active`, `disable_auto_group_change`, `failures_num`, `entity_id`, `website_id`, `email`, `created_at`, `updated_at`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9)
How to resolve it?
I look forward to your prompt support
1 answer
Hi there,
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘2926’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_entity` (`group_id`, `store_id`, `is_active`, `disable_auto_group_change`,
That issue occurs because you had checked the ‘KEEP ORIGINAL IDs’ checkbox in step #6 of our migration tool. Then your M2 instance has some newly added customers after the first migration.
Under this circumstance, you can consider one of the following options:
- If your M2 instance remains to be a staging instance, please consider removing the newly added customers. Then you can continue delta process as normal.
- Or you reset Step 6, then uncheck the option ‘Keep Original IDs’ and re-migrate this step again.
Regards,
Mall.