Back to Questions Page

TaxOrderAggregatedCreated: duplicate entry

0 Comment December 29, 2016
Vote Up
0
Vote Down
Answered
Public
Technical Question
Profile photo of herve herve asked December 29, 2016

Hi,
 
Migration is failing at step #8:
 

Processing in step #8.....................................................(Continued) migrated data in step #8 ok with 50 TaxOrderAggregatedCreated items.
Processing in step #8...
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2011-07-18-0-Livraison France-19.6-complete' for key 'TAX_ORDER_AGGRED_UPDATED_PERIOD_STORE_ID_CODE_PERCENT_ORDER_STS'. The SQL statement executed was: INSERT INTO `tax_order_aggregated_updated` (`orders_count`, `period`, `store_id`, `code`, `order_status`, `percent`, `tax_base_amount_sum`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6)

I have checked the tax_order_aggregated_created table and all lines (9150) have been copied.
 
Any idea where this could come from?
 
Thanks!
M

3 answers

Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone December 30, 2016
Public

Hi herve
I can’t clone the issue as you said in my local.
That issue maybe come from some bad data in ‘tax_order_aggregated_updated’ table in your Magento1 database.
Let’s provide me the admin and SSH credentials of your Magento2 i will check further and help you out.
Regards,
Mall.

#3

Please login or Register to Submit Answer

Written By

Further Reading

Comments