cancel
Showing results for 
Search instead for 
Did you mean: 

What is causing “Mismatch of entities in the document” when running migrate:delta

What is causing “Mismatch of entities in the document” when running migrate:delta

I have successfully upgraded a magento 1.4.1 database to 1.4.2 and then to 1.6.0. I also successfully was able to migrate:setting and migrate:data from the 1.6.0 database over to my Magento 2.1.2 database. (Things were looking great!...)

 

I have since then been working on the 2.1.2 site; adding a new theme, changed some settings, and edited cms blocks. I did all this with the assumption that i could run a migrate:delta and bring over new customer and order data, as that is all i would really need to launch the new site. (I have not created any new orders or customers in the 2.1.2 database)

 

In my attempt to migrate:delta (after i run through the 1.4.1 -> 1.6.0 upgrade process again to get current live data) i ran into an error of missing the deltalog tables (with prefix m2cl*). I pulled those tables, which were all empty, from the first database that i migrated from. This allowed me to run a migrate:delta with the following warnings:

 

 

2017-01-25 23:32:29][INFO][mode: delta][stage: delta delivering][step: Customer Attributes Step]: started
[2017-01-25 23:32:30][INFO][mode: delta][stage: volume check][step: Customer Attributes Step]: started
100% [============================] Remaining Time: 1 sec
[2017-01-25 23:32:30][WARNING]: Mismatch of entities in the document: customer_entity
[2017-01-25 23:32:30][WARNING]: Mismatch of entities in the document: customer_address_entity
[2017-01-25 23:32:30][WARNING]: Volume Check failed
[2017-01-25 23:32:30][INFO][mode: delta][stage: delta delivering][step: Map Step]: started
[2017-01-25 23:32:30][INFO][mode: delta][stage: volume check][step: Map Step]: started
100% [============================] Remaining Time: 1 sec
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_category_entity
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_category_entity_int
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_category_entity_text
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_category_entity_varchar
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_category_product
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_compare_item
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity_datetime
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity_decimal
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity_int
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity_media_gallery
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity_media_gallery_value
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity_text
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_entity_varchar
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_option
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_option_price
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_option_title
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_option_type_price
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_option_type_title
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_option_type_value
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalog_product_website
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: cataloginventory_stock_item
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: catalogrule
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: search_query
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: cms_block
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: cms_block_store
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: salesrule_coupon_aggregated
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: customer_eav_attribute_website
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: newsletter_subscriber
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: report_compared_product_index
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: report_event
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: report_viewed_product_index
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_daily
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_monthly
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_yearly
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_invoice
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_invoice_item
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order_address
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order_item
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order_payment
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order_status_history
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: quote
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: quote_address
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: quote_address_item
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: quote_item
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: quote_item_option
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: quote_payment
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: quote_shipping_rate
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_shipment
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_shipment_item
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_shipment_track
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated_order
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order_aggregated_created
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order_tax
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_payment_transaction
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated_order
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: salesrule
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: salesrule_coupon
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: salesrule_coupon_usage
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: salesrule_customer
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: tax_calculation
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: tax_calculation_rate
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: tax_order_aggregated_created
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: wishlist
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: wishlist_item
[2017-01-25 23:32:35][WARNING]: Volume Check failed
[2017-01-25 23:32:35][INFO][mode: delta][stage: delta delivering][step: Log Step]: started
[2017-01-25 23:32:35][INFO][mode: delta][stage: volume check][step: Log Step]: started
100% [============================] Remaining Time: 1 sec
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: customer_visitor
[2017-01-25 23:32:35][WARNING]: Volume Check failed
[2017-01-25 23:32:35][INFO][mode: delta][stage: delta delivering][step: OrderGrids Step]: started
[2017-01-25 23:32:35][INFO][mode: delta][stage: volume check][step: OrderGrids Step]: started
100% [============================] Remaining Time: 1 sec
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_order_grid
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_invoice_grid
[2017-01-25 23:32:35][WARNING]: Mismatch of entities in the document: sales_shipment_grid
[2017-01-25 23:32:35][WARNING]: Volume Check failed
[2017-01-25 23:32:35][INFO][mode: delta][stage: delta delivering][step: SalesIncrement Step]: started
[2017-01-25 23:32:35][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: started
100% [============================] Remaining Time: 1 sec
[2017-01-25 23:32:35][WARNING]: Mismatch in last increment id of order entity
[2017-01-25 23:32:35][WARNING]: Mismatch in last increment id of invoice entity
[2017-01-25 23:32:35][WARNING]: Mismatch in last increment id of shipment entity
[2017-01-25 23:32:35][WARNING]: Volume Check failed
[2017-01-25 23:32:35][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: Migration completed successfully

I guess my question is a few questions:

- Is the approach i took a correct way to get data from 1.4.1 to 2.1.2
- Is there missing reference that the **migrate:delta** is looking for
since this updated database wasn't the original one I migrated from?
- and What is causing “Mismatch of entities in the document” when running migrate:delta

Thank You in advance!

 

1 REPLY

Re: What is causing “Mismatch of entities in the document” when running migrate:delta

Hi @BabySnakes,

 


It's recommended to upgrade Magento 1.x to the latest Magento 1.9 version before migrating to Magento 2.x.

 

Since you are trying to migrate from Magento 1.6.0 to Magento 2.x, then you might experience issues like the one you described.


I recommend you to update your Magento 1 instance to the latest Magento 1.9.x version, and then proceed with the Magento 2 migration.



Best regards.
Gabriel

If my answer was useful, please give "Kudos" to this post.
If my answer helps you to resolve the problem, click on "Accept as Solution".