Back to Questions Page

Delta migration not syncronizing customers

0 Comment July 10, 2020
Vote Up
0
Vote Down
Answered
Public
Technical Question
Profile photo of copsbhu9971 copsbhu9971 asked July 10, 2020

Dear Customer support,
I am trying to delta migrate customer but it says that is complete without migrating all the changes on magento 1 database.
Could you please advise me ?
Thanks

17 answers

Vote Up
0
Vote Down
Profile photo of ubdev ⋅ Staff ⋅98150.00 $tone July 10, 2020
Public

Hi there, 
 
We wonder you run the delta migration from our module’s dashboard (GUI mode) or via CLI mode. 
Depending on which changes you want to delta migrate, you should select the delta mode properly:  

  • GUI mode only if you migrate newly added data from your Magento 1 to Magento 2.
  • If you migrate both newly added data and modified data from your Magento 1 to Magento 2 since the first migration, you need to perform the delta migration with the CLI mode (using the --mode=update parameter).

Please try to run the delta once again following our Readme manual. If there’s any error notice, please do let us know here. 
 
PS. Since our team is off during the weekend, our apology for a certain delay in response if you reach out to us during this time. 
 
Regards,
Ubertheme team 

#1
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone July 10, 2020
Public

Hi there,

I am trying to delta migrate customer but it says that is complete without migrating all the changes on magento 1 database.

Please try with these steps:

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

Update ub_migrate_map_step_6 Set created_time = '2000-01-01 00:00:00' Where entity_name = 'customer_entity';

2. And then you run the delta migration in step #6 by running the CLI command:
php -f bin/ubdatamigration run --step=6 --mode=update;

Then check the issue you mentioned and let me know how it goes.
 
Regards,
Mall.

#3
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone July 13, 2020
Public

Hi there,

i ‘ve tried that but is not synchronizing customers.

Please check again to make sure that you did reindex the data successfully after you finished the data migration in step #6.

Regards,
Mall.

#5
Vote Up
0
Vote Down
Profile photo of copsbhu9971 ⋅130.00 $tone July 13, 2020
Public

Hi,
I ‘ve run the delta migration again and it stopped with following error:

.PHP Error[2]: Creating default object from empty value
in file /home/hofbnew/web/pub/ub-tool/protected/controllers/Step6Controller. php at line 567
#0 /home/hofbnew/web/pub/ub-tool/protected/controllers/Step6Controller.php(425): Step6Controller->_migrateCustomerAddressEntity()
#1 /home/hofbnew/web/pub/ub-tool/protected/controllers/Step6Controller.php(170): Step6Controller->_migrateCustomers()
#2 /home/hofbnew/web/pub/ub-tool/protected/commands/RunCommand.php(74): Step6Con troller->actionRun()
#3 /home/hofbnew/web/pub/ub-tool/protected/commands/RunCommand.php(33): RunComma nd->_migrateData()
#4 unknown(0): RunCommand->actionIndex()
#5 /home/hofbnew/web/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): Re flectionMethod->invokeArgs()
#6 /home/hofbnew/web/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71 ): RunCommand->run()
#7 /home/hofbnew/web/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#8 /home/hofbnew/web/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsole Application->processRequest()
#9 /home/hofbnew/web/pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->r un()
#10 /home/hofbnew/web/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_ once()

Thanks

#6
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone July 13, 2020
Public

Hi there,

.PHP Error[2]: Creating default object from empty value
in file /home/hofbnew/web/pub/ub-tool/protected/controllers/Step6Controller. php at line 567

Please try with the steps below:

+ Run the following SQL queries in your M2 database:

DELETE FROM ub_migrate_map_step_6 WHERE entity_name = 'customer_group' AND m2_id NOT IN (Select customer_group_id From customer_group);
DELETE FROM ub_migrate_map_step_6 WHERE entity_name = 'customer_entity' AND m2_id NOT IN (Select entity_id From customer_entity);
DELETE FROM ub_migrate_map_step_6_customer_address WHERE entity_name = 'customer_address_entity' AND m2_id NOT IN (Select entity_id From customer_address_entity);

+ And then, you can continue with the data migration in step #6 as normal.

Regards,
Mall.

#7
Vote Up
0
Vote Down
Profile photo of copsbhu9971 ⋅130.00 $tone July 22, 2020
Public

Dear customer support,
I am trying the below solution as you suggested.

Please try with these steps:

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

Update ub_migrate_map_step_6 Set created_time = '2000-01-01 00:00:00' Where entity_name = 'customer_entity';

2. And then you run the delta migration in step #6 by running the CLI command:
php -f bin/ubdatamigration run --step=6 --mode=update;

Every time doing that, the extension is synchronizing 100 new customers and after that it stops.
 
Could you advise me?
 
Thanks

#8
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone July 22, 2020
Public

Hi there,

Every time doing that, the extension is synchronizing 100 new customers and after that it stops.

Do you see any related error messages?
Regards,
Mall.

#9
Vote Up
0
Vote Down
Profile photo of copsbhu9971 ⋅130.00 $tone July 22, 2020
Public

There is not error message. Just the following:

[Processing][delta] Step #6 migration completed with 100 Customers
Step #6 migration completed successfully
Total Data Migrated: 86%

Thanks

#10
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone July 22, 2020
Public

Hi there,

There is not error message. Just the following:

So, please try to reindex the data and check the issue you mentioned once again. 

Regards,
Mall.

#11
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone July 22, 2020
Public

Hi there,

So, please provide me information of your instance:

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

I will help to check further and get back you to then.
PS. Please make sure you mark your reply private or simply switch this ticket to the private mode, then it’s safe to share your site info here. Only you and our technical team can access it. 
Regards,
Mall.

#14
Vote Up
0
Vote Down
Profile photo of magepulsar ⋅50.00 $tone December 11, 2020
Public

Solution :
 
Change ‘{$lastMigrationTime}’ by “real last Migration Time” and not date script execution : {$lastMigrationTime}

if ($this->runMode == UBMigrate::RUN_MODE_DELTA) {
    $lastMigrationTime = UBMigrate::getLastMigrationTime($this->stepIndex, 'customer_entity');
    $condition .= " AND updated_at >= '{$lastMigrationTime}'";
}


 

if ($this->runMode == UBMigrate::RUN_MODE_DELTA) {
    $lastMigrationTime = UBMigrate::getLastMigrationTime($this->stepIndex, 'customer_entity');
    $condition .= " AND updated_at >= '2020-12-25 00:00:00'";
}

#16
Vote Up
0
Vote Down
Profile photo of ubdev ⋅ Staff ⋅98150.00 $tone December 14, 2020
Public

Hi Magepulsar, 
 
If the workaround worked for your case, please continue with that.


$condition .= ” AND updated_at >= ‘2020-12-25
00:00:00′”;

This indicates that you fixed a DateTime value, however, our module gets dynamic DateTime in accordance with the latest run time of the data migration.
 
Besides, please note that with the value you fixed `2020-12-25 00:00:00, no data records will meet that value. That means no new data records were migrated in the delta migration phase.
 
Regards,
Ubertheme team

#17

Please login or Register to Submit Answer

Written By

Further Reading

Comments