Error

Hi there,

After the Categories stage, in the “Products” settings for migration, I got the following error:

“Error 500
unserialize(): Error at offset 49148 of 49151 bytes”

Let’s run below SQL statement in your Magento2’s database:

ALTER TABLE `ub_migrate_step` CHANGE `setting_data` `setting_data` LONGBLOB NULL DEFAULT NULL COMMENT 'Settings Data';

And back to step #5 of our tool and tell me know how it goes then.
Regards,
Mall.

Hi there,

I runned the SQL query successfully. I flush cache, but the error still remains exactly the same

Let’s try reset the settings in the steps #4, #5 by run CLI commands:
php -f bin/ubdatamigration reset --step=4
php -f bin/ubdatamigration reset --step=5
And back to settings on these steps and tell me know how it goes.
Regards,
Mall.

Hi there,
Yeah, let’s continue and contact me if you need further assistance.
Regards,
Mall.

Hi there,

1- It says that “Migrate Customer” has finished, but when I go to check the Migrated Customer I see none. 

To see the customer after migrated, you have to reindex your data. 

2- The migration process has freezed at 71%. I tried to “run all steps” again, but it still get stuck at 71% (731 Sales Orders).

I have checked in back-end of your instance. And i don’t see any error message in the log of our tool. And the latest message log of our tool in the step #7 is:

2017/12/31 08:03:55 -- [Processing] Step #7 migration completed with 100 Sales Orders;
2017/12/31 08:04:02 -- [Processing] Step #7 migration completed with 100 Sales Orders;

Let’s continue with data migration in the step #7 by run cli command:
php -f bin/ubdatamigration run --step=7
Regards,
Mall.

Hi there,
Seem your M1’s database has some records with bad data in the sales data section. Let’s provide me more the SSH credentials.
I will check further and reply you more later.
Regards,
Mall.

Hi there,
Please pause all your activities at your end now. I will check further in your instance and reply you more later.
Regards,
Mall.

Hi there,
I have checked in your instance and i see the issue as you mentioned. I have added more tweak code in step #7 of our tool to handle for that case. And now you could continue with data migration in the step #7. You could run CLI command:
php -f bin/ubdatamigration run --step=7
I have run for testing: http://i.prntscr.com/LuzQqhlWTvelmXbAEVRTDA.png
Regards,
Mall.

Hi there,

I will proceed with the definitive migration, so I will probably need to do what you just did. 

Any times, you could download the php file for step #7 of our tool at here
And then, upload replace to the php file in your new instance at path: pub/ub-tool/protected/controllers/Step7Controller.php
Note: This patch only compatible with ver.3.1.2 of our tool.
Regards,
Mall.

Hi there,

2018/01/03 05:18:35 [error] [ub_data_migration] Mage2SalesOrder: Total Canceled is too long (maximum is 12 characters).- Total Due is too long (maximum is 12 characters).

That because your database has some records has bad data in values of the the sales_flat_order.total_canceled and sales_flat_order.total_due fields.
To solve that issue, you could do with steps as followings:
Step 1: Open the php file at path: pub/ub-tool/protected/controllers/Step7Controller.php
and find to the code line:

'weight','base_grand_total','base_subtotal','grand_total','subtotal',

and replace it by code line:

'weight','base_grand_total','base_subtotal','grand_total','subtotal',total_canceled,total_due,

Once done, you could continue with data migration in the step #7: php -f bin/ubdatamigration run --step=7
Regards,
Mall.

Hi there,

Message: Mage2SalesOrderItem: Price Incl Tax is too long (maximum is 12 characters).
<br/>Mage2SalesOrderPayment: Amount Ordered is too long (maximum is 12 characters)

No, that is another issue in other context. To solve that, you could do with steps as followings:
Open the php file at path: pub/ub-tool/protected/controllers/Step7Controller.php
and find to the code line:

} else if (in_array($key, array('weight', 'row_weight', 'row_total_incl_tax', 'base_row_total_incl_tax')) AND strlen($val) > 12) {

and replace it by code line:

} else if (in_array($key, array('weight', 'row_weight', 'row_total_incl_tax', 'base_row_total_incl_tax', 'price_incl_tax')) AND strlen($val) > 12) {

And then, continue with data migration in the step #7 by run CLI command:
php -f bin/ubdatamigration run --step=7
Regards,
Mall.
 

Hi there,

Message: Mage2SalesOrderPayment: Amount Ordered is too long (maximum is 12 characters).

You could check the records with bad data by run below SQL statement in your M1’s database:

SELECT * FROM `sales_flat_order_payment` WHERE LENGTH(`amount_ordered`) > 12;

And re-solve values on that records. And you could continue with data migration then.
Regards,
Mall.

Hi there,

What did you do a couple of days ago to solve this issue?

Kindly try with step as followings:
Open the php file at path: pub/ub-tool/protected/models/UBMigrate.php
and find to the code line 2073:

return unserialize($string);

and replace it by code line:

return @unserialize($string);

And tell me know how it goes then.
Regards,
Mall.

Hi there,
Yeah, let’s continue and contact me if you need further assistance.
Regards,
Mall.

Hit here,

Now, I can’t login using the same credentials (login & password) from magento 1….
All customers were migrated successfully.
What might be wrong ?

Did you select the Merge default website option in the step #2 of our tool? (It seems you have changed the URL of your M2 instance, I couldn’t access http://m2.peta.cl/admin_1r0bk7/ now)
If you haven’t select the Merge default website option, you need to set the migrated website as default website in your M2’s instance now. And then, the migrated customers belong to migrated website can login in your M2 instance normally. Please check this again via the back-end of your M2 instance now.
Regards,
Mall.

Hi there,
I have checked login with the customer credentials you provided and i see the issue as you said.
I have checked more in back-end of your instance and i see there are some strange:
I couldn’t view customer’s information in back-end: http://i.prntscr.com/N8pL08qwQPqfS7nRmX5ESw.png
Do you see that issue in the first time?
Also, our tool detected in your M1’s database has Total: 34858 customers -- https://prnt.sc/hycq20
But in the quick report of our tool there are total migrated 35028 customers: https://prnt.sc/hycqcq
But now i see total 35027 customers in gridview in back-end of your M2: https://prnt.sc/hycqgq
That are strange, could you explain more information about that? What did you do with your data after migration with our tool?
Regards,
Mall.
 

Hi there,

I will install a new M2 instance, and try again the migration process. I’ll let you know if the login & password error persists. 

Yeah, let’s try with that step and contact me if you need further assistance.
Regards,
Mall.

Hi there,

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`petacl2_m2`.`catalog_url_rewrite_product_category`, CONSTRAINT `FK_BB79E64705D7F17FE181F23144528FC8` FOREIGN KEY (`url_rewrite_id`) REFERENCES `url_rewrite2` (`url_rewrite_id`) ON DELETE CASC), query was: INSERT INTO `catalog_url_rewrite_product_category` (`url_rewrite_id`,`category_id`,`product_id`) VALUES (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?), (?, ?, ?)

