cancel
Showing results for 
Search instead for 
Did you mean: 

Upgrade from 1.9.3.0 to 2.2.1

Upgrade from 1.9.3.0 to 2.2.1

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

 

error.PNG

 

What could have been the issue?

4 REPLIES 4

Re: Upgrade from 1.9.3.0 to 2.2.1

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.

Re: Upgrade from 1.9.3.0 to 2.2.1

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

If Issue Solved, Click Kudos/Accept As solutions. Get Magento insight from
Magento 2 Blogs/Tutorial

Re: Upgrade from 1.9.3.0 to 2.2.1

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

datamigrate2.PNG

 

 

[Migration\Exception]
Integrity Check faileddatamigrate.PNG

 

Re: Upgrade from 1.9.3.0 to 2.2.1

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>