magento / magento/data-migration-tool

M1.9.* to M2.4 Notice: Undefined offset: 19

Open
#855 4 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Dominant language
PHP
Stars
339
Forks
195
PR merge metrics
No merged PRs in 30d

Description

Hi, I would like migrate Magento 1.9.3 to Magento 2.4.0 and I managed without problems with 2 recent ecommerce with the same version. With this multilingual ecommerce which has been updated from version 1.4. * up to now I am having problems.

I follow the correct procedure to migrate, as I did for the other sites, I don't make changes to files to ignore tables or attributes but I get this:
`sudo php bin/magento migrate:data -a -vvv vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.0/config.xml

[2020-10-20 15:36:11][INFO][mode: data][stage: integrity check][step: Data Integrity Step]: started
[2020-10-20 15:36:11][INFO][mode: data][stage: integrity check][step: EAV Step]: started
100% [============================] Remaining Time: < 1 sec
[2020-10-20 15:36:11][WARNING]: Incompatibility in data. Source document: eav_attribute. Field: frontend_input. Error: Attribute with attribute_id=1038 cannot contain empty field value
[2020-10-20 15:36:11][WARNING]: Incompatibility in data. Source document: eav_attribute. Field: source_model. Error: Class metarobots/product_attribute_source_unit is not mapped in record attribute_id=1001
[2020-10-20 15:36:11][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
[2020-10-20 15:36:11][INFO][mode: data][stage: integrity check][step: Map Step]: started
100% [============================] Remaining Time: < 1 sec
[2020-10-20 15:36:14][WARNING]: Source documents are not mapped: am_acart_attribute,am_acart_blacklist,am_acart_canceled,am_acart_history,am_acart_quote2email,am_acart_rules,am_acart_schedule,apptrian_imageoptimizer_files,aw_blog,aw_blog_cat,aw_blog_cat_store,aw_blog_comment,aw_blog_post_cat,aw_blog_store,aw_blog_tags,belvg_facebook_customer,belvg_twitter_customer,buyshoparallax,buyshopflex,buyshoprevolution,deal_deal,deal_deal_product,deal_deal_store,ess__backup_v5_config,m2epro__backup_v5_amazon_account,m2epro__backup_v5_amazon_listing,m2epro__backup_v5_amazon_listing_product,m2epro__backup_v5_amazon_template_description,m2epro__backup_v5_amazon_template_general,m2epro__backup_v5_amazon_template_selling_format,m2epro__backup_v5_amazon_template_synchronization,m2epro__backup_v5_attribute_set,m2epro__backup_v5_buy_listing,m2epro__backup_v5_buy_listing_product,m2epro__backup_v5_buy_template_description,m2epro__backup_v5_buy_template_general,m2epro__backup_v5_buy_template_selling_format,m2epro__backup_v5_buy_template_synchronization,m2epro__backup_v5_config,m2epro__backup_v5_ebay_account_store_category,m2epro__backup_v5_ebay_listing,m2epro__backup_v5_ebay_listing_product,m2epro__backup_v5_ebay_listing_product_variation,m2epro__backup_v5_ebay_marketplace,m2epro__backup_v5_ebay_message,m2epro__backup_v5_ebay_template_description,m2epro__backup_v5_ebay_template_general,m2epro__backup_v5_ebay_template_general_calculated_shipping,m2epro__backup_v5_ebay_template_general_payment,m2epro__backup_v5_ebay_template_general_shipping,m2epro__backup_v5_ebay_template_general_specific,m2epro__backup_v5_ebay_template_selling_format,m2epro__backup_v5_ebay_template_synchronization,m2epro__backup_v5_listing,m2epro__backup_v5_listing_category,m2epro__backup_v5_listing_product,m2epro__backup_v5_listing_product_variation,m2epro__backup_v5_play_listing,m2epro__backup_v5_play_listing_product,m2epro__backup_v5_play_template_description,m2epro__backup_v5_play_template_general,m2epro__backup_v5_play_template_selling_format,m2epro__backup_v5_play_template_synchronization,m2epro__backup_v5_template_description,m2epro__backup_v5_template_general,m2epro__backup_v5_template_selling_format,m2epro__backup_v5_template_synchronization,m2epro__backup_v5_translation_custom_suggestion,m2epro__backup_v5_translation_language,m2epro__backup_v5_translation_text,m2epro__backup_v608_ebay_template_shipping,m2epro__backup_v611_ebay_order,m2epro__backup_v611_ebay_order_item,m2epro_account,m2epro_amazon_account,m2epro_amazon_dictionary_category,m2epro_amazon_dictionary_category_product_data,m2epro_amazon_dictionary_marketplace,m2epro_amazon_dictionary_shipping_override,m2epro_amazon_dictionary_specific,m2epro_amazon_item,m2epro_amazon_listing,m2epro_amazon_listing_auto_category_group,m2epro_amazon_listing_other,m2epro_amazon_listing_product,m2epro_amazon_listing_product_variation,m2epro_amazon_listing_product_variation_option,m2epro_amazon_marketplace,m2epro_amazon_order,m2epro_amazon_order_item,m2epro_amazon_processed_inventory,m2epro_amazon_template_description,m2epro_amazon_template_description_definition,m2epro_amazon_template_description_specific,m2epro_amazon_template_selling_format,m2epro_amazon_template_shipping_override,m2epro_amazon_template_shipping_override_service,m2epro_amazon_template_synchronization,m2epro_buy_account,m2epro_buy_dictionary_category,m2epro_buy_item,m2epro_buy_listing,m2epro_buy_listing_auto_category_group,m2epro_buy_listing_other,m2epro_buy_listing_product,m2epro_buy_listing_product_variation,m2epro_buy_listing_product_variation_option,m2epro_buy_marketplace,m2epro_buy_order,m2epro_buy_order_item,m2epro_buy_template_new_product,m2epro_buy_template_new_product_attribute,m2epro_buy_template_new_product_core,m2epro_buy_template_selling_format,m2epro_buy_template_synchronization,m2epro_cache_config,m2epro_config,m2epro_ebay_account,m2epro_ebay_account_store_category,m2epro_ebay_dictionary_category,m2epro_ebay_dictionary_marketplace,m2epro_ebay_dictionary_motor_ktype,m2epro_ebay_dictionary_motor_specific,m2epro_ebay_dictionary_shipping,m2epro_ebay_feedback,m2epro_ebay_feedback_template,m2epro_ebay_item,m2epro_ebay_listing,m2epro_ebay_listing_auto_category_group,m2epro_ebay_listing_other,m2epro_ebay_listing_product,m2epro_ebay_listing_product_variation,m2epro_ebay_listing_product_variation_option,m2epro_ebay_marketplace,m2epro_ebay_order,m2epro_ebay_order_external_transaction,m2epro_ebay_order_item,m2epro_ebay_template_category,m2epro_ebay_template_category_specific,m2epro_ebay_template_description,m2epro_ebay_template_other_category,m2epro_ebay_template_payment,m2epro_ebay_template_payment_service,m2epro_ebay_template_return,m2epro_ebay_template_selling_format,m2epro_ebay_template_shipping,m2epro_ebay_template_shipping_calculated,m2epro_ebay_template_shipping_service,m2epro_ebay_template_synchronization,m2epro_listing,m2epro_listing_auto_category,m2epro_listing_auto_category_group,m2epro_listing_log,m2epro_listing_other,m2epro_listing_other_log,m2epro_listing_product,m2epro_listing_product_variation,m2epro_listing_product_variation_option,m2epro_lock_item,m2epro_locked_object,m2epro_marketplace,m2epro_migration_v6,m2epro_operation_history,m2epro_order,m2epro_order_change,m2epro_order_item,m2epro_order_log,m2epro_order_matching,m2epro_primary_config,m2epro_processing_request,m2epro_product_change,m2epro_registry,m2epro_stop_queue,m2epro_synchronization_config,m2epro_synchronization_log,m2epro_system_log,m2epro_template_description,m2epro_template_selling_format,m2epro_template_synchronization,m2epro_wizard,magemonkey_api_debug,magemonkey_async_orders,magemonkey_async_subscribers,magemonkey_bulksync_export,magemonkey_bulksync_import,magemonkey_ecommerce360,magemonkey_last_order,magemonkey_mails_sent,paypalauth_customer,plumbase_product,plumrocket_sociallogin_account,recaptcha,rewardpoints_account,rewardpoints_catalogrules,rewardpoints_flat_account,rewardpoints_pointrules,rewardpoints_referral,rewardpoints_referralrules,rewardpoints_rule,sfc_googleauthor,simplegoogleshopping,sm_cameraslide_slide,sm_cameraslide_sliders,sm_dynamic_animation,sm_dynamic_css,sm_dynamic_sliders,sm_dynamic_slides,sm_menu_groups,sm_menu_items,sm_shopby_attribute_url_key,smtppro_email_log,tiny_compressimages_image,tiny_compressimages_totals,watchlog,wordpress_association,wordpress_association_type
[2020-10-20 15:36:14][WARNING]: Destination documents are not mapped: gift_message
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: cms_page. Fields: google_author_id,meta_robots
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: newsletter_subscriber. Fields: subscriber_firstname,subscriber_lastname
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: sales_flat_creditmemo. Fields: cod_fee,base_cod_fee,cod_tax_amount,base_cod_tax_amount
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: sales_flat_invoice. Fields: cod_fee,base_cod_fee,cod_tax_amount,base_cod_tax_amount,rewardpoints_gathered,rewardpoints_description,rewardpoints_quantity,base_rewardpoints,rewardpoints,rewardpoints_referrer,rewardpoints_cart_rule_text
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: sales_flat_order. Fields: cod_fee,base_cod_fee,cod_fee_invoiced,base_cod_fee_invoiced,cod_tax_amount,base_cod_tax_amount,cod_tax_amount_invoiced,base_cod_tax_amount_invoiced,cod_fee_refunded,base_cod_fee_refunded,cod_tax_amount_refunded,base_cod_tax_amount_refunded,cod_fee_canceled,base_cod_fee_canceled,cod_tax_amount_canceled,base_cod_tax_amount_canceled,ebizmarts_abandonedcart_flag,ebizmarts_magemonkey_campaign_id,rewardpoints_description,rewardpoints_quantity,base_rewardpoints,rewardpoints,rewardpoints_referrer,rewardpoints_gathered,rewardpoints_cart_rule_text
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: sales_flat_order_item. Fields: rewardpoints_gathered,rewardpoints_used,rewardpoints_catalog_rule_text,rewardpoints_gathered_float,discount_before_rewards,base_discount_before_rewards
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: sales_flat_quote. Fields: cod_fee,base_cod_fee,cod_tax_amount,base_cod_tax_amount,ebizmarts_abandonedcart_counter,ebizmarts_abandonedcart_flag,ebizmarts_abandonedcart_token,rewardpoints_description,rewardpoints_quantity,base_rewardpoints,rewardpoints,rewardpoints_referrer,rewardpoints_gathered,rewardpoints_cart_rule_text
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: sales_flat_quote_address. Fields: cod_fee,base_cod_fee,cod_tax_amount,base_cod_tax_amount
[2020-10-20 15:36:14][WARNING]: Source fields are not mapped. Document: sales_flat_quote_item. Fields: rewardpoints_gathered,rewardpoints_used,rewardpoints_catalog_rule_text,rewardpoints_gathered_float,discount_before_rewards,base_discount_before_rewards
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: Log Step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: integrity check][step: Inventory Step]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: setup triggers][step: Stage]: started
[2020-10-20 15:36:14][INFO][mode: data][stage: data migration][step: EAV Step]: started
71% [====================>-------] Remaining Time: < 1 sec
In ErrorHandler.php line 61:

[Exception]
Notice: Undefined offset: 19 in vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 446
`
after this error, in this period, I tried to completely
1) delete the external modules;
2) delete the tables of the deletes module;

but the modifications of these modules to the original tables remained, such as rewardpoints, googleauthor ...

Thanks

@magento I am working on this

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the reported command, `sudo php bin/magento migrate:data -a -vvv vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.0/config.xml`, and inspect `vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php` around line 446. Use the EAV migration step and the reported `Undefined offset: 19` as the failure boundary; done means the migration no longer stops at this error.

Written by the indexing model from the issue text.

Assessment

Tech stack
php
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
28/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.