data-migration-tool: Migration from 1.8.1.0 stuck at map step step: table: catalog_product_entity_varchar]:

Preconditions

  1. Migration from Magento 1.8.1.0 to Magento 2.3.3 and 2.3.5(both have same error)
  2. tried #812 it was related to that. but m1 table "catalog_product_entity_varchar " has thousands of more Value as NULL

Steps to reproduce

  1. Data Migration -> Map Step

Expected result

  1. it should avoid all issues and complete the migration

Actual result

  1. [2020-05-28 08:38:58][INFO][mode: data][stage: data migration][step: Map Step]: started [2020-05-28 08:39:01][DEBUG][mode: data][stage: data migration][step: Map Step][table: adminnotification_inbox]: migrating [2020-05-28 08:39:13][DEBUG][mode: data][stage: data migration][step: Map Step][table: captcha_log]: migrating [2020-05-28 08:39:16][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_category_entity]: migrating [2020-05-28 08:39:18][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_category_entity_datetime]: migrating [2020-05-28 08:39:20][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_category_entity_decimal]: migrating [2020-05-28 08:39:23][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_category_entity_int]: migrating [2020-05-28 08:39:25][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_category_entity_text]: migrating [2020-05-28 08:39:34][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_category_product]: migrating [2020-05-28 08:39:40][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_category_product_index]: migrating [2020-05-28 08:40:08][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_compare_item]: migrating [2020-05-28 08:40:11][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_bundle_option]: migrating [2020-05-28 08:40:13][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_bundle_option_value]: migrating [2020-05-28 08:40:15][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_bundle_selection]: migrating [2020-05-28 08:40:17][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_bundle_selection_price]: migrating [2020-05-28 08:40:19][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity]: migrating [2020-05-28 08:40:28][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity_datetime]: migrating [2020-05-28 08:40:37][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity_decimal]: migrating [2020-05-28 08:40:53][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity_gallery]: migrating [2020-05-28 08:40:55][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity_int]: migrating [2020-05-28 08:41:55][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity_media_gallery]: migrating [2020-05-28 08:42:13][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity_text]: migrating [2020-05-28 08:42:24][DEBUG][mode: data][stage: data migration][step: Map Step][table: catalog_product_entity_varchar]: migrating

Additional notes

this is not completing migration at all.

Hope @victor-v-rad can help

Thanks

About this issue

Most upvoted comments

Then you will need to fill those attributes (required values) in your database with values, for at least catalogproduct_entity_varchar, catalogproduct_entity_text, catalogproduct_entity_* tables etc.

I see. i will check and i will update you how it goes,