Migration from 1.9.3.1 to 2.3.2 Error: Record structure does not contain field path

[hayden_holbrook]

I am running a migration from 1.9.3.1 to 2.3.2. I copied the database from my Magento 1.9 store to a new database on the same server my Magento 2 install is on. I created a new empty database and configured the data migration tool.

<database host="localhost" name="magento1" user="*****" password="*****" />
    </source>
    <destination>
        <database host="localhost" name="magento2" user="*****" password="*****" />
    </destination>

I haven't changed anything in config.xml other than the crypt key.

I have had a few different error messages come up while trying to run:

# bin/magento migrate:settings -a -r public_html/magento2/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml

I have made it past a few different errors getting the data migration tool configured correctly with my databases and now it starts fine.

Now it throws up this error:

[2019-08-07 17:46:08][INFO][mode: settings][stage: integrity check][step: Settings Step]: started
100% [============================] Remaining Time: < 1 sec
[2019-08-07 17:46:08][INFO][mode: settings][stage: integrity check][step: Stores Step]: started
100% [============================] Remaining Time: < 1 sec
[2019-08-07 17:46:08][WARNING]: Source documents are not mapped: core_store,core_store_group,core_website                                   
[2019-08-07 17:46:08][WARNING]: Destination documents are not mapped: store,store_group,store_website                                       
[2019-08-07 17:46:08][INFO][mode: settings][stage: data migration][step: Settings Step]: started
0% [>---------------------------] Remaining Time: < 1 sec
[2019-08-07 17:46:08][ERROR]: Record structure does not contain field path                                                                  
In Settings.php line 101:
                         
  Data Migration failed  
                         

migrate:settings [-r|--reset] [-a|--auto] [--] <config>

I'm not sure what is going wrong. Any help would be much appreciated!

[Damian Culotta]

Hi @hayden_holbrook,

Is you bin/magento global?

From where are you running bin/magento since public_html/magento2/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml?

Shouldn't be?

bin/magento migrate:settings -a -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml

[hayden_holbrook]

Damian,

I a running it from there since I have another store farther up in the file structure. Is that causing the problem?

Hayden

[hayden_holbrook]

I tried running it with the shortened file path and got the same error.

[Damian Culotta]

Hi @hayden_holbrook,

Is it possible to share the XML (change the passwords and username at least) to see if evertyhing is ok?

[hayden_holbrook]

<?xml version="1.0" encoding="UTF-8"?>
<!--
/**
 * Copyright © Magento, Inc. All rights reserved.
 * See COPYING.txt for license details.
 */
