Upgrade from 1.9.3.0 to 2.2.1

[jeanboeytan]

Hi, after I ran php bin/magento migrate:settings /home/account/public_html/dev/mage4/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.0/config.xml , I get an error 

[Magento\Framework\Config\Dom\ValidationException]
Extra content at the end of the document
Line: 4

What could have been the issue?

[jeanboeytan]

Hi. Thank you for helping. Here it is below:

<source>
<database host="127.0.0.0.1" name="mage1_db_name" user="mage1_db_user" password="mage1_db_pass"/>
</source>
<destination>
<database host="127.0.0.0.1" name="mage2_db_name" user="mage2_db_user" password="mage2_db_pass"/>
</destination>
<options>
<crypt_key>crypkeyhere1231387128323</crypt_key>
</options>

127.0.0.0.1 is not our actual IP, but i've put there our server IP. So as for the name, user ,crypt key and pass, i've put our actual database user, pass, name and crypt key.

[Rakesh Jesadiya]

Could you show your config.xml full code not just specific line?

[jeanboeytan]

Hi, sorry there were missing codes that were deleted accidentally.. Im using the default  config.xml from the .dist file and then changed those above. Then I ran again and it says

[2017-12-01 01:06:41][INFO][mode: settings][stage: integrity check][step: Settings Step]: started
[2017-12-01 01:06:41][INFO][mode: settings][stage: integrity check][step: Stores Step]: started
[2017-12-01 01:06:41][INFO][mode: settings][stage: data migration][step: Settings Step]: started
[2017-12-01 01:06:41][INFO][mode: settings][stage: data migration][step: Stores Step]: started
[2017-12-01 01:06:41][INFO][mode: settings][stage: volume check][step: Stores Step]: started
[2017-12-01 01:06:41][INFO][mode: settings][stage: volume check][step: Stores Step]: Migration completed

Then I ran

php bin/magento migrate:data --reset /home/user/public_html/dev/mage3/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.0/config.xml

it has a lot of REDs

[2017-12-01 02:25:56][ERROR]: Foreign key (FK_CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID) constraint fails. Orphan records id: 121 from `catalog_eav_attribute`.`attribute_id` has no referenced records in `eav_attribute`
[2017-12-01 02:25:56][ERROR]: Foreign key (FK_CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID) constraint fails. Orphan records id: 121 from `catalog_product_entity_int`.`attribute_id` has no referenced records in `eav_attribute`
[2017-12-01 02:25:56][ERROR]: Foreign key (FK_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID) constraint fails. Orphan records id: 121 from `eav_entity_attribute`.`attribute_id` has no referenced records in `eav_attribute`

---- SOME OF WHATS INSIDE HERE ARE FROM OLD THEME----

[2017-12-01 02:25:58][ERROR]: Source documents are not mapped: buyshoparallax,buyshopflex,buyshoprevolution,jmmegamenu,jmmegamenu_store_menugroup,jmmegamenu_types,magebird_mousetracking,magebird_mousetracking_popup,magebird_popup,magebird_popup_category,magebird_popup_content,magebird_popup_country,magebird_popup_customer_group,magebird_popup_notcountry,magebird_popup_notreferral,magebird_popup_page,magebird_popup_product,magebird_popup_referral,magebird_popup_store,magebird_popup_subscriber,magebird_popup_template,magenotification,magenotification_extension_feedback,magenotification_extension_feedbackmessage,magenotification_license,magenotification_log,tm_core_module
[2017-12-01 02:25:58][ERROR]: Destination documents are not mapped: magefan_blog_category,magefan_blog_category_store,magefan_blog_comment,magefan_blog_post,magefan_blog_post_category,magefan_blog_post_relatedpost,magefan_blog_post_relatedproduct,magefan_blog_post_store,magefan_blog_post_tag,magefan_blog_tag,nwdthemes_revslider_animations,nwdthemes_revslider_backup,nwdthemes_revslider_css,nwdthemes_revslider_navigations,nwdthemes_revslider_options,nwdthemes_revslider_sliders,nwdthemes_revslider_slides,nwdthemes_revslider_static_slides

--------------------------------------------------------------------------------------
[2017-12-01 02:25:58][ERROR]: Source fields are not mapped. Document: salesrule_coupon. Fields: is_popup,user_ip,popup_cookie_id

[Migration\Exception]
Integrity Check failed

[LanthopusX]

You're most likely missing your outer xml:

<?xml version="1.0" encoding="UTF-8"?>
<!--
/**
* Copyright © 2013-2017 Magento, Inc. All rights reserved.
* See COPYING.txt for license details.
*/
-->
<config xmlns:xs="http://www.w3.org/2001/XMLSchema-instance" xs:noNamespaceSchemaLocation="../../config.xsd">
 --------- INSERT YOUR XML HERE ------------------
</config>