Migration issue from 1.9 to 2.2.6

[gouri_dash]

Hi,

I am in the process of migrating my M 1.9 store to M 2.2.6. I am using the latest migration tool.

The setting migration went fine with no issue. but the data migration given many errors. I skipped few with -a option.

But now stuck on this below.

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

Any suggestion will be highly appreciated. 

Thanks.

[gelanivishal]

Hello @gouri_dash,

The error from the first screenshot has a hint. You probably migrate data for the second attempt without reverting DB of Magento 2 to its initial state.

Please revert back and try it.

--
If my answer is useful, please Accept as Solution & give Kudos

[gouri_dash]

Thanks a lot that issue got resolved, but started another as below.

[2018-11-25 22:16:38][INFO][mode: data][stage: data migration][step: Map
Step]: started
41% [===========>----------------] Remaining Time: 6 secs
[2018-11-25 22:16:42][ERROR]: Record structure does not contain field
state_code

[Migration\Exception]
Data Migration failed
FYI: I have also tried ( ignore field eav_attribute.state_code) in
the map-eav.xml.dist , but no luck.
[image: image.png]
Can some one help me on this?

[gelanivishal]

Hello @gouri_dash,

Went to eav_attribute table, looked for attribute_id of 556, 557, 584, 585. Found the entity_type_id was 4 for all those. eav_entity_type table says entity_type_id of 4 is entity_type_code "catalog_product". So, same as the included examples in eav-attribute-groups.xml.dist.

eav_attribute table lists the attribute_code for those IDs as ugiftcert_email_template, ugiftcert_email_template_self, ugiftcert_pdf_settings, ugiftcert_conditions.

Resulting xml:

<group name="ignore">
    <attribute type="catalog_product">msrp_enabled</attribute>
    <attribute type="catalog_product">group_price</attribute>
    <attribute type="catalog_product">ugiftcert_email_template</attribute>
    <attribute type="catalog_product">ugiftcert_email_template_self</attribute>
    <attribute type="catalog_product">ugiftcert_pdf_settings</attribute>
    <attribute type="catalog_product">ugiftcert_conditions</attribute>
</group>

 This is an example of data migration process. So you have to add same things for your attribute.

--
If my answer is useful, please Accept as Solution & give Kudos