Delta migration error on step 7

Hello There,
 
I am receiving the following error on step 7. Can you please assist me with which command to run to correct it?
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1615’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_order_tax` (`tax_id`, `order_id`, `code`, `title`, `percent`, `amount`, `priority`, `position`, `base_amount`, `process`, `base_real_amount`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10)
 
Thank you

3 answers

Profile photo of Mall Staff 136830.00 $tone May 20, 2020
Public

Hi there,

1062 Duplicate entry ‘1615’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_order_tax` (`tax_id`, `order_id`, `code`, `title`, `percent`, `amount`, `priority`, `position`, `base_amount`, `process`, `base_real_amount`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10)

You can try with these steps:

+ Run the following SQL query in your M2 database:

Delete From sales_order_tax Where tax_id = 1615;

+ Once done, you continue with the data migration in step #7 by running the CLI command:
php -f bin/ubdatamigration run --step=7;

Regards,
Mall.
 
 

#1
Profile photo of biitsllc123 220.00 $tone May 20, 2020
Public

Thanks for that it worked and went through a ways and now gives this error.
 
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 1366 Incorrect decimal value: ” for column ’embroidery_price’ at row 1. The SQL statement executed was: INSERT INTO `quote_item` (`quote_id`, `no_discount`, `weight`, `qty`, `price`, `base_price`, `discount_percent`, `discount_amount`, `base_discount_amount`, `tax_percent`, `tax_amount`, `base_tax_amount`, `row_total`, `base_row_total`, `row_total_with_discount`, `row_weight`, `free_shipping`, `item_id`, `created_at`, `updated_at`, `product_id`, `store_id`, `is_virtual`, `sku`, `name`, `is_qty_decimal`, `embroidery_price`, `product_type`, `original_custom_price`, `price_incl_tax`, `base_price_incl_tax`, `row_total_incl_tax`, `base_row_total_incl_tax`, `discount_tax_compensation_amount`, `base_discount_tax_compensation_amount`, `weee_tax_applied`, `weee_tax_applied_amount`, `weee_tax_applied_row_amount`, `weee_tax_disposition`, `weee_tax_row_disposition`, `base_weee_tax_applied_amount`, `base_weee_tax_disposition`, `base_weee_tax_row_disposition`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36, :yp37, :yp38, :yp39, :yp40, :yp41, :yp42)
ubuntu@ip-172-31-17-186:/var/www/magento$ Status: fail

#2
Profile photo of Mall Staff 136830.00 $tone May 20, 2020
Public

Hi there,

1366 Incorrect decimal value: ” for column ’embroidery_price’ at row 1. The SQL statement executed was: INSERT INTO `quote_item` (`quote_id`, `no_discount`, `weight`, `qty`, `price`,

That issue related to a custom field named ‘embroidery_price‘. It seems that it was added manually by your developer or added by a third-party extension which you are using in your M2 site.

Please check the settings of that custom field in the ‘quote‘ table in your M2 database. Please make sure that all the settings are correct and you have to set a default value for that field.
 
Once done, you can continue with the data migration in step #7.
 
Regards,
Mall.

#3

Please login or Register to Submit Answer

Written By

Comments