I have checked further about that issue in your Magento2’s database and see a strange issue in your M2’s database now: http://i.prntscr.com/WkO8rb1KQEeka-sWKu7TkQ.png
As seen in the screenshot, there are two strange tables: url_rewrite2 and url_rewrite3 
Regarding the issue you mentioned, it referred to a Foreign Key in the table catalog_url_rewrite_product_category which relates to the table named url_rewrite2
Upon standard Magento 2 database structure, there’s only one table named ‘url_rewrite’ to store url rewrite. Could you explained why your M2’s database has two additional tables url_rewrite2 and url_rewrite3?

Also, I see there are a lot of products which were not migrated by our tool in your M2’s instance now:
http://i.prntscr.com/Fs9FrJ4YQeWE4kOKchYXmQ.png
So, did you use another tool or methods to migrate your data on this Magento 2 instance?
I will help to check further once knowing more details for the points above.
Regards,
Mall.
 
 

Hi there,

I don’t know how does table appeared ( url_rewrite2,  url_rewrite3). I guess the developer that help me maybe wanted to make a backup…but I am not really sure. 

So, you should consider to retry with steps as followings:
Step 1: Install a new Magento 2 fresh instance.
Step 2: Install our tool and do data migration with steps as our guide in the Readme.html
Step 3:  Verify the migrated data.
And tell me know how it goes.
Regards,
Mall.

Hi there,

No other choice ? Maybe dropping the url_rewrite2 and url_rewrite3 tables ?

So, you should discus more with your developers to get more information about that tables. And you could see in the error message:

SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`petacl2_m2`.`catalog_url_rewrite_product_category`, CONSTRAINT `FK_BB79E64705D7F17FE181F23144528FC8` FOREIGN KEY (`url_rewrite_id`) REFERENCES `url_rewrite2` (`url_rewrite_id`) ON DELETE CASC), query was: INSERT INTO 

There is one FOREIGN KEY in the table ‘catalog_url_rewrite_product_category‘ references to the table ‘url_rewrite2‘
And that is a strange.
Regards,
Mall.

Hi there, 
We wonder if you plan to proceed delta migration later on? 
If you have our migration tool uninstalled, you can not proceed delta migration at a later phase. 
Anyway, you can find steps below to uninstall our UB Data Migration Pro:  
(NOTE: If you just want to disable our migration tool, you just need do the Step 1)
 
Step 1: Disable our tool by run cli command: php -f bin/magento module:disable -c Ubertheme_Ubdatamigration
 
Step 2: Run followings SQL statements in your Magento2 database:
DELTE FROM setup_module WHERE module = ‘Ubertheme_Ubdatamigration’;
DROP TABLE IF EXISTS ub_migrate_map_step_2,ub_migrate_map_step_3,ub_migrate_map_step_3_attribute,ub_migrate_map_step_3_attribute_option,ub_migrate_map_step_4,ub_migrate_map_step_5,ub_migrate_map_step_5_product_download,ub_migrate_map_step_5_product_option,ub_migrate_map_step_6,ub_migrate_map_step_6_customer_address,ub_migrate_map_step_7,ub_migrate_map_step_7_invoice,ub_migrate_map_step_7_invoice_item,ub_migrate_map_step_7_order,ub_migrate_map_step_7_order_address,ub_migrate_map_step_7_order_item,ub_migrate_map_step_7_quote,ub_migrate_map_step_7_quote_address,ub_migrate_map_step_7_quote_item,ub_migrate_map_step_8,ub_migrate_map_step_8_downloadable_link_purchased,ub_migrate_map_step_8_rating,ub_migrate_map_step_8_review,ub_migrate_map_step_8_review_summary,ub_migrate_map_step_8_subscriber,ub_migrate_step;
 
Step 3: Open your Terminal, go to your web root folder and run below cli commands to clean source code of our tool:
rm -rf app/code/Ubertheme/Ubdatamigration pub/ub-tool/
 
Regards,
Ubertheme team

Hi there, 
Glad we can help. 
We have this ticket closed for now. If you have any additional question, please submit a new ticket or reach us here. 
Regards,
Ubertheme team