cancel
Showing results for 
Search instead for 
Did you mean: 

Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

SOLVED

Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

So i have been trying to migrate data from 1.9.2.2 CE to 2.1.0 CE, using Ubuntu 16.04, mariadb 10.1.14, php 7, i have the map.xml configured, 

 

here is the progress i get 

 

 

[2016-08-11 17:18:19][INFO][mode: data][stage: integrity check][step: EAV Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:20][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:20][INFO][mode: data][stage: integrity check][step: Map Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:24][WARNING]: Mismatch of data types. Source document: importexport_importdata. Fields: behavior
[2016-08-11 17:18:24][WARNING]: Mismatch of data types. Destination document: importexport_importdata. Fields: behavior
[2016-08-11 17:18:24][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:24][INFO][mode: data][stage: integrity check][step: Log Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:24][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:24][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:24][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:25][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:25][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:25][INFO][mode: data][stage: integrity check][step: PostProcessing Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:25][INFO][mode: data][stage: setup triggers][step: Stage]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:18:26][INFO][mode: data][stage: data migration][step: EAV Step]: started
28% [========>-------------------] Remaining Time: 1 sec

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

 

and then the above error

 

if I run it right after it again, with out changing anything, here is the error as well

 

[2016-08-11 17:25:33][INFO][mode: data][stage: integrity check][step: EAV Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:33][INFO][mode: data][stage: integrity check][step: Customer Attributes Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:33][INFO][mode: data][stage: integrity check][step: Map Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][WARNING]: Mismatch of data types. Source document: importexport_importdata. Fields: behavior
[2016-08-11 17:25:38][WARNING]: Mismatch of data types. Destination document: importexport_importdata. Fields: behavior
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: Url Rewrite Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: Log Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: Ratings Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: ConfigurablePrices step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: OrderGrids Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: Tier Price Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: SalesIncrement Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: integrity check][step: PostProcessing Step]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:38][INFO][mode: data][stage: setup triggers][step: Stage]: started
100% [============================] Remaining Time: 1 sec
[2016-08-11 17:25:40][INFO][mode: data][stage: data migration][step: EAV Step]: started
14% [====>-----------------------] Remaining Time: 1 sec


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


some help will be appreciated.

 

Thanks

 

David

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

Here is what i have found that worked for me.

 

..

If you see your M1 database that you are going to migrate to magento2 there will be “Default” attribute set duplicated.
So, at the end the solution is delete your all “Default” attribute set from your M1 “eav_attribute_set” table. And then start your migration to fresh blank Magento2 database

View solution in original post

8 REPLIES 8

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

Looks like a few people have had this issue before.

 

Instead of reinventing the wheel, take a look at these links:

https://github.com/magento/data-migration-tool/issues/10

http://magento.stackexchange.com/questions/92578/data-migration-eav-step-error

https://github.com/magento/data-migration-tool/issues/49

-Kris
4x Certified, Blogger @ xgento.com

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

Thanks, for me, there must have been some type of database changes done, so i reinstalled magento again, fresh database, and ir work 

 

Thanks for the response.

 

I have another issue in the delta process now, so another post i go.

 

 

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

and i also went down to version 2.0.7 to make it work.

 

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

I would go directly to 2.0.9

-Kris
4x Certified, Blogger @ xgento.com

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

That didn't seem to work either. plus i could not install the data migration tools on version 2.0.9 through composer as it said something about not a stable enough version or something ( i forgot to capture the screen error)

 

 

so i tried a brand new install. magento 2.1.0. no sample data, clean. and this is the error it get after setting up the map and config file

 

[Exception]
Notice: Undefined offset: 13 in /opt/bitnami/apps/magento/htdocs/vendor/magento/data-migration-tool/src/Migration/Step/Eav/Data.php on line 433

 

Its driving me bonkers.

Man Frustrated

 

 

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

Here is what i have found that worked for me.

 

..

If you see your M1 database that you are going to migrate to magento2 there will be “Default” attribute set duplicated.
So, at the end the solution is delete your all “Default” attribute set from your M1 “eav_attribute_set” table. And then start your migration to fresh blank Magento2 database

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

Yep this works

Re: Error Upgrading from 1.9.2.2 to 2.1.0 - Notice: Undefined offset: in Data.php line 209

Hi There I am having same problem I tried the suggestion it didn't work.

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

when I look in Magento 2 DB eav_attribute_set table has migrated everything.

and the second message:

Integrity constraint violation: 1062 Duplicate entry '1-Migration_Default' for key 'EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME'

 

Can you please or anyone else help me out Please! thank you.