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