Data-migration-tool: Migrate magento 1.9.1 to magento 2.2.3 Url Rewrite Step - Error occurred

Created on 16 May 2018 · 2Comments · Source: magento/data-migration-tool

So I have installed the fresh instalation of magento 2, didn't change any settings after. Run migration with --auto option and get's error on Url Rewrite Step

Here is the log

[2018-05-16 03:43:06][INFO][mode: settings][stage: integrity check][step: Settings Step]: started
[2018-05-16 03:43:06][INFO][mode: settings][stage: integrity check][step: Stores Step]: started
[2018-05-16 03:43:06][INFO][mode: settings][stage: data migration][step: Settings Step]: started
[2018-05-16 03:43:09][INFO][mode: settings][stage: data migration][step: Stores Step]: started
[2018-05-16 03:43:09][INFO][mode: settings][stage: volume check][step: Stores Step]: started
[2018-05-16 03:43:09][INFO][mode: settings][stage: volume check][step: Stores Step]: Migration completed
[2018-05-16 03:43:15][INFO][mode: data][stage: integrity check][step: Data Integrity Step]: started
[2018-05-16 03:43:16][WARNING]: Foreign key (FK_CHKT_AGRT_STORE_AGRT_ID_CHKT_AGRT_AGRT_ID) constraint fails on source database. Orphan records id: 1,2 from `checkout_agreement_store`.`agreement_id` has no referenced records in `checkout_agreement`
[2018-05-16 03:43:16][WARNING]: Foreign key (FK_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID) constraint fails on source database. Orphan records id: 121 from `eav_entity_attribute`.`attribute_id` has no referenced records in `eav_attribute`
[2018-05-16 03:43:16][INFO][mode: data][stage: integrity check][step: EAV Step]: started
[2018-05-16 03:43:16][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
[2018-05-16 03:43:16][INFO][mode: data][stage: integrity check][step: Map Step]: started
[2018-05-16 03:43:19][WARNING]: Source fields are not mapped. Document: sales_flat_order_payment. Fields: ogone_issuer_id,morningtime_response_code
[2018-05-16 03:43:19][WARNING]: Source fields are not mapped. Document: sales_flat_quote_payment. Fields: ogone_issuer_id
[2018-05-16 03:43:19][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
[2018-05-16 03:43:19][INFO][mode: data][stage: integrity check][step: Log Step]: started
[2018-05-16 03:43:19][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
[2018-05-16 03:43:19][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
[2018-05-16 03:43:19][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
[2018-05-16 03:43:19][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
[2018-05-16 03:43:19][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started
[2018-05-16 03:43:19][INFO][mode: data][stage: setup triggers][step: Stage]: started
[2018-05-16 03:43:20][INFO][mode: data][stage: data migration][step: EAV Step]: started
[2018-05-16 03:43:21][INFO][mode: data][stage: volume check][step: EAV Step]: started
[2018-05-16 03:43:21][INFO][mode: data][stage: data migration][step: Customer Attributes Step]: started
[2018-05-16 03:43:22][INFO][mode: data][stage: volume check][step: Customer Attributes Step]: started
[2018-05-16 03:43:22][INFO][mode: data][stage: data migration][step: Map Step]: started
[2018-05-16 03:44:09][INFO][mode: data][stage: volume check][step: Map Step]: started
[2018-05-16 03:44:10][INFO][mode: data][stage: data migration][step: Url Rewrite Step]: started
[2018-05-16 03:44:23][INFO][mode: data][stage: volume check][step: Url Rewrite Step]: started
[2018-05-16 03:44:23][ERROR]: Mismatch of entities in the document: url_rewrite
[2018-05-16 03:44:23][INFO][mode: data][stage: volume check][step: Url Rewrite Step]: Error occurred. Rollback.
[2018-05-16 03:44:23][INFO][mode: data][stage: volume check][step: Url Rewrite Step]: Url Rewrite Step: rollback
[2018-05-16 03:44:23][INFO][mode: data][stage: volume check][step: Url Rewrite Step]: Please fix errors and run Migration Tool again

Any idea how to fix it? I checked in admin, and there are some basic data migration, but not all of them.

question

Source

alexthecoderr

Most helpful comment

Hi @alexthecoderr

Probably some UrlRewite records were not migrated. It would be good to find them to understand if they important. If not then the eases way is just remove Volume check of UrlRewrite in your config.xml.