Delta migration fail

Hello
I made full migration 2 weeks ago, and now I try to make delta migration to steps 5-8. But delta fails errors in thep 7 and 8:
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘setting_data’ at row 1. The SQL statement executed was: UPDATE `ub_migrate_step` SET `id`=:yp0, `title`=:yp1, `code`=:yp2, `status`=:yp3, `setting_data`=:yp4, `start_at`=:yp5, `end_at`=:yp6, `descriptions`=:yp7, `sorder`=:yp8 WHERE `ub_migrate_step`.`id`=7
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column ‘setting_data’ at row 1. The SQL statement executed was: UPDATE `ub_migrate_step` SET `id`=:yp0, `title`=:yp1, `code`=:yp2, `status`=:yp3, `setting_data`=:yp4, `start_at`=:yp5, `end_at`=:yp6, `descriptions`=:yp7, `sorder`=:yp8 WHERE `ub_migrate_step`.`id`=8
After that I change “setting_data” field type to long_blob. I run delta migration again, but it does not made anything. How I can run delta migrate again for new products, orders and etc from steps 5 to 8 which are new in last two weeks ??
 
Regards,
Ari
 

15 answers

Profile photo of Mall Staff 180840.00 $tone December 7, 2021
Public

Hi there,

After that I change “setting_data” field type to long_blob. 

Did you save the configuration in step #7 successfully after that change?
If yes, to delta migration in step #7, you simply run the CLI command:

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

And you can do the same way on other steps which you want to delta migration.
Regards,
Mall.

#1
Profile photo of apelix 250.00 $tone December 7, 2021
Public

Hello
Here is the results:
STEP 5 -> error:
php bin/ubdatamigration run --step=5 --limit=2 --mode=update
[Processing][delta] in step #5: ……………………………………………………………………………………………………………………………………………………………………………………..
[Processing][delta] Step #5 migration completed with 2 record(s) in the ‘catalog_product_entity’ table.
PHP Error[2]: Creating default object from empty value
in file /var/www/magento2/pub/ub-tool/protected/controllers/Step5Controller.php at line 657
#0 /var/www/magento2/pub/ub-tool/protected/controllers/Step5Controller.php(187): Step5Controller->_migrateCatalogProducts()
#1 /var/www/magento2/pub/ub-tool/protected/commands/RunCommand.php(80): Step5Controller->actionRun()
#2 /var/www/magento2/pub/ub-tool/protected/commands/RunCommand.php(36): RunCommand->_migrateData()
#3 unknown(0): RunCommand->actionIndex()
#4 /var/www/magento2/pub/ub-tool/yii-1.1.22/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#5 /var/www/magento2/pub/ub-tool/yii-1.1.22/console/CConsoleCommandRunner.php(71): RunCommand->run()
#6 /var/www/magento2/pub/ub-tool/yii-1.1.22/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#7 /var/www/magento2/pub/ub-tool/yii-1.1.22/base/CApplication.php(185): CConsoleApplication->processRequest()
#8 /var/www/magento2/pub/ub-tool/yii-1.1.22/yiic.php(33): CConsoleApplication->run()
#9 /var/www/magento2/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#10 /var/www/magento2/bin/ubdatamigration(4): require_once()
STEP 6 -> working, import new customers
STEP 7 -> does not import new orders
 
Regards, Ari
 

#2
Profile photo of Mall Staff 180840.00 $tone December 8, 2021
Public

Hi there,

[Processing][delta] Step #5 migration completed with 2 record(s) in the ‘catalog_product_entity’ table.
PHP Error[2]: Creating default object from empty value

You can solve the issue by the following these steps:
1. Run CLI command:

php -f bin/ubdatamigration clean --step=5;

2. Continue with the delta migration in step #5 by running CLI command:

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

STEP 7 -> does not import new orders

How did you run the delta migration in step #7? Please try again by running the following CLI command:

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

 
Regards,
Mall.

#3
Profile photo of apelix 250.00 $tone December 8, 2021
Public

Hello
 
I run step 5 like that, but I lost all changes ( url and descriptions) which I have done last week. So I run it like that:
php -f bin/ubdatamigration clean --step=5;
php -f bin/ubdatamigration run --step=5 --startDate=’2021-11-14′ --endDate=’2021-12-08′
Now it is working.
 
About step 7, it does not work. I run like this:
php -f bin/ubdatamigration run --step=7 --mode=update --startDate=’2021-11-14′ --endDate=’2021-12-08′
And i got this error:
 
PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /var/www/magento2/pub/ub-tool/protected/controllers/Step7Controller.php at line 2237
#0 /var/www/magento2/pub/ub-tool/protected/controllers/Step7Controller.php(1795): Step7Controller->_migrateSalesQuoteAddress()
#1 /var/www/magento2/pub/ub-tool/protected/controllers/Step7Controller.php(1631): Step7Controller->_migrateSalesQuote()
#2 /var/www/magento2/pub/ub-tool/protected/controllers/Step7Controller.php(310): Step7Controller->_migrateSalesOrders()
#3 /var/www/magento2/pub/ub-tool/protected/commands/RunCommand.php(80): Step7Controller->actionRun()
#4 /var/www/magento2/pub/ub-tool/protected/commands/RunCommand.php(36): RunCommand->_migrateData()
#5 unknown(0): RunCommand->actionIndex()
#6 /var/www/magento2/pub/ub-tool/yii-1.1.22/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#7 /var/www/magento2/pub/ub-tool/yii-1.1.22/console/CConsoleCommandRunner.php(71): RunCommand->run()
#8 /var/www/magento2/pub/ub-tool/yii-1.1.22/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#9 /var/www/magento2/pub/ub-tool/yii-1.1.22/base/CApplication.php(185): CConsoleApplication->processRequest()
#10 /var/www/magento2/pub/ub-tool/yii-1.1.22/yiic.php(33): CConsoleApplication->run()
#11 /var/www/magento2/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#12 /var/www/magento2/bin/ubdatamigration(4): require_once()
 
What I can do for this error ?
 
Ari
 
 
 

#4
Profile photo of Mall Staff 180840.00 $tone December 8, 2021
Public

Hi there,

PHP Error[8]: Trying to get property ‘attributes’ of non-object…

To solve that issue you can try with steps as the following:
1. Run the CLI command:

php -f bin/ubdatamigration clean --step=7;

2. And then, you continue with delta migration in step #7:

php -f bin/ubdatamigration run --step=7;

Regards,
Mall.
 
 

#5
Profile photo of apelix 250.00 $tone December 8, 2021
Public

It start working after running 

php -f bin/ubdatamigration clean --step=7;

And 

php -f bin/ubdatamigration run --step=7 --mode=update --startDate='2021-11-15'

It does not work without --mode=update option.

#6
Profile photo of Mall Staff 180840.00 $tone December 9, 2021
Public

Hi,

It does not work without --mode=update option.

Yes, you can continue with the ‘update’ mode in step #7
Please contact me if you need further assistance.
 

Regards,
Mall.

#7
Profile photo of apelix 250.00 $tone December 10, 2021
Public

Hello
 
I made one new product and run step 5 delta. In the log show that product is imported, but it does not come admin side. Here is the log:
 
[Processing][run] in step #5: ……………………………………………………………………………………………………………………
[Processing][run] Step #5 migration completed with 1 record(s) in the ‘catalog_product_entity’ table.
Step #5 migration completed successfully
Total Data Migrated: 100%
I check database and last imported product is three days old. There is no new entries in the table “catalog_product_entity”. How to fix this ? New products are not written the database.
 
Ari

#8
Profile photo of Mall Staff 180840.00 $tone December 10, 2021
Public

Hi there,

[Processing][run] Step #5 migration completed with 1 record(s) in the ‘catalog_product_entity’ table.
Step #5 migration completed successfully
Total Data Migrated: 100%
I check database and last imported product is three days old. There is no new entries in the table “catalog_product_entity”. How to fix this ? New products are not written the database.

That is certainly strange. Can you please recheck the database configuration in the config file of our module at this path: 
pub/ub-tool/protected/config/db.php
and make sure that the M2 database credentials are the same as the current M2 database credentials of your M2 instance.
 

Regards,
Mall.

#9
Profile photo of apelix 250.00 $tone December 10, 2021
Public

Yes it is correct. Same happen for orders, the last order is from wednesday. But the customer accounts I can import, all of them are received to M2 side.

#10
Profile photo of Mall Staff 180840.00 $tone December 10, 2021
Public

Hi there,

Yes it is correct. Same happen for orders, the last order is from wednesday. 

Very strange indeed. Can you please try again to delta migration in step #5 and step #7 by running the following CLI commands:

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

Once done, you can run delta migration in step #7:

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

Then please check for the issue that you mentioned again and let me know how it goes.
 

Regards,
Mall.

#11
Profile photo of apelix 250.00 $tone December 10, 2021
Public

About startDate option, is it working with step 5 ?
How I can be sure that it does not overwrite our products changes  ?
Is there any option that I see which products it is updating ?

#13
Profile photo of Mall Staff 180840.00 $tone December 10, 2021
Public

Hi there,

 But I can try it with startDate option.

Yes, please try with that option at your end.

About startDate option, is it working with step 5 ?

Yes.

How I can be sure that it does not overwrite our products changes  ?

You need to make sure that you don’t change the information of the migrated products in M2 which are related to M1 products in the date ranges you set in the CLI command.
 

Regards,
Mall.

#14

Please login or Register to Submit Answer

Written By

Comments