Magento Data Migration Tool

We completed the migration successfully. When we try to do the delta changes we get the below warnings. And the delta changes were not at all carried out for the entities (orders, invoices, shipments, returns, credits, customers, transactions, reviews).

[2017-06-08 10:29:26][INFO][mode: delta][stage: delta delivering][step: Custom Customer Attributes Step]: started [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: Custom Customer Attributes Step]: started [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_order [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_order_address [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_quote [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_quote_address [2017-06-08 10:29:26][WARNING]: Volume Check failed [2017-06-08 10:29:26][INFO][mode: delta][stage: delta delivering][step: Customer Attributes Step]: started [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: Customer Attributes Step]: started [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: customer_entity [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: customer_entity_int [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: customer_entity_text [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: customer_entity_varchar [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: customer_address_entity [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: customer_address_entity_int [2017-06-08 10:29:26][WARNING]: Volume Check failed [2017-06-08 10:29:26][INFO][mode: delta][stage: delta delivering][step: Map Step]: started [2017-06-08 10:29:26][INFO][mode: delta][stage: delta delivering][step: Log Step]: started [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: Log Step]: started [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: customer_visitor [2017-06-08 10:29:26][WARNING]: Volume Check failed [2017-06-08 10:29:26][INFO][mode: delta][stage: delta delivering][step: SalesOrder Step]: started [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: SalesOrder Step]: started [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: sales_order [2017-06-08 10:29:26][WARNING]: Volume Check failed [2017-06-08 10:29:26][INFO][mode: delta][stage: delta delivering][step: OrderGrids Step]: started [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: OrderGrids Step]: started [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: sales_order_grid [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: sales_invoice_grid [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: sales_shipment_grid [2017-06-08 10:29:26][WARNING]: Mismatch of entities in the document: sales_creditmemo_grid [2017-06-08 10:29:26][WARNING]: Volume Check failed [2017-06-08 10:29:26][INFO][mode: delta][stage: delta delivering][step: SalesIncrement Step]: started [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: started [2017-06-08 10:29:26][WARNING]: Mismatch in last increment id of order entity [2017-06-08 10:29:26][WARNING]: Mismatch in last increment id of invoice entity [2017-06-08 10:29:26][WARNING]: Mismatch in last increment id of creditmemo entity [2017-06-08 10:29:26][WARNING]: Mismatch in last increment id of shipment entity [2017-06-08 10:29:26][WARNING]: Mismatch in last increment id of rma_item entity [2017-06-08 10:29:26][WARNING]: Volume Check failed [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: Migration completed successfully [2017-06-08 10:29:26][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: Automatic restart in 5 sec. Use CTRL-C to abort [2017-06-08 10:29:31][INFO][mode: delta][stage: delta delivering][step: Custom Customer Attributes Step]: started [2017-06-08 10:29:31][INFO][mode: delta][stage: volume check][step: Custom Customer Attributes Step]: started [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_order [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_order_address [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_quote [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: magento_customercustomattributes_sales_flat_quote_address [2017-06-08 10:29:31][WARNING]: Volume Check failed [2017-06-08 10:29:31][INFO][mode: delta][stage: delta delivering][step: Customer Attributes Step]: started [2017-06-08 10:29:31][INFO][mode: delta][stage: volume check][step: Customer Attributes Step]: started [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: customer_entity [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: customer_entity_int [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: customer_entity_text [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: customer_entity_varchar [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: customer_address_entity [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: customer_address_entity_int [2017-06-08 10:29:31][WARNING]: Volume Check failed [2017-06-08 10:29:31][INFO][mode: delta][stage: delta delivering][step: Map Step]: started [2017-06-08 10:29:31][INFO][mode: delta][stage: delta delivering][step: Log Step]: started [2017-06-08 10:29:31][INFO][mode: delta][stage: volume check][step: Log Step]: started [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: customer_visitor [2017-06-08 10:29:31][WARNING]: Volume Check failed [2017-06-08 10:29:31][INFO][mode: delta][stage: delta delivering][step: SalesOrder Step]: started [2017-06-08 10:29:31][INFO][mode: delta][stage: volume check][step: SalesOrder Step]: started [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: sales_order [2017-06-08 10:29:31][WARNING]: Volume Check failed [2017-06-08 10:29:31][INFO][mode: delta][stage: delta delivering][step: OrderGrids Step]: started [2017-06-08 10:29:31][INFO][mode: delta][stage: volume check][step: OrderGrids Step]: started [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: sales_order_grid [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: sales_invoice_grid [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: sales_shipment_grid [2017-06-08 10:29:31][WARNING]: Mismatch of entities in the document: sales_creditmemo_grid [2017-06-08 10:29:31][WARNING]: Volume Check failed [2017-06-08 10:29:31][INFO][mode: delta][stage: delta delivering][step: SalesIncrement Step]: started [2017-06-08 10:29:31][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: started [2017-06-08 10:29:32][WARNING]: Mismatch in last increment id of order entity [2017-06-08 10:29:32][WARNING]: Mismatch in last increment id of invoice entity [2017-06-08 10:29:32][WARNING]: Mismatch in last increment id of creditmemo entity [2017-06-08 10:29:32][WARNING]: Mismatch in last increment id of shipment entity [2017-06-08 10:29:32][WARNING]: Mismatch in last increment id of rma_item entity [2017-06-08 10:29:32][WARNING]: Volume Check failed [2017-06-08 10:29:32][INFO][mode: delta][stage: volume check][step: SalesIncrement Step]: Migration completed successfully

Note: we have not changed anything on the M2 DB post data migration other than adding few custom customer attributes. We tried to initiate the delta migration after a week time.

Please help. We highly rely on this tool.

Preconditions

1. Magento 1 EE 1.14.3.10
2. Magento 2 EE 2.2.6
3. PHP 7.1.22
4. MySQL 5.7.23

Steps to reproduce

1. Migrate data from Magento 1 to 2
2. View a product page

Expected result

1. No error. This error started to occur in Magento EE 2.2.6.

Actual result

1. Errors in system.log and support_report.log

[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '83' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '169' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '501' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '167' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '215' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '220' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '223' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '395' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '402' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '417' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '451' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '452' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:52] report.WARNING: Attempt to load value of nonexistent EAV attribute '551' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '83' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '438' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '167' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '215' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '220' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '221' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '222' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '223' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '269' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '332' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '395' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '402' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '417' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '451' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '452' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []
[2018-10-05 12:40:53] report.WARNING: Attempt to load value of nonexistent EAV attribute '470' 
                        for entity type 'Magento\Catalog\Api\Data\ProductInterface'. [] []

2. But these attributes do in fact exist, for example eav_attribute 83

SELECT attribute_id, entity_type_id, attribute_code, attribute_model, backend_model, backend_type, backend_table, frontend_model, frontend_input, frontend_label, frontend_class, source_model, is_required, is_user_defined, default_value, is_unique, note
FROM magento2_prod.eav_attribute
WHERE attribute_id=83;```

attribute_id entity_type_id attribute_code attribute_model backend_model backend_type backend_table frontend_model frontend_input frontend_label frontend_class source_model is_required is_user_defined default_value is_unique note 83 4 color [NULL] [NULL] int [NULL] [NULL] select Color [NULL] [NULL] 0 1 [NULL] 0 [NULL]

After successful migration (no errors) we have a problem accessing the products grid in the backend with the following error:

SQLSTATE[42000]: Syntax error or access violation: 1103 Incorrect table name '', query was: SELECT COUNT(DISTINCT main_table.attribute_id) FROM eav_attribute AS main_table INNER JOIN eav_entity_type AS entity_type ON main_table.entity_type_id = entity_type.entity_type_id INNER JOIN eav_entity_attribute ON main_table.attribute_id = eav_entity_attribute.attribute_id INNER JOIN ``ASadditional_tableON main_table.attribute_id = additional_table.attribute_id WHERE (entity_type_code= 'catalog_product') AND (additional_table.is_used_in_grid = 1)

All other stuff should be ok and also the products are shown in the frontend.

Hi guys,

I have following the guide to use this tool at http://devdocs.magento.com/guides/v2.0/migration/migration-migrate.html

I have finished the "Migrate settings" step

• Command was run:

php -f /home/qvv/www/_shared/mage2/ce-200-dev/bin/magento migrate:settings -r /home/qvv/www/_shared/mage2/ce-200-dev/vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.2.2/config.xml

But the tool get errors at "Migrate data" step as the screenshots:

• Command was run:

php -f /home/qvv/www/_shared/mage2/ce-200-dev/bin/magento migrate:data /home/qvv/www/_shared/mage2/ce-200-dev/vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.2.2/config.xml

and

Only websites, stores and some configs data was migrated to Magento 2 and no more.

and i can't finished the data migration on this step

Any ideas to solve that issues?

Thanks.

Hi, I am using this data-migration-tool, getting below error, [PDOException] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-Migration_Default' for key 'EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME'

Note: I am migrating datas from magento1.13.1.0 to magento 2.1.0

I have got a error like below,

[ERROR]: Document has ambiguous configuration: sales_flat_quote_payment

I have ignore the table

sales_flat_quote_payment

[PDOException]
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-Migration_Default' for key 'EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME'

[Exception]
Notice: Undefined offset: 1 in vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 261

Hello All,

I am trying to port existing magento 1.9.0.1 to Magento 2.0. I was able to run ./magento migrate:settings (mode) , but when I executed data mode, there were errors

[ERROR]: Source documents are missing or not mapped: amazon_log_api,amazon_log_exception

I have added ignore fields to the file map.xml present in vendor/magento/data-migration-tool/etc/ce-to-ce/1.9.0.1/map.xml

Below is the example I have added,

Even though after making all above mentioned modification, I can see error which says it could not map database I have followed suggestions from this post, but It did not help https://github.com/magento/data-migration-tool-ce/issues/19

Please let me know how to proceed further by adding, particualy, where to add ignore fields, I have added all fields in each table, it would be nice if there is a option to just mention table and all its column would be automatically ignored.

Also, if there are any issues, please let me know, As I am a beginner, please explain me in detail as it would really help me to understand, Appreciate your help, I have tried for a week and was frustrated as I could not find more information,

Looking forward for your response,

I don't now why I can't migrate url_rewrite table with same "request path" value but different store_id. I think this is a bug of this tool. Do you have any idea?

Hi, I'm receiving these errors about "element cannot be added as child to 'sidebar.additional', because the latter doesn't exist".

[2018-02-02 12:20:24] main.INFO: Broken reference: the 'catalog.compare.sidebar' element cannot be added as child to 'sidebar.additional', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'sale.reorder.sidebar' element cannot be added as child to 'sidebar.additional', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'wishlist_sidebar' element cannot be added as child to 'sidebar.additional', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'paypal.partner.right.logo' element cannot be added as child to 'sidebar.additional', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'bml.right.logo' element cannot be added as child to 'sidebar.additional', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'umm.sidemenu.catalog_category_view.main' element cannot be added as child to 'sidebar.main', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'sidebar_main_top_before_laynav' element cannot be added as child to 'sidebar.main', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'umm.sidemenu.catalog_category_view.additional' element cannot be added as child to 'sidebar.additional', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'catalog.leftnav' element cannot be added as child to 'sidebar.main', because the latter doesn't exist [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'umm.sidemenu.catalog_category_view.main' tries to reorder itself towards '', but their parents are different: 'sidebar.main' and '' respectively. [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'sidebar_main_top_before_laynav' tries to reorder itself towards '', but their parents are different: 'sidebar.main' and '' respectively. [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'umm.sidemenu.catalog_category_view.additional' tries to reorder itself towards '', but their parents are different: 'sidebar.additional' and '' respectively. [] [] [2018-02-02 12:20:24] main.INFO: Broken reference: the 'catalog.leftnav' tries to reorder itself towards '', but their parents are different: 'sidebar.main' and '' respectively. [] []

Someone could guide me to fix the issue with my sidebar.main and sidebar.additional? Thanks in advance.

##################### EDIT

I didn't saw this issue at migration until weeks of the installation, so currently my M2 is under production with this bug. As said @victor-v-rad this errors seems not relevant with the issue.

I would try to detail the error:

At BBDD we have all the fields of our megamenu in the categories. You can writte all these fields at database manually, so you are going to see working correctly the "umm" (Universal MegaMenu) at front-end.

The problem is at backend, when you edit any category all the fields at megamenu are going to be deleted.

I have tried to uninstall I have installed the extension, and to install other similar megamenu solutions with the same result.

Without experience at M2 I though that the log file with "umm.sidemenu" was related, but I was wrong.

Hii @victor-v-rad

After migration my products are deleted by mistake and want to migrate only Products , i have tried data migration with "-a " attribute , but products not migrated , can you tell me from which step Products migrate .

Thanks Yogesh

Preconditions

1. Magento 1.9.3.3 open source
2. Magento 2.4.3-p1 open source

Steps to reproduce

1. migrate:data --auto vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.3/config.xml

Expected result

1. Data should be successfully migrated

Actual result

1. Stuck at catalog_product_entity_media_gallery_value with 0%

Additional notes

1. I have already done the data migration previously. Do I have to truncate the entire M2 DB to start the migration again?

Preconditions

1. Magento 1 with tier prices
2. Migration to Magento 2.4.5 (opensource to opensource)
3. PHP 8.1

Steps to reproduce

1. Migrate Magento 1 to Magento 2

Expected result

1. Migration completes successfully

Actual result

Error in the OrderGrids Step:

[2022-12-05T08:22:49.790153+00:00][DEBUG][mode: data][stage: data migration][step: Tier Price Step][table: catalog_product_entity_tier_price]: migrating
0% [>---------------------------] Remaining Time: < 1 sec
In ErrorHandler.php line 62:
                                                                               
  [Exception]                                                                  
  Deprecated Functionality: substr(): Passing null to parameter #1 ($string)   
  of type string is deprecated in /var/www/html/magento/vendor/magento/data-m  
  igration-tool/src/Migration/Handler/SetValue.php on line 35                  
                                                                               

Exception trace:
  at /var/www/html/magento/vendor/magento/framework/App/ErrorHandler.php:62
 Magento\Framework\App\ErrorHandler->handler() at n/a:n/a
 substr() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/Handler/SetValue.php:35
 Migration\Handler\SetValue->handle() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/RecordTransformer.php:126
 Migration\RecordTransformer->applyHandlers() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/RecordTransformer.php:74
 Migration\RecordTransformer->transform() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/Step/TierPrice/Data.php:139
 Migration\Step\TierPrice\Data->perform() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/Mode/AbstractMode.php:82
 Migration\Mode\AbstractMode->runStage() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/Mode/Data.php:124
 Migration\Mode\Data->runData() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/Mode/Data.php:69
 Migration\Mode\Data->run() at /var/www/html/magento/vendor/magento/data-migration-tool/src/Migration/Console/MigrateDataCommand.php:59
 Migration\Console\MigrateDataCommand->execute() at /var/www/html/magento/vendor/symfony/console/Command/Command.php:255
 Symfony\Component\Console\Command\Command->run() at /var/www/html/magento/vendor/magento/framework/Interception/Interceptor.php:58
 Migration\Console\MigrateDataCommand\Interceptor->___callParent() at /var/www/html/magento/vendor/magento/framework/Interception/Interceptor.php:138
 Migration\Console\MigrateDataCommand\Interceptor->Magento\Framework\Interception\{closure}() at /var/www/html/magento/vendor/magento/framework/Interception/Interceptor.php:153
 Migration\Console\MigrateDataCommand\Interceptor->___callPlugins() at /var/www/html/magento/generated/code/Migration/Console/MigrateDataCommand/Interceptor.php:77
 Migration\Console\MigrateDataCommand\Interceptor->run() at /var/www/html/magento/vendor/symfony/console/Application.php:1021
 Symfony\Component\Console\Application->doRunCommand() at /var/www/html/magento/vendor/symfony/console/Application.php:275
 Symfony\Component\Console\Application->doRun() at /var/www/html/magento/vendor/magento/framework/Console/Cli.php:116
 Magento\Framework\Console\Cli->doRun() at /var/www/html/magento/vendor/symfony/console/Application.php:149
 Symfony\Component\Console\Application->run() at /var/www/html/magento/bin/magento:23

Additional notes

The problem is triggered by the map-tier-price.xml.dist configuration

            <transform>
                <field>catalog_product_entity_group_price.value_id</field>
                <handler class="\Migration\Handler\SetValue">
                    <param name="value" value="NULL" />
                </handler>
            </transform>
            <transform>
                <field>catalog_product_entity_tier_price.value_id</field>
                <handler class="\Migration\Handler\SetValue">
                    <param name="value" value="NULL" />
                </handler>
            </transform>

because the Migration\Handler\SetValue class throws an error if NULL should be set:

<?php
/**
 * Copyright © Magento, Inc. All rights reserved.
 * See COPYING.txt for license details.
 */
namespace Migration\Handler;

use Migration\ResourceModel\Record;

/**
 * Handler to set constant value to the field
 */
class SetValue extends AbstractHandler implements HandlerInterface
{
    /**
     * @var string
     */
    protected $value;

    /**
     * @param string $value
     */
    public function __construct($value)
    {
        $this->value = (strtoupper($value) === 'NULL') ? null : $value;
    }

    /**
     * @inheritdoc
     */
    public function handle(Record $recordToHandle, Record $oppositeRecord)
    {
        $this->validate($recordToHandle);
        $valueStored = $recordToHandle->getValue($this->field);
        $operator = substr($this->value, 0, 1);
        $value = substr($this->value, 1);
        switch ($operator) {
            case '+':
                $value = $valueStored + $value;
                break;
            case '-';
                $value = $valueStored - $value;
                break;
            default:
                $value = $this->value;
        }
        $recordToHandle->setValue($this->field, $value);
    }
}

The problem are the lines

        $operator = substr($this->value, 0, 1);
        $value = substr($this->value, 1);

if $this->value is null, since null musn't be used anymore in substr.

As a workaround I changed the lines to

        $operator = substr($this->value ?? '', 0, 1);
        $value = substr($this->value ?? '', 1);

and could finish the migration.

PHP 8.1 compatible. Deprecated usage of function. Giving error in script.

Description

Fixed Issues (if relevant)

1. magento/data-migration-tool#<issue_number>: Issue title
2. ...

Manual testing scenarios

1. ...
2. ...

Contribution checklist

• [ ] Pull request has a meaningful description of its purpose
• [ ] All commits are accompanied by meaningful commit messages
• [ ] All new or changed code is covered with unit/integration tests (if applicable)
• [ ] README.md file is updated and included in the pull request if any README.md predefined sections require an update

Preconditions

1. Magento 1.9.4.5
2. Magento 2.4.5 MySQL 8.0.29, PHP 8.1.10
3. several modules installed

Steps to reproduce

1. install Magento 2.4.5 with data-migration-tool 2.4.5
2. run bin/magento migrate:settings [...]/magento2/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.4.5/config.xml without errors
3. run bin/magento migrate:data [...]/magento2/vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.4.5/config.xml
4. At post processing step 80% getting error: 'Argument#1 must be of type array, null given'

Expected result

1. Expected succesful migration step post processing after all other steps run without errors

Actual result

Stack Trace [2022-09-23T19:57:52.770580+00:00][INFO][mode: data][stage: data migration][step: PostProcessing Step]: started 80% [======================>-----] Remaining Time: < 1 secarray_merge(): Argument #1 must be of type array, null given#0 [...]/magento2/vendor/magento/data-migration-tool/src/Migration/Step/PostProcessing/Data/DeletedRecordsCounter.php(93): array_merge() #1 [...]/magento2/vendor/magento/data-migration-tool/src/Migration/Step/PostProcessing/Data.php(110): Migration\Step\PostProcessing\Data\DeletedRecordsCounter->saveChanged() #2 [...]/magento2/vendor/magento/data-migration-tool/src/Migration/Mode/AbstractMode.php(82): Migration\Step\PostProcessing\Data->perform() #3 [...]/magento2/vendor/magento/data-migration-tool/src/Migration/Mode/Data.php(124): Migration\Mode\AbstractMode->runStage() #4 [...]/magento2/vendor/magento/data-migration-tool/src/Migration/Mode/Data.php(69): Migration\Mode\Data->runData() #5 [...]/magento2/vendor/magento/data-migration-tool/src/Migration/Console/MigrateDataCommand.php(59): Migration\Mode\Data->run() #6 [...]/magento2/vendor/symfony/console/Command/Command.php(255): Migration\Console\MigrateDataCommand->execute() #7 [...]/magento2/vendor/magento/framework/Interception/Interceptor.php(58): Symfony\Component\Console\Command\Command->run() #8 [...]/magento2/vendor/magento/framework/Interception/Interceptor.php(138): Migration\Console\MigrateDataCommand\Interceptor->___callParent() #9 [...]/magento2/vendor/magento/framework/Interception/Interceptor.php(153): Migration\Console\MigrateDataCommand\Interceptor->Magento\Framework\Interception{closure}() #10 [...]/magento2/generated/code/Migration/Console/MigrateDataCommand/Interceptor.php(77): Migration\Console\MigrateDataCommand\Interceptor->___callPlugins() #11 [...]/magento2/vendor/symfony/console/Application.php(1009): Migration\Console\MigrateDataCommand\Interceptor->run() #12 [...]/magento2/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand() #13 [...]/magento2/vendor/magento/framework/Console/Cli.php(116): Symfony\Component\Console\Application->doRun() #14 [...]/magento2/vendor/symfony/console/Application.php(149): Magento\Framework\Console\Cli->doRun() #15 [...]/magento2/bin/magento(23): Symfony\Component\Console\Application->run() #16 {main}

Additional notes

Tried to find information about this error on google without success. Hope, anyone can help me understanding this error and necessary steps to avoid it.

Preconditions

1. Magento 1.9.3.10 to Magento 2.4.5
2. PHP 7.4 & MySQL 8.0.30 - Ubuntu 22.04.1
3. FRESH Magento 2 install

Steps to reproduce

1. Run - composer require magento/data-migration-tool:~2.4.5
2. Create and configure a Migration module in app/code/Vendor/Migration following steps in official docs
3. Check data integrity and add ignores for tables and fields that are flagged as problematic i.e. 3rd party extensions
4. Run - php bin/magento migrate:settings --reset app/code/Vendor/Migration/etc/opensource-to-opensource/1.9.3.10/config.xml

Expected result

[2022-09-08T11:15:47.605990+00:00][INFO][mode: settings][stage: integrity check][step: Settings Step]: started 100% [============================] Remaining Time: < 1 sec [2022-09-08T11:15:47.632163+00:00][INFO][mode: settings][stage: integrity check][step: Stores Step]: started 100% [============================] Remaining Time: < 1 sec [2022-09-08T11:15:47.652288+00:00][INFO][mode: settings][stage: data migration][step: Settings Step]: started 100% [============================] Remaining Time: < 1 sec [2022-09-08T11:15:49.870886+00:00][INFO][mode: settings][stage: data migration][step: Stores Step]: started 100% [>---------------------------] Remaining Time: < 1 sec

Actual result

[2022-09-08T11:15:47.605990+00:00][INFO][mode: settings][stage: integrity check][step: Settings Step]: started 100% [============================] Remaining Time: < 1 sec [2022-09-08T11:15:47.632163+00:00][INFO][mode: settings][stage: integrity check][step: Stores Step]: started 100% [============================] Remaining Time: < 1 sec [2022-09-08T11:15:47.652288+00:00][INFO][mode: settings][stage: data migration][step: Settings Step]: started 100% [============================] Remaining Time: < 1 sec [2022-09-08T11:15:49.870886+00:00][INFO][mode: settings][stage: data migration][step: Stores Step]: started 0% [>---------------------------] Remaining Time: < 1 secReturn value of Migration\ResourceModel\AbstractCollection::key() must be an instance of Migration\ResourceModel\mixed, int returned#0 /var/www/html/magento2/vendor/magento/data-migration-tool/src/Migration/ResourceModel/AbstractCollection.php(69): Migration\ResourceModel\AbstractCollection->key() #1 /var/www/html/magento2/vendor/magento/data-migration-tool/src/Migration/ResourceModel/Destination.php(38): Migration\ResourceModel\AbstractCollection->valid() #2 /var/www/html/magento2/vendor/magento/data-migration-tool/src/Migration/Step/Stores/Data.php(118): Migration\ResourceModel\Destination->saveRecords() #3 /var/www/html/magento2/vendor/magento/data-migration-tool/src/Migration/Mode/AbstractMode.php(82): Migration\Step\Stores\Data->perform() #4 /var/www/html/magento2/vendor/magento/data-migration-tool/src/Migration/Mode/Settings.php(100): Migration\Mode\AbstractMode->runStage() #5 /var/www/html/magento2/vendor/magento/data-migration-tool/src/Migration/Mode/Settings.php(58): Migration\Mode\Settings->runData() #6 /var/www/html/magento2/vendor/magento/data-migration-tool/src/Migration/Console/MigrateSettingsCommand.php(59): Migration\Mode\Settings->run() #7 /var/www/html/magento2/vendor/symfony/console/Command/Command.php(255): Migration\Console\MigrateSettingsCommand->execute() #8 /var/www/html/magento2/vendor/magento/framework/Interception/Interceptor.php(58): Symfony\Component\Console\Command\Command->run() #9 /var/www/html/magento2/vendor/magento/framework/Interception/Interceptor.php(138): Migration\Console\MigrateSettingsCommand\Interceptor->___callParent() #10 /var/www/html/magento2/vendor/magento/framework/Interception/Interceptor.php(153): Migration\Console\MigrateSettingsCommand\Interceptor->Magento\Framework\Interception{closure}() #11 /var/www/html/magento2/generated/code/Migration/Console/MigrateSettingsCommand/Interceptor.php(77): Migration\Console\MigrateSettingsCommand\Interceptor->___callPlugins() #12 /var/www/html/magento2/vendor/symfony/console/Application.php(1009): Migration\Console\MigrateSettingsCommand\Interceptor->run() #13 /var/www/html/magento2/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand() #14 /var/www/html/magento2/vendor/magento/framework/Console/Cli.php(116): Symfony\Component\Console\Application->doRun() #15 /var/www/html/magento2/vendor/symfony/console/Application.php(149): Magento\Framework\Console\Cli->doRun() #16 /var/www/html/magento2/bin/magento(23): Symfony\Component\Console\Application->run() #17 {main}

Additional notes

The error: Return value of Migration\ResourceModel\AbstractCollection::key() must be an instance of Migration\ResourceModel\mixed, int returned

I have not been able to find anything related to this error. Is there a compatibility issue with 2.4.5?

Please advise.

Preconditions

1. From Magento 1.9.0.1
2. To Magento 2.4.4
3. PHP 8.1

Steps to reproduce

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

Expected result

1. Successful migration

Actual result

[2022-08-04T08:44:12.308463+00:00][INFO][mode: data][stage: data migration][step: Map Step]: started 0% [>---------------------------] Remaining Time: < 1 sec In ErrorHandler.php line 61:

Deprecated Functionality: preg_replace(): Passing null to parameter #3 ($subject) of type array|string is deprecated in /var/www/html/vendor/magento/data-migration-tool/src/Migration/Handler/TruncateSuffix.
php on line 93

Additional notes