magento / data-migration-tool

Magento Data Migration Tool
https://devdocs.magento.com/guides/v2.3/migration/bk-migration-guide.html
Open Software License 3.0
334 stars 200 forks source link

Migrate 1.9.2.4 to 2.3 problems #795

Closed ce8 closed 4 years ago

ce8 commented 4 years ago

Hi,

I am trying to migrate my magento store from 1.9.2.4 to 2.3.

I have both databases on the same mysql instance (localhost) and I'm using Linux Centos 7.

After installing both databases and installing Magento 2.3, I installed the magento migrate data tool (magento 2.3).

When I run the command below, nothing is migrated to the magento 2 database.

bin/magento migrate:data -a vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.2.4/config.xml

100% [============================] Remaining Time: < 1 sec [2020-02-10 21:16:37][WARNING]: Foreign key (FK_INDEX_PROCESS_EVENT_EVENT_ID_INDEX_EVENT_EVENT_ID) constraint fails on source database. Orphan records id: 18,21,24,1147 from index_process_event.event_id has no referenced records in index_event

100% [============================] Remaining Time: < 1 sec [2020-02-10 21:16:39][WARNING]: Source documents are not mapped: blog_category_entity,blog_category_entity_datetime,blog_category_entity_int,blog_category_entity_text,blog_category_entity_varchar,blog_category_post,blog_category_post_index,blog_comment,blog_eav_attribute,blog_post_entity,blog_post_entity_datetime,blog_post_entity_int,blog_post_entity_text,blog_post_entity_varchar,blog_post_link,blog_post_link_attribute,blog_post_link_attribute_int,blog_post_link_type,blog_tag,blog_tag_post,blog_url_rewrite,correios_postmethods,customer_flowpassword,customer_id_span,em_minislideshow_slider,flexibleblock_eav_attribute,flexibleblock_entity,flexibleblock_entity_datetime,flexibleblock_entity_int,flexibleblock_entity_text,flexibleblock_entity_varchar,label_css_entity,label_css_entity_text,label_eav_attribute,label_entity,label_entity_int,label_entity_text,label_entity_varchar,megamenupro,paybox_question_number,pmabookmark,pmacentral_columns,pmacolumn_info,pma__designer_settings,pmaexport_templates,pmafavorite,pmahistory,pmanavigationhiding,pmapdf_pages,pmarecent,pmarelation,pmasavedsearches,pmatable_coords,pmatable_info,pma__table_uiprefs,pmatracking,pmauserconfig,pmausergroups,pma__users,recentreviewproducts,smtppro_email_log,social_facebook_actions,strikeiron_tax_rate,themeframework_area,themeframework_area_store,themeframework_design_change_theme,themeframework_page,themeframework_page_store,themeframework_theme,tiny_compressimages_image,tiny_compressimages_totals

100% [============================] Remaining Time: < 1 sec [2020-02-10 21:16:39][WARNING]: Mismatch of entities in the document: sales_order_grid Source: 64 Destination: 0 [2020-02-10 21:16:39][WARNING]: Mismatch of entities in the document: sales_invoice_grid Source: 28 Destination: 0 [2020-02-10 21:16:39][WARNING]: Mismatch of entities in the document: sales_shipment_grid Source: 35 Destination: 0 [2020-02-10 21:16:39][WARNING]: Mismatch of entities in the document: sales_creditmemo_grid Source: 12 Destination: 0 [2020-02-10 21:16:39][WARNING]: Volume Check failed

[2020-02-10 21:16:39][INFO][mode: data][stage: data migration][step: PostProcessing Step]: Migration completed

How I can solve it?

victor-v-rad commented 4 years ago

Hi @ce8 You can see the last message 'Migration completed' It means everything migrated but there were some issues on the way. You can read this Migration Troubleshooting for more information about the errors you got

ce8 commented 4 years ago

Hi Tks,

I have read the Migration Troubleshooting before open the question.

But my problem is the same!

Can you help me?

victor-v-rad commented 4 years ago

Run bin/magento cron:run command twice and sales grids should be filled with data

ce8 commented 4 years ago

bin/magento cron:run

In WebsiteRepository.php line 110:

The website with id 1 that was requested wasn't found. Verify the website and try again.

ce8 commented 4 years ago

?????

arnair-incomm commented 4 years ago

@ce8 Please restart your migration process. This may involve setup:uninstall, setup:install and then run the migration tool again.

aruntechguy commented 4 years ago

@ce8 Also, please don't forget to update your map.xml file with above fields.