Delta step 8 missing records

Hello,
i’m not sure it’s related delta migration step 8 only, but we experienced following: when some of products’ reviews in old shop were deleted and new ones added, some of new ones were not delta migrated due to offset setup in ub_migrate_map_step_8 table.
can be this bug is known and could be fixed?
thank you & best regards
Jaro

3 answers

Profile photo of Mall Staff 184060.00 $tone November 29, 2019
Public

Hi Jaro,

Please lets me know what is the version of our UB Data Migration Pro module and the version of your M2 site, I will get back to you then.

Regards,
Mall.

#1
Profile photo of agentandrew 10.00 $tone March 3, 2020
Public

hello Mall,
first of all sorry for late response.
version of our magento installation is 2.3.2 and version of UB Data Migration Pro module is 3.1.9
best regards,
Jaro

#2
Profile photo of Mall Staff 184060.00 $tone March 4, 2020
Public

Hi Jaro,

when some of products’ reviews in old shop were deleted and new ones added, some of new ones were not delta migrated due to offset setup in ub_migrate_map_step_8 table.
can be this bug is known and could be fixed?

Please try to fix that issue with these steps:
+ Run the following SQL query in your M2 database:

Update ub_migrate_map_step_8_review Set created_time = '2000-01-01 00:00:00' and entity_name = 'review';
DELETE FROM ub_migrate_map_step_8_review WHERE entity_name = 'review' AND m2_id NOT IN (Select review_id From review);

+ And then, run the delta migration in step #8:
php -f bin/ubdatamigration run --step=8 --mode=update;
 
Meanwhile, we notice that your subscription has expired for long. Please consider renewing your subscription since our technical support requires active subscription. Further, upgrading to the latest Pro v3.2.3 will help you resolve the issue easier. 

Regards,
Mall.

#3

Please login or Register to Submit Answer

Written By

Comments