data-migration-tool: Integrity Check failed for Url Rewrites

data-migration is failing at integrity check stage for url rewrite step with the following command: php bin/magento migrate:data {/path/to/data-migration/config.xml}

[ERROR]: There are duplicates in URL rewrites: Request path: towel-set.html Store ID: 2 Target path: catalog/product/view/id/10229 Request path: towel-set.html Store ID: 2 Target path: catalog/product/view/id/10224

I tried to check but there are no any duplicate entries: select * from enterprise_url_rewrite where request_path like 'towel-set%' and store_id = 2

Gives only 1 result

select request_path, store_id, count(*) from enterprise_url_rewrite group by request_path, store_id having count(*) > 1

Gives empty result set.

Any idea what can be the issue?

About this issue

  • Original URL
  • State: closed
  • Created 8 years ago
  • Comments: 16

Most upvoted comments

Is this a bug or something I just need to account for somehow?

It is a bug in your case and fix for it will be available with 2.1.1 release of the tool.

Try auto_resolve_urlrewrite_duplicates = 1 in your config.xml