Customer Firstname is too long

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

Profile photo of Mall Staff 184060.00 $tone October 5, 2018
Public

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.

#1
Profile photo of fast.serv 10.00 $tone October 5, 2018
Public

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.

#2
Profile photo of kb mon 10.00 $tone April 8, 2020
Public

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

#4
Profile photo of ubdev Staff 97650.00 $tone April 8, 2020
Public

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
 

#5

Please login or Register to Submit Answer

Written By

Comments