Questions tagged [data-migration]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
0answers
17 views

Magento2.3.3 Facing Error during Data migration

I am trying to migartion from Magneto1.9.3.10 to Magento2.3.3 but I am facing error during [Eav Step] data migration like: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does ...
0
votes
3answers
882 views

Data Migration error In magento 2 intergrity constraint violation : duplicate entry :1-Migration_Default

Error : SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-Migration_Default' for key 'EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME' I reinstall the setup with a fresh ...
0
votes
2answers
30 views

Data Migration Tool Removing Already Exist Values Of Magento2 Database

I want know that data migration tool working with fresh database or with already exist values in Magento2.
0
votes
3answers
240 views

cannot connect to mysql on remote server

I am trying to migrate data from magento 1 to maganto 2. Both sites are on different server. So when I try to migrate by below command : sudo php /var/www/m2.gocleaning.nl/bin/magento migrate:...
0
votes
0answers
18 views

Magento data migration 1.9 to 2.3 Integrity Check failed error

After successfully completed migrate:settings, php bin/magento migrate:settings --reset vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.2.3/config.xml getting error while ...
0
votes
1answer
31 views

Processing stopped during data migration

Processing stopped during data migration. I don't know how to fix it. Could you tell me? Command executed: php bin/magento migrate:data vendor/magento/data-migration-tool/etc/opensource-to-...
0
votes
0answers
27 views

what is the steps migration data separate in same magento2 source?

I would like to migration separate data like customer, sales, quote, product, custom table from current magento2.2 to another source magento2.2. Can anyone give me step by step or guide? many thank.
0
votes
2answers
705 views

how to run the settings migration command?

how to run the setting migration command in macOS? http://devdocs.magento.com/guides/v2.0/migration/migration-migrate-settings.html my current command looks like this but getting error: [Migration\...
0
votes
0answers
26 views

Magento 2.3.3 | Order data migration - This order no longer exists

I was facing problem in order's data migration, sales order grid was showing empty after data migration process. I followed this link's answers in order to fix it. Now order grid datas are showing but ...
0
votes
1answer
19 views

Migrating data from Magento 2.1 to Magento 2.3 on a new server

I want to migrate customer, order and product information from Magento 2.1 site (old server) to a brand new install of a Magento 2.3 site (new server). What is the easiest and most effective way to ...
1
vote
4answers
69 views

Magento 2 data migration triggers table missing in M1

We have successfully migrated data from M1 to M2 using the data migration tool. We have a custom table called md_cybersource which is mapped to magedelight_cybersource in map.xml When we run delta ...
0
votes
1answer
24 views

How to migrate Product custom options records from magento 1.7 to magento 2.x in product edit, order, invoice,Shipment and Credit memo?

I looking for the migrate Product custom options records from magento 1.7 to magento 2.x I have have migrated all the data from magento 1.7 to magento 2.2.6, but custom options not showing.
1
vote
1answer
53 views

Magento 2 Reorder functionality missing for migrated orders

We have migrated customers and orders data from M1 (1.14.3.1 EE) to M2 (2.3.1 commerce) successfully But when we are doing testing at the admin end for the orders found that the Reorder button was ...
3
votes
1answer
37 views

What is use of direct_document_copy in data migration config.xml

I have recently migrate M1 DB to M2 DB there is option in config.xml called direct_document_copy <!-- Set direct_document_copy = 1 for better performance. NOTE: 'source' and 'destination'...
1
vote
1answer
35 views

Magento 1 to 2 data migration issue: “cart price rules” are missing website and group selection from Magento 1

After migrating data from magento 1.6.2 to magento 2.3.2 the shopping cart price rules are missing the website and groups selection. For some reason the first 4 shopping cart price rules are not ...
1
vote
0answers
50 views

How migrate products from Magento database 1.9 to 2.3.2?

I migrate data from Magento 1.9 to Magento 2.3.2, after that customer adds new products to 1.9, so I'm in trouble. I have a database with new products that were added at Magento 1.9, but I don't know ...
2
votes
1answer
155 views

Data migration tool : How can i use time zone handler for order purchase time for magento 1 server on IST timezone

