TransWikia.com

Magento 2 Migration : Destination fields are missing

Magento Asked by Navin Bhudiya on January 4, 2022

1.9.2.0 to 2.2.5 Migration i am getting bellow error any idea how to resolve it?

 [2018-07-17 20:23:36][ERROR]: Destination fields are missing. Document: catalog_product_entity_decimal. Fields: row_id
    [2018-07-17 20:23:36][ERROR]: Source fields are not mapped. Document: catalog_product_entity_tier_price. Fields: row_id
    [2018-07-17 20:23:36][ERROR]: Source fields are not mapped. Document: catalog_product_entity_group_price. Fields: row_id
    [2018-07-17 20:23:36][ERROR]: Destination fields are not mapped. Document: catalog_product_entity_tier_price. Fields: row_id

config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!--
/**
 * Copyright © 2013-2017 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>MigrationStepSettingsIntegrity</integrity>
            <data>MigrationStepSettingsData</data>
        </step>
        <step title="Stores Step">
            <integrity>MigrationStepStoresIntegrity</integrity>
            <data>MigrationStepStoresData</data>
            <volume>MigrationStepStoresVolume</volume>
        </step>
    </steps>
    <steps mode="data">
        <step title="Data Integrity Step">
            <integrity>MigrationStepDataIntegrityIntegrity</integrity>
        </step>
        <step title="EAV Step">
            <integrity>MigrationStepEavIntegrity</integrity>
            <data>MigrationStepEavData</data>
            <volume>MigrationStepEavVolume</volume>
        </step>
        <step title="Customer Attributes Step">
            <integrity>MigrationStepCustomerIntegrity</integrity>
            <data>MigrationStepCustomerData</data>
            <volume>MigrationStepCustomerVolume</volume>
        </step>
        <step title="Map Step">
            <integrity>MigrationStepMapIntegrity</integrity>
            <data>MigrationStepMapData</data>
            <volume>MigrationStepMapVolume</volume>
        </step>
        <step title="Url Rewrite Step">
            <integrity>MigrationStepUrlRewriteVersion191to2000</integrity>
            <data>MigrationStepUrlRewriteVersion191to2000</data>
            <volume>MigrationStepUrlRewriteVersion191to2000</volume>
        </step>
        <step title="Log Step">
            <integrity>MigrationStepLogIntegrity</integrity>
            <data>MigrationStepLogData</data>
            <volume>MigrationStepLogVolume</volume>
        </step>
        <step title="Ratings Step">
            <integrity>MigrationStepRatingsIntegrity</integrity>
            <data>MigrationStepRatingsData</data>
            <volume>MigrationStepRatingsVolume</volume>
        </step>
        <step title="ConfigurablePrices step">
            <integrity>MigrationStepConfigurablePricesIntegrity</integrity>
            <data>MigrationStepConfigurablePricesData</data>
            <volume>MigrationStepConfigurablePricesVolume</volume>
        </step>
        <step title="OrderGrids Step">
            <integrity>MigrationStepOrderGridsIntegrity</integrity>
            <data>MigrationStepOrderGridsData</data>
            <volume>MigrationStepOrderGridsVolume</volume>
        </step>
        <step title="Tier Price Step">
            <integrity>MigrationStepTierPriceIntegrity</integrity>
            <data>MigrationStepTierPriceData</data>
            <volume>MigrationStepTierPriceVolume</volume>
        </step>
        <step title="SalesIncrement Step">
            <integrity>MigrationStepSalesIncrementIntegrity</integrity>
            <data>MigrationStepSalesIncrementData</data>
            <volume>MigrationStepSalesIncrementVolume</volume>
        </step>
        <step title="PostProcessing Step">
            <data>MigrationStepPostProcessingData</data>
        </step>
    </steps>
    <steps mode="delta">
        <step title="Customer Attributes Step">
            <delta>MigrationStepCustomerDelta</delta>
            <volume>MigrationStepCustomerVolume</volume>
        </step>
        <step title="Map Step">
            <delta>MigrationStepMapDelta</delta>
            <volume>MigrationStepMapVolume</volume>
        </step>
        <step title="Log Step">
            <delta>MigrationStepLogDelta</delta>
            <volume>MigrationStepLogVolume</volume>
        </step>
        <step title="OrderGrids Step">
            <delta>MigrationStepOrderGridsDelta</delta>
            <volume>MigrationStepOrderGridsVolume</volume>
        </step>
        <step title="SalesIncrement Step">
            <delta>MigrationStepSalesIncrementDelta</delta>
            <volume>MigrationStepSalesIncrementVolume</volume>
        </step>
    </steps>
    <source>
        <database host="localhost" name="m1" user="xyz" password="xyz" />
    </source>
    <destination>
        <database host="localhost" name="m2" user="xyz" password="asd" />
    </destination>
    <options>
        <map_file>etc/opensource-to-commerce/1.9.2.0/map.xml</map_file>
        <eav_map_file>etc/opensource-to-commerce/map-eav.xml.dist</eav_map_file>
        <eav_document_groups_file>etc/opensource-to-commerce/eav-document-groups.xml.dist</eav_document_groups_file>
        <eav_attribute_groups_file>etc/opensource-to-commerce/eav-attribute-groups.xml</eav_attribute_groups_file>
        <log_map_file>etc/opensource-to-commerce/map-log.xml.dist</log_map_file>
        <log_document_groups_file>etc/opensource-to-commerce/log-document-groups.xml.dist</log_document_groups_file>
        <settings_map_file>etc/opensource-to-commerce/settings.xml</settings_map_file>
        <customer_map_file>etc/opensource-to-commerce/map-customer.xml.dist</customer_map_file>
        <customer_document_groups_file>etc/opensource-to-commerce/customer-document-groups.xml.dist</customer_document_groups_file>
        <customer_attribute_groups_file>etc/opensource-to-commerce/customer-attribute-groups.xml.dist</customer_attribute_groups_file>
        <delta_document_groups_file>etc/opensource-to-commerce/deltalog.xml.dist</delta_document_groups_file>
        <order_grids_document_groups_file>etc/opensource-to-commerce/order-grids-document-groups.xml.dist</order_grids_document_groups_file>
        <map_document_groups>etc/opensource-to-commerce/map-document-groups.xml.dist</map_document_groups>
        <class_map>etc/opensource-to-commerce/class-map.xml</class_map>
        <tier_price_map_file>etc/opensource-to-commerce/map-tier-price.xml.dist</tier_price_map_file>
        <stores_map_file>etc/opensource-to-commerce/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>mg_</source_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-commerce</edition_migrate>
        <edition_number>1.9.2.0</edition_number>
        <init_statements_source>SET NAMES utf8;</init_statements_source>
        <init_statements_destination>SET NAMES utf8;</init_statements_destination>
        <crypt_key>jmhqfife2e5y6377k2h7jv4vvnm4cuzz</crypt_key>
    </options>
</config>

2 Answers

Try This Command For Data Migration :-

[-a|--auto] is an optional argument that prevents migration from stopping when it encounters integrity check errors.

php bin/magento migrate:data --auto vendor/magento/data-migration-tool/etc/<edition-to-edition>/<version>/config.xml

"Source fields are not mapped" For This Error

Define in vendor/magento/data-migration-tool/etc/edition-to-edition/version/map.xml

<field_rules>
      <ignore>
          <field>TABLE_NAME.COLUMN_NAME</field>
      </ignore>
      <ignore>
          <field>catalog_product_entity_tier_price.row_id</field>
      </ignore>
      <ignore>
          <field>catalog_product_entity_group_price.row_id</field>
      </ignore>
</field_rules>

And Change On Config.xml File :-

<map_file>etc/edition-to-edition/version/map.xml</map_file>

Answered by Ronak Rathod on January 4, 2022

@Navin Bhudiya please remove .xml.dist and add .xml also convert file .xml.dist to .xml and try

    <eav_map_file>etc/opensource-to-commerce/map-eav.xml.dist</eav_map_file>
    <eav_document_groups_file>etc/opensource-to-commerce/eav-document-groups.xml</eav_document_groups_file>
    <eav_attribute_groups_file>etc/opensource-to-commerce/eav-attribute-groups.xml</eav_attribute_groups_file>
    <log_map_file>etc/opensource-to-commerce/map-log.xml</log_map_file>
    <log_document_groups_file>etc/opensource-to-commerce/log-document-groups.xml</log_document_groups_file>
    <settings_map_file>etc/opensource-to-commerce/settings.xml</settings_map_file>
    <customer_map_file>etc/opensource-to-commerce/map-customer.xml</customer_map_file>
    <customer_document_groups_file>etc/opensource-to-commerce/customer-document-groups.xml</customer_document_groups_file>
    <customer_attribute_groups_file>etc/opensource-to-commerce/customer-attribute-groups.xml</customer_attribute_groups_file>
    <delta_document_groups_file>etc/opensource-to-commerce/deltalog.xml.dist</delta_document_groups_file>
    <order_grids_document_groups_file>etc/opensource-to-commerce/order-grids-document-groups.xml</order_grids_document_groups_file>
    <map_document_groups>etc/opensource-to-commerce/map-document-groups.xml</map_document_groups>
    <class_map>etc/opensource-to-commerce/class-map.xml</class_map>
    <tier_price_map_file>etc/opensource-to-commerce/map-tier-price.xml</tier_price_map_file>
    <stores_map_file>etc/opensource-to-commerce/map-stores.xml</stores_map_file>

Answered by Rutvee Sojitra on January 4, 2022

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP