Magento will stop supporting Magento in June 2020, which leads to a significant increase in the number of people who tend to migrate to Magento 2. However, migrating your store from Magento 1 to Magento 2 is never a simple task. You can encounter several errors while you are migrating the database from Magento 1 to Magento 2. This can make the process of data migration even more difficult.
I have ever implemented some migration projects for our customers. When I am trying to perform data migration from Magento 1 to Magento 2, I get an error that says Document has ambiguous configuration. In this post, I will help you understand more about what it is and how you can address it.
As you know, Magento has developed the Magento Data Migration Tool which lets you move all the products, customers, and order data, store configurations, promotions and more to Magento 2. The tool will use map files to transform data for use in the Magento 2 store. When the document is ignored in map files, the Data Migration Tool will inform you of an error message and does not run.
An example you may get while attempting to migrate data:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
[2019-10-30 17:50:15][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started 100% [============================] Remaining Time: 1 sec [2019-10-30 17:50:15][INFO][mode: data][stage: integrity check][step: Map Step]: started 55% [============>---------------] Remaining Time: 3 secs [2019-10-30 17:50:15][ERROR]: Document has ambiguous configuration: sales_flat_order [2019-10-30 17:50:15][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started 100% [============================] Remaining Time: 1 sec [2019-10-30 17:50:15][INFO][mode: data][stage: integrity check][step: Log Step]: started 100% [============================] Remaining Time: 1 sec [2019-10-30 17:50:15][INFO][mode: data][stage: integrity check][step: Ratings Step]: started 100% [============================] Remaining Time: 1 sec [2019-10-30 17:50:15][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started 100% [============================] Remaining Time: 1 sec [Migration\Exception] |
Integrity Check failed
1 |
migrate:data --reset config |
The error “Document has ambiguous configuration: sales_flat_order” indicates that you made document: sales_flat_order be ignored in your map file. In case you don’t need the data from this table, then you can remove this tag from the map file where you ignored. For example:
1 2 3 4 |
<rename> <document>sales_flat_order</document> <to>quote_payment</to> </rename> |
Once you are done, you have to perform validation checks to make sure that the database is returning results and not errors. Some other errors, you can refer to official documentation from Magento to find out the answers.
Mistakes made during migrations can lead to the loss of important data. But if you have a thorough preparation through the process, you can avoid some of the common data migration risks.