I use the tool for migrate my data from my 1.9.2.4 to magento2.2.2 It works except a problem with date of purchase. There is a difference of 5:30 hours, however the time zone on M1 Server is IST (...
1
vote
2answers
68 views

Magento 2 Data Migration time difference?

We have migrated M1 customers and orders from M2.3.1 successfully with the datamigration tool but we are facing some discrepancy with the time differences. The best example is customer create_at &...
1
vote
2answers
37 views

disable or remove foreign keys during upgrade

During upgrade from v1.5.1.0 to v1.6.0 it is trying to drop a key but can't because of a foreign key. relevant lines in update script $installer->getConnection()->dropIndex( $installer->...
1
vote
1answer
45 views

Categories mapping when migrate from Magento 1 to Magento 2

Can anyone tell me whether it's possible to have a migration with categories mapping on migration for magento 1 to magento 2 and how can I do this?
0
votes
3answers
718 views

Magento 2.2.3: Merging error in data migration tool

Acutally, We migrated our data once but now most of development has done. So, i need to merge new data in existing database. I fired migrate:delta command but gives error: Deltalog for customer_entity ...
1
vote
2answers
61 views

Magento2.3.2 During data migration I got Only enties mismatch error . Only orders data in not migrated

My migration is from Magento 1.9.1.0 to Magento 2.3.2. I ran the below command : php -dmemory_limit=-1 bin/magento migrate:data vendor/magento/data-migration-tool/etc/opensource-to-opensource/1....
1
vote
0answers
53 views

Magento 2 migration issue with payment transaction id

We are able to migrate data successfully with sales payment transaction table. map.xml <transform> <field>sales_payment_transaction.additional_information</field> ...
1
vote
0answers
42 views

Magento 2: After migration, Customer reindex is not working

This is the issue I face on indexing from terminal. column 'created_in' used in key specification without a key length, query was: CREATE TABLE IF NOT EXISTS `customer_grid_flat` Kindly help me to ...
1
vote
1answer
46 views

Data migration tool auto add prefix

When I launch data migration tool, I encounter the following error : SQLSTATE[42S02]: Base table or view not found: 1146 Table 'm1.prefix_core_directory_storage' doesn't exist ... My old magento don'...
3
votes
1answer
43 views

Magento 2: No data migration tool matching version

My Magento version is 2.2.9. No matching data migration tool exists. What should I do? Should I install Magento version 2.2.7?
1
vote
1answer
36 views

Attribute set is missing after upgrade to magento 2.2.9 from 2.2.6 which is migrated website from magento 1.x

I had migrated Magento 1 website to Magento 2.2.6, so after some days i had upgraded my Magento version to 2.2.9, after upgrade i can see that my attributes sets are missing and when i checked into ...
1
vote
0answers
26 views

Magento 2 data migration custom handler?

We are working on data migration using Magento 2 data migration tool. We would like to know how to write a custom handler for customer Id (or) product id. Could you please advise did any work on this....
1
vote
0answers
74 views

Can I migrate from Magento 1.9 to 2.0 when my site crashed?

My site on Magento has crashed, then the next day my hosting company said that there was an error somewhere with coding so I'm thinking now is the time to move from Magento 1.9 to 2.0. I set up the ...
1
vote
1answer
32 views

Magento 2 - indexer error after data migration magento 1.9.1.1 to 2.3.2

I'm trying to migrate data to magento 2 using the data migration tool, the migration goes fine but the indexor crash during catalog_product_price index with the error : SQLSTATE[42000]: Syntax ...
1
vote
2answers
52 views

Magento 2 - Mirasvit RMA data migration from M1 to M2

We have migrated products, customers and orders details from M1 to M2 using https://devdocs.magento.com/guides/v2.3/migration/migration-tool-install.html now we would like to migrate RMA Mirasvit data ...
1
vote
1answer
72 views

How to migrate email templates only from M1 to Magento 2?

We have installed migration tool in Magento 2.3.1 EE (composer require Magento/data-migration-tool:2.3.1 ) would like to migrate M1 commerce edition (1.14.3.1) to Magento 2.3.1 EE. We have migrated ...
4
votes
3answers
2k views

Magento 2.1.7 customer login issue

when I try to log in as a customer to shop I got notice error: "An unspecified error occurred. Please contact us for assistance." When I register as a new customer to shop it seems to work ok - ...
1
vote
0answers
86 views

Magento 2 data migration errors how to solve

We have installed migration tool in the Magento 2.3.1 EE (composer require magento/data-migration-tool:2.3.1 ) would like migrate M1 commerce edition (1.14.3.1) to Magento 2.3.1 EE. When we execute ...
2
votes
0answers
246 views

Magento 2 customer data migration & volume check failed?

I would like to migrate only customers data using magento2 data migration tool. Can anyone suggest how to resolve the below error when migrating data [2019-08-06 12:20:19][INFO][mode: data][stage: ...
0
votes
1answer
926 views

Element 'block', attribute 'class': 'about-us' is not a valid value of the atomic type 'blockClassType'

I migrated M1 data to M2 using ubertheme data migration pro. When I install a theme to my site and load the home page, I am getting the following exception: 1 exception(s): Exception #0 (...
2
votes
3answers
375 views

Data Migration not procceds after Map Step

ubuntu@ip-172-31-32-129:/var/www/magento$ sudo php bin/magento migrate:data -r vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.3.1/config.xml Reset the current position of ...
1
vote
0answers
42 views

Magento 2 - Data Migration needs to ignore a custom table

Need to ignore a table from data migration, the table name is "store" where its a default table in Magento 2. Even updated the map.xml to ignore the store table by below code under document_rules ...
1
vote
1answer
17 views

Copying Customers/Orders between Magento installations

I need to copy a subset of customers and orders from one Magento installation to another. While copying new entity IDs must be assigned thus existing ones are not overwritten. What would be your ...
1
vote
1answer
39 views

Magento 2.3.1 Merge products from one database to another?

I have a staging and a production server for my Magento 2.3.1 project. The two databases have different data and configurations, so I can not just dump the mysql db and restore it. Is there a way to ...
1
vote
1answer
95 views

Error 'Mismatch of data types…' printed during data migration to Magento 2

The following error was output during data migration to Magento 2. If you receive such an error, which file would you like to edit? Also, please tell me how to write. Mismatch of data types. Source ...
2
votes
1answer
22 views

An exception was printed during migration, but I don't know what it means

An exception was printed to the console during migration. Please tell me what you mean. My migration procedure is as follows. 1.Installed Magento version 2.2.6. 2.The application and database were ...
1
vote
0answers
319 views

Undefined offset: 150 in /vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 813

Preconditions source: magento 1.9.3.10 destination: Magento 2.2.6 3rd party extensions installed Steps to reproduce php bin/magento migrate:data -r -a vendor/magento/data-migration-tool/...
1
vote
0answers
32 views

About Problems Migrating Data From Magento 1.9.2.1 to Magento 2.2 .6

Magento 1.9.2.1 to Magento 2.2.6 encountered an error with EAV during the data migration process. The error is as follows. Notice: Undefined offset: 151 in /var/www/html/tertiary/vendor/magento/data-...
1
vote
1answer
175 views

Delta migration error in magento 2

I am working on magento migration using default magento migration tool. Followed all the steps and migrated data successfully. I followed the below procedure to migrate data: Took the dump of M1 ...
1
vote
1answer
60 views

Migrate Static Blocks and multi stores from One Magento to Another

What is the best way to migrate Magento Content i.e Blocks, Pages, and All content from one Magento instance to another. I have 2 Magento setups. One of which has all data and another is fresh Magento....
3
votes
1answer
143 views

Magento 2: Data migration Class error

I tried to migrate data from Magento 1.9.2.2 to Magento 2.2.2 for testing. I am getting below error [2018-02-14 11:45:37][INFO][mode: data][stage: volume check][step: EAV Step]: started 100% [====...
1
vote
1answer
91 views

Data migration tool installation error Magento 2.3

I am facing below error when try to install data migration tool from command line. I have fresh magento installation and I am trying to install data migration tool from repo.magento.com and ...
0
votes
2answers
75 views

migration Magento 1.9 to Magento 2.3

how to solve this error. I'm using GoDaddy server In Abstract.php line 144: SQLSTATE[28000] [1045] Access denied for user 'glamaa_mg4'@'localhost' (using password : YES) In Abstract.php line 128: ...
1
vote
2answers
117 views

Is it possible to copy all customer related data migrate to another magento 2 database?

I want to know how I can copy only customer related data to another Magento 2 database If it is possible then what are the tables that I can copy to the second DB Magento ver 2.2.6