cancel
Showing results for 
Search instead for 
Did you mean: 

Magento 1.9.3.8 to 2.3.3: issues with mismatch fo entities in the document

Magento 1.9.3.8 to 2.3.3: issues with mismatch fo entities in the document

Hello everyone,

 

I have some issues with my delta step and I don't know why... I have followed all the steps before de migration and the first time everything was OK.

 

We still use the site on Magento 1 so we have a task on our server that run the delta steps to keep changes.

 

I'm wondering if there is a way to fix all the mismatch of entities (I have fixed some with custom SQL scripts to push missing IDs on the m2_cl_* tables) ? Some tables are not in the deltalog.xml file and they don't have m2_cl_* tables... How is it possible?

 

Thanks!

santerref.

 

[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: Customer Attributes Step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Customer Attributes Step]: started

[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: Map Step]: started
....
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Map Step]: started

[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: catalog_category_product_index Source: 70108 Destination: 72614
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: catalog_product_entity_media_gallery_value Source: 37575 Destination: 37585
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: catalogrule_customer_group Source: 81 Destination: 80
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: catalogrule_product Source: 53509 Destination: 52824
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: catalogrule_product_price Source: 159711 Destination: 63686
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: cms_page Source: 24 Destination: 25
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: cms_page_store Source: 24 Destination: 25
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: email_template Source: 6 Destination: 11
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_coupon_aggregated Source: 2253 Destination: 2055
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_coupon_aggregated_updated Source: 1780 Destination: 1642
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: customer_eav_attribute_website Source: 1 Destination: 16
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: eav_attribute_option Source: 1006 Destination: 6426
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: eav_attribute_option_value Source: 1634 Destination: 7053
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: oauth_consumer Source: 2 Destination: 4
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: oauth_nonce Source: 85 Destination: 83
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: oauth_token Source: 23 Destination: 6
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: report_event Source: 515368 Destination: 515361
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_creditmemo_comment Source: 114 Destination: 110
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated Source: 5423 Destination: 5307
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated_order Source: 5194 Destination: 5096
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_order_aggregated_created Source: 7864 Destination: 7656
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_order_aggregated_updated Source: 8960 Destination: 8694
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_refunded_aggregated Source: 507 Destination: 478
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_refunded_aggregated_order Source: 569 Destination: 546
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated Source: 23233 Destination: 22388
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated_order Source: 25340 Destination: 24512
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule Source: 156 Destination: 155
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_coupon_usage Source: 1659 Destination: 1396
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_customer Source: 4981 Destination: 4253
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_customer_group Source: 1251 Destination: 1241
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_label Source: 180 Destination: 174
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_product_attribute Source: 914 Destination: 892
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: salesrule_website Source: 156 Destination: 155
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: tax_order_aggregated_created Source: 19302 Destination: 18336
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: tax_order_aggregated_updated Source: 15810 Destination: 15025
[2020-02-28 14:41:01][WARNING]: Volume Check failed
[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: Log Step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Log Step]: started

[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: customer_visitor Source: 0 Destination: 3459
[2020-02-28 14:41:01][WARNING]: Volume Check failed
[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: ConfigurablePrices step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: ConfigurablePrices step]: started

[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: Tier Price Step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Tier Price Step]: started

[2020-02-28 14:41:01][ERROR]: Mismatch of amount of entities in documents
[2020-02-28 14:41:01][WARNING]: Volume Check failed
[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: Url Rewrite Step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Url Rewrite Step]: started

[2020-02-28 14:41:01][ERROR]: Mismatch of entities in the document: url_rewrite
[2020-02-28 14:41:01][WARNING]: Volume Check failed
[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: OrderGrids Step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: OrderGrids Step]: started

[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: sales_shipment_grid Source: 22264 Destination: 22269
[2020-02-28 14:41:01][WARNING]: Volume Check failed
[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: SalesIncrement Step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: started

[2020-02-28 14:41:01][INFO][mode: delta][stage: delta delivering][step: Inventory Step]: started
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Inventory Step]: started

[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: inventory_source_item Source: 8484 Destination: 8455
[2020-02-28 14:41:01][WARNING]: Mismatch of entities in the document: inventory_shipment_source Source: 22264 Destination: 22269
[2020-02-28 14:41:01][WARNING]: Volume Check failed
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Inventory Step]: Migration completed successfully
[2020-02-28 14:41:01][INFO][mode: delta][stage: volume check][step: Inventory Step]: Automatic restart in 5 sec. Use CTRL-C to abort