Magento 2: Data Migration errors using magento 2 data migration tools

Question

I am migrate data magento version 1.9.2.1 to version 2. Migrate Setting are successfully done. Migrate Data are run and display error like

[PDOException]                                                               
  SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-Mi  
  gration_Default' for key 'EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NA  
  ME'

and in migration.log file at delta migrate,

[2015-12-24 06:05:03][INFO][mode: delta][stage: delta delivering][step: Customer Attributes Step]: started
[2015-12-24 06:05:03][INFO][mode: delta][stage: volume check][step: Customer Attributes Step]: started
[2015-12-24 06:05:03][INFO][mode: delta][stage: delta delivering][step: Map Step]: started
[2015-12-24 06:05:04][INFO][mode: delta][stage: volume check][step: Map Step]: started
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: rating_option_vote
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: rating_option_vote_aggregated
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: rating_store
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: report_event
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: report_viewed_product_aggregated_daily
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: report_viewed_product_aggregated_monthly
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: report_viewed_product_aggregated_yearly
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: report_viewed_product_index
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: review
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: review_detail
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: review_entity_summary
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: review_store
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_daily
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_monthly
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_bestsellers_aggregated_yearly
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_invoice
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_invoice_comment
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_invoice_item
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_address
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_item
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_payment
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_status_history
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: quote
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: quote_address
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: quote_item
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: quote_item_option
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: quote_payment
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: quote_shipping_rate
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_shipment
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_shipment_item
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_shipment_track
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_invoiced_aggregated_order
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_aggregated_created
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_aggregated_updated
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_status_state
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_shipping_aggregated_order
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: salesrule
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: salesrule_coupon
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: salesrule_coupon_usage
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: salesrule_customer
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: salesrule_customer_group
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: salesrule_product_attribute
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: salesrule_website
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: shipping_tablerate
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sitemap
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: tax_calculation
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: tax_calculation_rule
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: tax_class
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: wishlist
[2015-12-24 06:05:04][WARNING]: Volume Check failed
[2015-12-24 06:05:04][INFO][mode: delta][stage: delta delivering][step: Log Step]: started
[2015-12-24 06:05:04][INFO][mode: delta][stage: volume check][step: Log Step]: started
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: customer_visitor
[2015-12-24 06:05:04][WARNING]: Volume Check failed
[2015-12-24 06:05:04][INFO][mode: delta][stage: delta delivering][step: OrderGrids Step]: started
[2015-12-24 06:05:04][INFO][mode: delta][stage: volume check][step: OrderGrids Step]: started
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_order_grid
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_invoice_grid
[2015-12-24 06:05:04][WARNING]: Mismatch of entities in the document: sales_shipment_grid
[2015-12-24 06:05:04][WARNING]: Volume Check failed
[2015-12-24 06:05:04][INFO][mode: delta][stage: delta delivering][step: SalesIncrement Step]: started
[2015-12-24 06:05:04][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: started
[2015-12-24 06:05:04][WARNING]: Mismatch in last increment id of order entity
[2015-12-24 06:05:04][WARNING]: Mismatch in last increment id of invoice entity
[2015-12-24 06:05:04][WARNING]: Mismatch in last increment id of creditmemo entity
[2015-12-24 06:05:04][WARNING]: Mismatch in last increment id of shipment entity
[2015-12-24 06:05:04][WARNING]: Volume Check failed
[2015-12-24 06:05:04][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: Migration completed successfully

Catalog,Customer,CMS,Category all data are available from magento 1 to magento 2 but Review, Sales Related Data are not appear in migrate data. How to do for sales order and review related data in migration?

Answer 1

this error is of duplication. If you see in your M1 database then Default attribute set will be duplicated in eav_attribute_set table. So, the solution for this is delete all Default attribute set from your M1 db and then start your migration to new blank fresh Magento2 db.

I hope it would help. :-)