SQL state Duplicate entry when delta step 5

Hi there,

1062 Duplicate entry ‘10859’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_bundle_option_value` (`value_id`, `option_id`, `store_id`, `parent_product_id`, `title`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4)

You can try with steps as following to solve that issue:
1. Run the followings SQLs in your M2 database:

Delete From catalog_product_entity Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_5 where entity_name = 'catalog_product_entity');
Delete From catalog_product_entity_varchar Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_5 where entity_name = 'catalog_product_entity');
Delete From catalog_product_entity_text Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_5 where entity_name = 'catalog_product_entity');
Delete From catalog_product_entity_int Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_5 where entity_name = 'catalog_product_entity');
Delete From catalog_product_entity_decimal Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_5 where entity_name = 'catalog_product_entity');
Delete From catalog_product_entity_datetime Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_5 where entity_name = 'catalog_product_entity');
Delete From tax_class Where class_type='PRODUCT' AND class_id NOT IN (Select m2_id From ub_migrate_map_step_5 where entity_name = 'tax_class');
Delete From downloadable_link Where link_id NOT IN (Select m2_id From ub_migrate_map_step_5_product_download where entity_name = 'downloadable_link');
Delete From catalog_product_option Where option_id NOT IN (Select m2_id From ub_migrate_map_step_5_product_option where entity_name = 'catalog_product_option');
Delete From catalog_product_bundle_option Where option_id NOT IN (Select m2_id From ub_migrate_map_step_5_product_option where entity_name = 'catalog_product_bundle_selection');
Delete From catalog_product_option_type_price Where option_type_price_id NOT IN (Select m2_id From ub_migrate_map_step_5_product_option where entity_name = 'catalog_product_option_type_price');

2. And then, you continue with data migration in step #5
And tell me to know how it goes. 
Regards,
Mall.
 
 

Hi there,

Error: Call to undefined method stdClass::save() in /home/customer/www/xxx.com/public_html/pub/ub-tool/protected/controllers/Step5Controller.php:1741

Please tell me to know what is the version of our module in your instance?
Regards,
Mall.

Hi there,
So, you can try with steps as following:
1. Run the following SQLs in your M2 database:

DELETE FROM ub_migrate_map_step_5 WHERE entity_name = 'catalog_product_entity' AND m2_id NOT IN (Select entity_id From catalog_product_entity);
DELETE FROM ub_migrate_map_step_5_product_option WHERE entity_name = 'catalog_product_option' AND m2_id NOT IN (Select option_id From catalog_product_option);
DELETE FROM ub_migrate_map_step_5_product_option WHERE entity_name = 'catalog_product_option_type_value' AND m2_id NOT IN (Select option_type_id From catalog_product_option_type_value);
DELETE FROM ub_migrate_map_step_5_product_option WHERE entity_name = 'catalog_product_option_type_price' AND m2_id NOT IN (Select option_type_price_id From catalog_product_option_type_price);
DELETE FROM ub_migrate_map_step_5_product_option WHERE entity_name = 'catalog_product_bundle_option' AND m2_id NOT IN (Select option_id From catalog_product_bundle_option);
DELETE FROM ub_migrate_map_step_5_product_option WHERE entity_name = 'catalog_product_bundle_selection' AND m2_id NOT IN (Select selection_id From catalog_product_bundle_selection);

2. Clean the cache of our module by run command: rm -rf pub/ub-tool/protected/runtime/cache/
3. You continue with data migration in step #5.
Regards,
Mall.

Hi Mikko,

1062 Duplicate entry ‘10914’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_bundle_option_value` (`value_id`, `option_id`, `store_id`, `parent_product_id`, `title`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4)

You can try with these steps:
1. Run the following SQL query in your M2 database:

Delete From catalog_product_bundle_option_value Where value_id = 10914;

2. And then, you continue with the data migration in step #5.

Regards,
Mall.
 

Hi there,

1062 Duplicate entry ‘263539’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_address_entity` (`is_active`, `entity_id`, `parent_id`,

You can try these steps:
1. Run the following SQL query in your M2 database:

Delete From customer_address_entity Where entity_id = 263539;

2. And then, you continue with the data migration in step #6.

Regards,
Mall.

Hi Mikko,

So I´m stuck…
Any idea how to proceed? 

Please try with these steps:

1. Run the following SQL query in your M2 database:

UPDATE `ub_migrate_map_step_5` SET `created_time` = '2000-01-01 00:00:00' Where entity_name = 'catalog_product_entity';

2. And then you run the delta migration in step #5 with the ‘update’ mode by running the CLI command:

php -f bin/ubdatamigration run --step=5 --mode=update;

And then reindex the data and check the issue you mentioned. And tell me how it goes.

Regards,
Mall.