delta migration step 7 showing errors

13 answers

Profile photo of Mall Staff 184060.00 $tone June 28, 2018
Public

Hi there,

http://prntscr.com/k0du0z
http://prntscr.com/k0dud8

That issue because you have deleted at least one sales rule (data in table salesrule_coupon) after the first migration.
To solve that issue, let’s do steps below:
+ Run below SQL in M2 database:

DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule' AND m2_id NOT IN (Select rule_id From salesrule);
DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule_coupon' AND m2_id NOT IN (Select coupon_id From salesrule_coupon);

+ Once done, clean the cache of our tool by run command: rm -rf pub/ub-tool/protected/runtime/cache/
And then, continue with data migration in the step #7.
Regards,
Mall.

#1
Profile photo of Mall Staff 184060.00 $tone June 30, 2018
Public

Hi there,

but again its https://prnt.sc/k12bfx

That is another issue. That because you have checked to ‘KEEP ORIGINAL IDs’ checkbox in settings in step #7 of our tool and you have created at least one sales rules in back-end of M2.
To solve that, you must delete the sales rule which you have created in back-end.
And then, you could continue with data migration in the step #7 by run command:
php -f bin/ubdatamigration run --step=7
(note: don’t run with update mode now)
Regards,
Mall.

#3
Profile photo of Mall Staff 184060.00 $tone July 2, 2018
Public

Hi there,

I followed your comment. but then i face this error http://prntscr.com/k1gy0y

That issue was because you had deleted both migrated sales rule items. Hence you need to re-follow all steps as suggested in my reply #1. 

Regards,
Mall.

#5
Profile photo of Mall Staff 184060.00 $tone July 3, 2018
Public

Hi there,

how can I prevent timeout 
http://prntscr.com/k1vcin

For that case, you still could continue with run below CLI command:
php -f bin/ubdatamigration run --step=7
And you should contact to your hosting provider to get more help about the timeout issue.
Regards,
Mall.

#7
Profile photo of Mall Staff 184060.00 $tone July 3, 2018
Public

Hi there,

order  is never increasing in delta migration.https://prnt.sc/k1vf21 

That is strange. Let’s provide me information about your instance:
+ Admin credentials and URL to back-end
+ SSH credentials and path to Magento folder
I will help to check further and reply you more later.
Regards,
Mall.

#9
Profile photo of Mall Staff 184060.00 $tone July 3, 2018
Public

Hi there,

 http://prntscr.com/k1yici

That issue because you have deleted at least one product option after the first migration. To solve that you could do steps below:
+ Step 1: Run below SQL statement in M2 database:

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);

+ Step 2: Clean the cache of our tool by run command: rm -rf pub/ub-tool/protected/runtime/cache/
And then, you could continue with data migration in the step #5 by run CLI command:
php -f bin/ubdatamigration run --step=5
Regards,
Mall.

#11
Profile photo of Mall Staff 184060.00 $tone July 4, 2018
Public

Hi there,

again its http://prntscr.com/k2btd1

This refers to another issue. That was because you had deleted at least one product after the first migration with our tool. To continue, you can do these steps:
+ Step 1: Run the SQL statement below 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);

+ Step 2: Clean the cache of our tool by running the command: rm -rf pub/ub-tool/protected/runtime/cache/
And then, you could continue with data migration in the step #5 using the CLI command:
php -f bin/ubdatamigration run --step=5

can you please run detla migration form your end?

Please handle the migration at your end. If you run across any issue, please get back to me here, I will help you out. 
Regards,
Mall.

#13

Please login or Register to Submit Answer

Written By

Comments