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

[daschenbrener]

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

[kab8609]

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

[gymstar]

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.

[gymstar]

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

[kab8609]

I would go directly to 2.0.9

[gymstar]

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.

[gymstar · Accepted solution]

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

[daschenbrener]

Yep this works

[JUV_LANO]

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.