-->
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
    <steps mode="settings">
        <step title="Settings Step">
            <integrity>Migration\Step\Settings\Integrity</integrity>
            <data>Migration\Step\Settings\Data</data>
        </step>
        <step title="Stores Step">
            <integrity>Migration\Step\Stores\Integrity</integrity>
            <data>Migration\Step\Stores\Data</data>
            <volume>Migration\Step\Stores\Volume</volume>
        </step>
    </steps>
    <steps mode="data">
        <step title="Data Integrity Step">
            <integrity>Migration\Step\DataIntegrity\Integrity</integrity>
        </step>
        <step title="EAV Step">
            <integrity>Migration\Step\Eav\Integrity</integrity>
            <data>Migration\Step\Eav\Data</data>
            <volume>Migration\Step\Eav\Volume</volume>
        </step>
        <step title="Customer Attributes Step">
            <integrity>Migration\Step\Customer\Integrity</integrity>
            <data>Migration\Step\Customer\Data</data>
            <volume>Migration\Step\Customer\Volume</volume>
        </step>
        <step title="Map Step">
            <integrity>Migration\Step\Map\Integrity</integrity>
            <data>Migration\Step\Map\Data</data>
            <volume>Migration\Step\Map\Volume</volume>
        </step>
        <step title="Url Rewrite Step">
            <integrity>Migration\Step\UrlRewrite\Version191to2000</integrity>
            <data>Migration\Step\UrlRewrite\Version191to2000</data>
            <volume>Migration\Step\UrlRewrite\Version191to2000</volume>
        </step>
        <step title="Log Step">
            <integrity>Migration\Step\Log\Integrity</integrity>
            <data>Migration\Step\Log\Data</data>
            <volume>Migration\Step\Log\Volume</volume>
        </step>
        <step title="Ratings Step">
            <integrity>Migration\Step\Ratings\Integrity</integrity>
            <data>Migration\Step\Ratings\Data</data>
            <volume>Migration\Step\Ratings\Volume</volume>
        </step>
        <step title="ConfigurablePrices step">
            <integrity>Migration\Step\ConfigurablePrices\Integrity</integrity>
            <data>Migration\Step\ConfigurablePrices\Data</data>
            <volume>Migration\Step\ConfigurablePrices\Volume</volume>
        </step>
        <step title="OrderGrids Step">
            <integrity>Migration\Step\OrderGrids\Integrity</integrity>
            <data>Migration\Step\OrderGrids\Data</data>
            <volume>Migration\Step\OrderGrids\Volume</volume>
        </step>
        <step title="Tier Price Step">
            <integrity>Migration\Step\TierPrice\Integrity</integrity>
            <data>Migration\Step\TierPrice\Data</data>
            <volume>Migration\Step\TierPrice\Volume</volume>
        </step>
        <step title="SalesIncrement Step">
            <integrity>Migration\Step\SalesIncrement\Integrity</integrity>
            <data>Migration\Step\SalesIncrement\Data</data>
            <volume>Migration\Step\SalesIncrement\Volume</volume>
        </step>
        <step title="Inventory Step">
            <integrity>Migration\Step\Inventory\Integrity</integrity>
            <data>Migration\Step\Inventory\Data</data>
            <volume>Migration\Step\Inventory\Volume</volume>
        </step>
        <step title="PostProcessing Step">
            <data>Migration\Step\PostProcessing\Data</data>
        </step>
    </steps>
    <steps mode="delta">
        <step title="Customer Attributes Step">
            <delta>Migration\Step\Customer\Delta</delta>
            <volume>Migration\Step\Customer\Volume</volume>
        </step>
        <step title="Map Step">
            <delta>Migration\Step\Map\Delta</delta>
            <volume>Migration\Step\Map\Volume</volume>
        </step>
        <step title="Log Step">
            <delta>Migration\Step\Log\Delta</delta>
            <volume>Migration\Step\Log\Volume</volume>
        </step>
        <step title="OrderGrids Step">
            <delta>Migration\Step\OrderGrids\Delta</delta>
            <volume>Migration\Step\OrderGrids\Volume</volume>
        </step>
        <step title="SalesIncrement Step">
            <delta>Migration\Step\SalesIncrement\Delta</delta>
            <volume>Migration\Step\SalesIncrement\Volume</volume>
        </step>
        <step title="Inventory Step">
            <delta>Migration\Step\Inventory\Delta</delta>
            <volume>Migration\Step\Inventory\Volume</volume>
        </step>
    </steps>
    <source>
        <database host="localhost" name="magento1" user="*****" password="*****" />
    </source>
    <destination>
        <database host="localhost" name="magento2" user="*****" password="*****" />
    </destination>
    <options>
        <map_file>etc/opensource-to-opensource/1.9.3.1/map.xml.dist</map_file>
        <eav_map_file>etc/opensource-to-opensource/map-eav.xml.dist</eav_map_file>
        <eav_document_groups_file>etc/opensource-to-opensource/eav-document-groups.xml.dist</eav_document_groups_file>
        <eav_attribute_groups_file>etc/opensource-to-opensource/eav-attribute-groups.xml.dist</eav_attribute_groups_file>
        <log_map_file>etc/opensource-to-opensource/map-log.xml.dist</log_map_file>
        <log_document_groups_file>etc/opensource-to-opensource/log-document-groups.xml.dist</log_document_groups_file>
        <settings_map_file>etc/opensource-to-opensource/settings.xml.dist</settings_map_file>
        <customer_map_file>etc/opensource-to-opensource/map-customer.xml.dist</customer_map_file>
        <customer_document_groups_file>etc/opensource-to-opensource/customer-document-groups.xml.dist</customer_document_groups_file>
        <customer_attribute_groups_file>etc/opensource-to-opensource/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
        <delta_document_groups_file>etc/opensource-to-opensource/deltalog.xml.dist</delta_document_groups_file>
        <order_grids_document_groups_file>etc/opensource-to-opensource/order-grids-document-groups.xml.dist</order_grids_document_groups_file>
        <map_document_groups>etc/opensource-to-opensource/map-document-groups.xml.dist</map_document_groups>
        <class_map>etc/opensource-to-opensource/class-map.xml.dist</class_map>
        <tier_price_map_file>etc/opensource-to-opensource/1.9.3.1/map-tier-price.xml.dist</tier_price_map_file>
        <stores_map_file>etc/opensource-to-opensource/map-stores.xml.dist</stores_map_file>
        <!--
        In case bulk_size=0 it will be auto-detected for every document.
        -->
        <bulk_size>0</bulk_size>
        <!--
        Set direct_document_copy = 1 for better performance.
        NOTE: 'source' and 'destination' databases MUST be placed on the same MySQL instance
        and 'destination' user MUST be granted with 'SELECT' permissions on 'source' database
         -->
        <direct_document_copy>0</direct_document_copy>
        <source_prefix />
        <dest_prefix></dest_prefix>
        <auto_resolve_urlrewrite_duplicates>0</auto_resolve_urlrewrite_duplicates>
        <log_file>migration.log</log_file>
        <progress_bar_format>%percent%% [%bar%] Remaining Time: %remaining%</progress_bar_format>
        <upgrade_customer_password_hash>1</upgrade_customer_password_hash>
        <edition_migrate>opensource-to-opensource</edition_migrate>
        <edition_number>1.9.3.1</edition_number>
        <init_statements_source>SET NAMES utf8;</init_statements_source>
        <init_statements_destination>SET NAMES utf8;</init_statements_destination>
        <crypt_key>********</crypt_key>
    </options>
</config>

[Damian Culotta]

Hi @hayden_holbrook,

I compared your XML with one of mine (from another version) and the only thing (that shouldn't be a problem, but is different was this line:

<dest_prefix></dest_prefix>

Can you try with:

<dest_prefix />

Can you check that?

[siddiqui208]

Hi @hayden_holbrook 

I have read all the conversation about migration.
How to installed migration tools?. using composer or from Github.

If you have used a manual, you can try from the composer. Also, compare the table from fresh Magento 1.9.x.x which has an integrity issue. It may be the table modify in Magento 1.9.x.x.

Thanks,
Siddiqui

[hayden_holbrook]

Siddiqui208,

I installed via composer.

I will try with a fresh 1.9.x.x and see if I can get that to work. Thanks for the suggestion!

Hayden

[hayden_holbrook]

Damian,

I have tried with that change and I still get the same error. I wish the error message would tell me a bit more about where the problem is occurring.

Thanks,

Hayden