Error in step 7

Hi there,

Status: fail
Message: Mage2SalesQuoteItem: Tax Amount is too long (maximum is 12 characters).
— Base Tax Amount is too long (maximum is 12 characters).

That occurred because your M1 database had some data records with bad data in the sales data section.

Please try with the steps below to handle that case:

+ Open the PHP file at 
pub/ub-tool/protected/controllers/Step7Controller.php
and find the code line number 1765 and the line number 1812 which have the following code:

'row_total_incl_tax', 'base_row_total_incl_tax', 'qty')) AND strlen(trim($val)) > 12) {

and replace them with:

'row_total_incl_tax', 'base_row_total_incl_tax', 'qty', 'tax_amount', 'base_tax_amount')) AND strlen(trim($val)) > 12) {

+ And then, you can continue with the data migration in step #7.

Regards,
Mall.

Hi there,

Status: fail
Message: Mage2SalesOrderAggregatedCreated: Order Status cannot be blank.

That is another case of the bad data in your M1 database. You can run the following SQL query in your M1 database to look for those bad data records:

Select * From sales_order_aggregated_created Where order_status IS NULL OR order_status = '';

And then, you need to update the value of the ‘order_status’ field in all found data records or you can delete these data records if you no longer need them.

And then, you can continue with the data migration in step #7 as normal.
 
Regards,
Mall.

Hi there,

this worked, thank you:)

Yes, let’s continue and contact us if you need further assistance.
Regards,
Mall.