12

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 the title question.
0

In your approach after successfull setup of magento 2 website, i mean migration of data on development and setup of complete theme and website is done. You need to migrate the fresh data from magento 1 again and you can use the same codebase and your magento 2 store with new data will be up. Please try to follow this approach.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.