Step7 Integrity constraint violation

Running a delta step 7, I get an error:
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘149867’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_shipment` (`entity_id`, `store_id`, `total_qty`, `order_id`, `customer_id`, `shipping_address_id`, `billing_address_id`, `increment_id`, `created_at`, `updated_at`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9)

1 answer

Profile photo of Mall Staff 184060.00 $tone April 19, 2019

Hi there,

It seems that you checked the ‘KEEP ORIGINAL IDs’ setting in Step #7 of our tool, then you created additional sales data after the first migration. 

To continue, you need to delete the newly added sales shipment data by running the below SQL in your M2 database:

Delete From sales_shipment Where entity_id = 149867;

+ Once done, you could continue with the delta migration in the step #7



Please login or Register to Submit Answer

Written By