I am using magento data migration tool. When i try to run this code,
php bin/magento migrate:data C:\xampp\htdocs\budgetpharmacy_test\vendor\magento\data-migration-tool\etc\ce-to-ce\22.214.171.124\config.xml
It returns this error
[ERROR]: Source fields are not mapped. Document: customer_eav_attribute. Fields: is_used_for_customer_segment
There were other errors and I used map.xml to ignore them but it is not working for this error. I added this code block in my map.xml
<ignore> <field>customer_eav_attribute.is_used_for_customer_segment</field> </ignore>
But the error is still there. How can I fix this error?
Are you 100% sure that all the mappings for the migration are implemented?
It seems that some mappings are still pending and that should the reason why that error is returned.
I am having same problem.
there are two part in map.xml file one in
and one in
so please check if you add correct part.
Please let me know if you still get issue. I will support free.
While experimenting with the data migration tool, I run into the same issue.
I installed the sample data for 126.96.36.199, setup Magento 2.1.4 without data, and tried migrating data from 188.8.131.52 to 2.1.4
I run into two issues:
[ERROR] Foreign key(FK_CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID) constraint fails. Orphan records id: 121,164 from `catalog_eav_attribute`.`attribute_id` has no referenced records in `eav_attribute`
[ERROR]: Foreign key (FK_CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID) constraint fails. Orphan records id: 121 from `catalog_product_entity_int`.`attribute_id` has no referenced records in `eav_attribute`[0m
[0;31m[2017-02-20 15:35:52][ERROR]: Foreign key (FK_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID) constraint fails. Orphan records id: 121,163,164 from `eav_entity_attribute`.`attribute_id` has no referenced records in `eav_attribute`
AND the aforementioned error with customer_eav_attribute.is_used_for_customer_segment which will NOT be ignored in spite of me entering it in the relevant source section. ( Adding it to the destionation section doesn't work either btw )
Now if anyone can tell me how to resolve these issues, I'd be delighted.
So the trick was that the ignore field definition had to be included in the file map-eav.xml
Of course ::rolls-eyes::
Oh well, that solves that problem, now how to solve the key-constraint issue?