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
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