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>
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
Get help from others!
Recent Questions
Recent Answers
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP