Message: Mage2SalesOrder: Increment Id is too long

The order / invoice (step 7) stops with the error “Message: Mage2SalesOrder: Increment Id is too long (maximum is 32 characters).”
 
Please advise.

2 answers

Profile photo of Mall Staff 184060.00 $tone January 19, 2019
Public

Hi there,

“Message: Mage2SalesOrder: Increment Id is too long (maximum is 32 characters).”

That issue because your database has some records which has bad value of increment_id field in table sales_flat_order. Max length allowed in M2 database rule on value of this field is 32 characters only.
To continue with data migration in the step #7 of our migration tool, you must manual fix for bad records in your M1’s database at your end first. You could run below SQL in M1 database to listing for bad records:

SELECT * FROM sales_flat_order WHERE LENGTH(increment_id) > 32;

and then, fix for bad values of increment_id field.
Once done, you could continue with data migration in the step #7.
Regards,
Mall.
 

#1

This question is now closed

Written By

Comments