New Orders are not in Order grid after data migration from M 1.7.0.2 to M 2.1.7

[joergmaertin]

Preconditions

1. PHP 5.6 latest FPM
2. MySQL 5.6.19
3. Running Magento CE 1.7.0.2, database replicated, no problems here.
4. Fresh Magento CE 2.1.7 with Luma Theme
5. Datamigration Tool 2.1.7
6. vendor/magento/data-migration-tool/etc/ce-to-ce/1.7.0.2/config.xml Datamigration

Steps to reproduce

1. Migrate Data from 1.7.0.2 to Magento 2.1.7
2. Place order as guest in Magento 2.1.7
3. Choose internal Payment method "Check/Money order" or "Bank transfer"
4. Finish order

Expected result

1. The customer should get an email about the order
2. The order should be visible in order grid
3. The order should be visible in dashboard

Actual result

1. The Customer gets an email with correct content of order and order no. that is in line with the order no. in general
   2. But the order is not visible in order grid, it seems not being saved here
2. The order is visible with entry "Guest" in Dashboard. Magento 1.7.0.2 saved the name of the customer here even as guest.
3. Reindexing brings no better result

The issue has been first reported in magento/magento2#4431 which was closed. Again reported in magento/magento2#10128, on request the issue has been specified here.

I have included logs in magento/magento2#10128. I'd like to include my datamigration config files here to review. Maybe there is something important missing in my files, which also need to be migrated.

[victor-v-rad]

Hi @joergmaertin

Thank you for posting detailed issue. I see the copyrights in the provided map.xml.txt and config.xml.txt point to 2015 and 2016 year. It seems files are outdated. Compare with the latest config.xml.dist from 2.1.7 version of the tool. Check your actual version of the tool in m2_root/vendor/magento/data-migration-tool/composer.json file in 'version' field.

Also I noticed one important step is excluded

        <step title="Data Integrity Step">
            <integrity>Migration\Step\DataIntegrity\Integrity</integrity>
        </step>

from your config.xml

PS: you might be wanting to change the password to your MySQL. Since you disclosed it in provided config.xml

[joergmaertin]

Thanks for the hint about the password. Already changed. Actually I installed 2.1.7 tool as requested for installation within Magento 2.1.7. But I check this.