Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Mismatch of entities in the document and Volume Check Failed - Migrate:Delta #487

Closed
frilogg opened this issue Apr 1, 2018 · 2 comments
Closed

Mismatch of entities in the document and Volume Check Failed - Migrate:Delta #487

frilogg opened this issue Apr 1, 2018 · 2 comments
Labels
acknowledged bug

Comments

@frilogg
Copy link

frilogg commented Apr 1, 2018

Two weeks ago I ran ordinary migrate without any problems, when running migrate in delta mode today between magento 1.9.3.8 and latest magento 2 I get a whole bunch of warnings. And the process seems to restart and restart and restarts and newer ever complete at all! Please advice!

[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: captcha_log Source: 0 Destination: 1
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_category_entity Source: 132 Destination: 125
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_category_entity_decimal Source: 111 Destination: 104
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_category_entity_int Source: 717 Destination: 682
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_category_entity_varchar Source: 1079 Destination: 1044
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_category_product Source: 1441 Destination: 1358
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_category_product_index Source: 3967 Destination: 3687
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity Source: 1439 Destination: 1361
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity_datetime Source: 5390 Destination: 5309
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity_decimal Source: 4706 Destination: 4480
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity_int Source: 7979 Destination: 7509
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity_media_gallery Source: 1989 Destination: 1886
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity_media_gallery_value Source: 1955 Destination: 1852
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity_text Source: 8709 Destination: 8683
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_entity_varchar Source: 22125 Destination: 20835
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: catalog_product_website Source: 1439 Destination: 1361
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: salesrule_coupon_aggregated_updated Source: 30 Destination: 26
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: customer_form_attribute Source: 113 Destination: 111
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: design_change Source: 1 Destination: 0
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: eav_attribute_option Source: 145 Destination: 142
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: eav_attribute_option_value Source: 252 Destination: 249
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: mailchimp_webhook_request Source: 1629288 Destination: 1629741
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: oauth_consumer Source: 0 Destination: 3
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: persistent_session Source: 835 Destination: 820
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: report_viewed_product_aggregated_daily Source: 0 Destination: 4878
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: report_viewed_product_aggregated_monthly Source: 0 Destination: 2522
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: report_viewed_product_aggregated_yearly Source: 0 Destination: 1614
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_daily Source: 8416 Destination: 29779
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_monthly Source: 4706 Destination: 15645
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_yearly Source: 2152 Destination: 6837
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_shipment_comment Source: 2994 Destination: 2983
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated Source: 2038 Destination: 2030
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated_order Source: 2034 Destination: 2026
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_order_aggregated_created Source: 3022 Destination: 3000
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_order_aggregated_updated Source: 1595 Destination: 1575
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_payment_transaction Source: 2550 Destination: 2528
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_refunded_aggregated Source: 96 Destination: 92
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_refunded_aggregated_order Source: 94 Destination: 92
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated Source: 4466 Destination: 4474
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated_order Source: 4622 Destination: 4620
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: tax_order_aggregated_created Source: 3014 Destination: 2988
[2018-04-01 23:12:53][WARNING]: Mismatch of entities in the document: tax_order_aggregated_updated Source: 1593 Destination: 1571
[2018-04-01 23:12:53][WARNING]: Volume Check failed
@victor-v-rad
Copy link
Collaborator

victor-v-rad commented Apr 2, 2018 •
edited
Loading

Hi @frilogg

Most likely someone created several products in Magento 1 after main migration of data. Delta mode can migrate new users and orders but not new products. See the documentation about restrictions during migration. You can create missing the products in Magento 2 manually.
Also I see that tables sales_payment_transaction and sales_shipment_comment are not begin migrated but should.
I have created two issues MAGETWO-89898 and MAGETWO-89900 to fix it

@victor-v-rad
Copy link
Collaborator

@frilogg

I am trying to find out why you got WARNINGS about product tables like
catalog_category_entity
catalog_category_entity_int
catalog_category_entity_decimal
on delta mode. If I add there tables into deltalog.xml file to track and create a new product in Magento 1 then new records from these tables in delta mode transfers without any problems

victor-v-rad added a commit to magento-panda/data-migration-tool that referenced this issue Apr 4, 2018
@victor-v-rad
MAGETWO-89898: [GigHub] Several important tables are missing in delta…
02d5811 
…log.xml.dist file magento#487
@victor-v-rad victor-v-rad mentioned this issue Apr 20, 2018
Merged
1 task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
acknowledged bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@victor-v-rad @frilogg