Orders IDs skipped during Delta Migration

Hi there,
Please tell me know what is the version of our migration tool in your working now?
If you are using ver.3.1.9 or older versions, you could try with delta migration in step #7 with update mode by run CLI command:
php -f bin/ubdatamigration run --step=7 --mode=update;
Regards,
Mall.

Hi there,

so the version now is 3.2.0 with Magneto 2.3.1

So, please try with steps below:
+ Run the following SQL in your M2 database:

UPDATE `ub_migrate_map_step_7` SET `created_time` = '2019-08-01 00:00:00', `offset` = 0 WHERE `entity_name` = 'sales_flat_order';

+ Once done, run the delta migration in step #7 with the ‘update’ mode by running this command:
 php -f bin/ubdatamigration run --step=7 --mode=update;

And then check the issue you mentioned again.
 
Regards,
Mall.
 

Hi there,
For customers, you could try with steps below:
Run below SQL in your M2 database:

UPDATE `ub_migrate_map_step_6` SET `created_time` = '2019-08-01 00:00:00', `offset` = 0 WHERE `entity_name` = 'customer_entity';

+ Once done run delta migration in step #6:
php -f bin/ubdatamigration run --step=6 --mode=update;
+ And then, reindex the data and clean M2 cache.
Regards,
Mall.

Hi there,
 
Please make sure you run delta migration in step #6 with the ‘update’ mode after you run the SQL as my suggesting.
 
Did you reindex the data successfully when you finished delta with the ‘update’ mode in step #6?
 
Besides, please check once again to make sure you had correct M1 and M2 database credentials by verifying directly the file: pub/ub-tool/protected/config/db.php. 
 
So, please check three points above at your end first. 
 
If you confirm all those points, the issue you mentioned is strange:

 but there are 10 records which were not migrated during delta migration, that is from 23rd, 24th, and 25th of Aug.

Then, I need a closer look on that issue, please provide me information about your instance:

• URL and Admin credentials of your M2 instance
• SSH credentials of your M2 instance
• Let me know the path to your M2 folder
• And let me know phpMyadmin credentials of your M1 and M2 databases

 
PS. Please make sure you share your site info in a private reply, or simply switch this ticket to private mode. Then it’s safe to share your site info here. Only you and our technical team can access.  
 
Regards,
Mall.
 

Hi there,

I checked your instance and saw you already did steps as per suggestion. After checking further into the log of our migration tool, I noticed that you got an error when running the last delta migration in step #6: http://prntscr.com/p13jmc

And I think that is the root cause of missing customers issue that you mentioned. So, you need to solve the duplicated issue first, you can try with steps below:

+ Run this SQL in your M2 database to solve the duplicated issue which happened in the table customer_address_entity as shown in the above screenshot:

Delete From customer_address_entity Where entity_id = 24215;

+ Once done, re-do steps suggested in my reply #5 in this post. 

And then check again the migration log of our tool at: pub/ub-tool/protected/runtime/ub_data_migration.log
And make sure that you have finished delta with the ‘update’ mode step without any error.
 
Regards,
Mall.

Hi there,

PHP Error[2]: Creating default object from empty value
in file /var/www/html/pub/ub-tool/protected/controllers/Step6Controller.php at line 562

Lets run below CLI command:
php -f bin/ubdatamigration clean --step=6
And then, clean the cache of our migration tool by run command:
rm -rf /var/www/html/pub/ub-tool/protected/cache/*
or if you are enabled PHP memcache, you must refresh this cache engine too.
And then, you could continue with delta migration in step #6.
Regards,
Mall.
 

Hi there, 
Glad that it helps. 
If you have any additional question, feel free to get back to us here.
Regards,
Ubertheme team