"Integrity Check Failed" error in magento data migration process, in migrate:data command.

[Rattan Lal]

I am working on magento data migrate from magento 1.9.2.1 to magento 2. Migarte settings section is works fine, but when i am trying to migrate data , it showing me an errror [Migration/Exception] : "Integrity Check Failed" . Please help me to fix it asap.

[Rattan Lal]

Here is error log:

[2015-12-22 17:16:19][INFO][mode: data][stage: integrity check][step: EAV Step]: started
[2015-12-22 17:16:19][ERROR]: Source fields are missing or not mapped. Document: customer_eav_attribute. Fields: is_used_for_customer_segment
[2015-12-22 17:16:19][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
[2015-12-22 17:16:19][INFO][mode: data][stage: integrity check][step: Map Step]: started
[2015-12-22 17:16:31][ERROR]: Source documents are missing or not mapped: paybox_question_number,social_facebook_actions,strikeiron_tax_rate,xmlconnect_application,xmlconnect_config_data,xmlconnect_history,xmlconnect_images,xmlconnect_notification_template,xmlconnect_queue
[2015-12-22 17:16:31][ERROR]: Destination documents are missing or not mapped: catalog_category_product_cl,catalog_product_attribute_cl,catalog_product_category_cl,catalog_product_price_cl,cataloginventory_stock_cl,catalogrule_product_cl,catalogrule_rule_cl,catalogsearch_fulltext_cl,dummy_cl
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: cms_page. Fields: published_revision_id,website_root,under_version_control
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_creditmemo. Fields: base_customer_balance_amount,customer_balance_amount,bs_customer_bal_total_refunded,customer_bal_total_refunded,base_gift_cards_amount,gift_cards_amount,gw_base_price,gw_price,gw_items_base_price,gw_items_price,gw_card_base_price,gw_card_price,gw_base_tax_amount,gw_tax_amount,gw_items_base_tax_amount,gw_items_tax_amount,gw_card_base_tax_amount,gw_card_tax_amount,base_reward_currency_amount,reward_currency_amount,reward_points_balance,reward_points_balance_refund
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_invoice. Fields: base_customer_balance_amount,customer_balance_amount,base_gift_cards_amount,gift_cards_amount,gw_base_price,gw_price,gw_items_base_price,gw_items_price,gw_card_base_price,gw_card_price,gw_base_tax_amount,gw_tax_amount,gw_items_base_tax_amount,gw_items_tax_amount,gw_card_base_tax_amount,gw_card_tax_amount,base_reward_currency_amount,reward_currency_amount,reward_points_balance
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_order. Fields: base_customer_balance_amount,customer_balance_amount,base_customer_balance_invoiced,customer_balance_invoiced,base_customer_balance_refunded,customer_balance_refunded,bs_customer_bal_total_refunded,customer_bal_total_refunded,gift_cards,base_gift_cards_amount,gift_cards_amount,base_gift_cards_invoiced,gift_cards_invoiced,base_gift_cards_refunded,gift_cards_refunded,gw_id,gw_allow_gift_receipt,gw_add_card,gw_base_price,gw_price,gw_items_base_price,gw_items_price,gw_card_base_price,gw_card_price,gw_base_tax_amount,gw_tax_amount,gw_items_base_tax_amount,gw_items_tax_amount,gw_card_base_tax_amount,gw_card_tax_amount,gw_base_price_invoiced,gw_price_invoiced,gw_items_base_price_invoiced,gw_items_price_invoiced,gw_card_base_price_invoiced,gw_card_price_invoiced,gw_base_tax_amount_invoiced,gw_tax_amount_invoiced,gw_items_base_tax_invoiced,gw_items_tax_invoiced,gw_card_base_tax_invoiced,gw_card_tax_invoiced,gw_base_price_refunded,gw_price_refunded,gw_items_base_price_refunded,gw_items_price_refunded,gw_card_base_price_refunded,gw_card_price_refunded,gw_base_tax_amount_refunded,gw_tax_amount_refunded,gw_items_base_tax_refunded,gw_items_tax_refunded,gw_card_base_tax_refunded,gw_card_tax_refunded,reward_points_balance,base_reward_currency_amount,reward_currency_amount,base_rwrd_crrncy_amt_invoiced,rwrd_currency_amount_invoiced,base_rwrd_crrncy_amnt_refnded,rwrd_crrncy_amnt_refunded,reward_points_balance_refund,reward_points_balance_refunded,reward_salesrule_points
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_order_address. Fields: giftregistry_item_id
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_order_item. Fields: event_id,giftregistry_item_id,gw_id,gw_base_price,gw_price,gw_base_tax_amount,gw_tax_amount,gw_base_price_invoiced,gw_price_invoiced,gw_base_tax_amount_invoiced,gw_tax_amount_invoiced,gw_base_price_refunded,gw_price_refunded,gw_base_tax_amount_refunded,gw_tax_amount_refunded,qty_returned
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_quote. Fields: customer_balance_amount_used,base_customer_bal_amount_used,use_customer_balance,gift_cards,gift_cards_amount,base_gift_cards_amount,gift_cards_amount_used,base_gift_cards_amount_used,gw_id,gw_allow_gift_receipt,gw_add_card,gw_base_price,gw_price,gw_items_base_price,gw_items_price,gw_card_base_price,gw_card_price,gw_base_tax_amount,gw_tax_amount,gw_items_base_tax_amount,gw_items_tax_amount,gw_card_base_tax_amount,gw_card_tax_amount,use_reward_points,reward_points_balance,base_reward_currency_amount,reward_currency_amount
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_quote_address. Fields: base_customer_balance_amount,customer_balance_amount,gift_cards_amount,base_gift_cards_amount,gift_cards,used_gift_cards,giftregistry_item_id,gw_id,gw_allow_gift_receipt,gw_add_card,gw_base_price,gw_price,gw_items_base_price,gw_items_price,gw_card_base_price,gw_card_price,gw_base_tax_amount,gw_tax_amount,gw_items_base_tax_amount,gw_items_tax_amount,gw_card_base_tax_amount,gw_card_tax_amount,reward_points_balance,base_reward_currency_amount,reward_currency_amount
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_quote_address_item. Fields: gw_id,gw_base_price,gw_price,gw_base_tax_amount,gw_tax_amount
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: sales_flat_quote_item. Fields: event_id,giftregistry_item_id,gw_id,gw_base_price,gw_price,gw_base_tax_amount,gw_tax_amount
[2015-12-22 17:16:31][ERROR]: Source fields are missing or not mapped. Document: wishlist. Fields: name,visibility
[2015-12-22 17:16:31][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
[2015-12-22 17:16:31][INFO][mode: data][stage: integrity check][step: Log Step]: started
[2015-12-22 17:16:31][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
[2015-12-22 17:16:31][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
[2015-12-22 17:16:31][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
[2015-12-22 17:16:31][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
[2015-12-22 17:16:31][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started

[akent99]

Sorry, this area is more for architectural questions. That one is too detailed - I simply don't know the answer for this particular situation (and doubt I will have time to chase it down).

Some guesses - you may have additional modules installed that have added new tables of columns. Any such cases you need to add to the mapping files so the system knows how to copy them over to the new tables. It is pretty easy to copy columns directly over, but if data manipulation is required you will need to write some PHP code.

I assume you have read through http://devdocs.magento.com/guides/v2.0/migration/bk-migration-guide.html and https://magento.com/resources/magento-2-migration-whitepaper.

If you become convinced its a bug, feel free to raise on GitHub as an issue. You can also create issues if you think sections of the documentation are not clear enough. That will go to the docs team instead (but is still a bug).