Step 7 fails about an hour in with the following:
Status: fail
Message: Mage2SalesOrder: Customer Firstname is too long (maximum is 128 characters).
We’ve checked both customer_entity and customer_grid_flat (the only two tables with customer names) and nothing is too long.
select * from customer_grid_flat where char_length(name) > 100
MySQL returned an empty result set (i.e. zero rows). (Query took 0.2249 seconds.)
select * from customer_entity where char_length(firstname) > 100
MySQL returned an empty result set (i.e. zero rows). (Query took 0.1492 seconds.)
We’re stuck. Please help.
5 answers
Hi there,
Status: fail
Message: Mage2SalesOrder: Customer Firstname is too long (maximum is 128 characters).
That issue relates to the bad data in the table named ‘sales_flat_order’: https://prnt.sc/l2cz5x
Regards,
Mall.
Thank you, having already fixed an errant first name (padded with spaces somehow) in the customer table, didn’t realize it had been duplicated into the flat order table even after reindexing. The migration now continues, thank you.
Hi there,
Yeah, let’s continue and contact me if you need further assistance.
Regards,
Mall.
Im still experiecing the error after trying the above.
I do not seem to have that table [db.sales_flat_order] in my database
PS: this was a migration from Magento 1.9 to 2.3
UB Data Migration Pro (CE) -- 3.2.3
Step #7 error:
Message: Mage2SalesOrder: Customer Firstname is too long (maximum is 128 characters).
select * from sales_flat_order LIMIT 5;
ERROR 1146 (42S02): Table ‘db.sales_flat_order’ doesn’t exist
Hi KB Mon,
We wonder if you have another profile at Ubertheme. We could not keep track of the purchase associated with your current profile.
Since our technical support requires an active subscription, please help to submit a ticket under the paid profile at Ubertheme.
Many thanks,
Ubertheme team
