Delta Migration Skipping New / Updated Products

[JamesAllwood]

Before I start, I've read through #316 fully, and it seems my issue is unrelated.

I have production M1 and development M2 on the same server, and successfully completed the initial data migration. M1 is 1.9.3.8 and M2 is 2.2.3

m2_cl_* tables were successfully created in M1.

Immiately after the migration, I wanted to test the delta migration. I created a new product in M1 and ran the script

php bin/magento migrate:delta -r -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.8/config.xml

This resulted in some of those pesky Mismatch of entities in the document warnings, specifically with the product entities.

[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_category_product_index Source: 78463 Destination: 20244
[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_product_entity Source: 17950 Destination: 17949
[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_product_entity_datetime Source: 94348 Destination: 94342
[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_product_entity_decimal Source: 71824 Destination: 71819
[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_product_entity_int Source: 369618 Destination: 369586
[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_product_entity_text Source: 73926 Destination: 73921
[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_product_entity_varchar Source: 393179 Destination: 380226
[2018-03-21 14:47:20][WARNING]: Mismatch of entities in the document: catalog_product_website Source: 17950 Destination: 17949
[2018-03-21 14:47:20][WARNING]: Volume Check failed

There are no m2_cl_* tables specifically named for product entities, so I know it's not an issue with those tables not being updated.

The script identifies that the number of products are different, which you'd think would be the trigger for it update them, but instead, it just complains about it and then skips them.

Unless I'm misinformed that the delta update migrates product changes, then something is clearly a miss and I can't find a solution. Any ideas?

[markshust]

I'm having the exact same issue, going from 1.9.2.4 > 2.2.0.

[victor-v-rad]

Hi @JamesAllwood @markoshust

See Migration Guide > Migrate changes to know what delta mode can and cannot migrate.

There is related issue #469 look for the details there. Improvement request number MAGETWO-88440