Error in migrating sales data (Row Total,Base Row)

Mall,
I received below error messages while migrating sales data using  UB Data Migration Pro tool .
Curent Version: 3.0.6
UB Data Migration Pro — Standard
Mage2SalesQuoteItem: Row Total is too long (maximum is 12 characters).
-- Base Row Total is too long (maximum is 12 characters).
-- Row Weight is too long (maximum is 12 characters).
-- Row Total Incl Tax is too long (maximum is 12 characters).
-- Base Row Total Incl Tax is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Subtotal is too long (maximum is 12 characters).
-- Base Subtotal is too long (maximum is 12 characters).
-- Grand Total is too long (maximum is 12 characters).
-- Base Grand Total is too long (maximum is 12 characters).
-- Subtotal Incl Tax is too long (maximum is 12 characters).
Mage2SalesQuoteItem: Row Total is too long (maximum is 12 characters).
-- Base Row Total is too long (maximum is 12 characters).
-- Row Weight is too long (maximum is 12 characters).
-- Row Total Incl Tax is too long (maximum is 12 characters).
-- Base Row Total Incl Tax is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Subtotal is too long (maximum is 12 characters).
-- Base Subtotal is too long (maximum is 12 characters).
-- Grand Total is too long (maximum is 12 characters).
-- Base Grand Total is too long (maximum is 12 characters).
-- Subtotal Incl Tax is too long (maximum is 12 characters).
 
Thanks
Vijay

7 answers

Profile photo of Mall Staff 184060.00 $tone March 10, 2017
Public

Hi there,
That issues because your Magento1 database has some bad data with new rules of Magento2 in some tables of sales data section.
To solve that, let’s download the php file at: https://drive.google.com/file/d/0B4UfTo5yHHTKdldIRFMyQmxZOVU/view?usp=sharing
and upload replace it to the file at path: pub/ub-tool/protected/controllers/Step7Controller.php
Once done, you can continue with data migration in the step #7.
Regards,
Mall.

#1
Profile photo of lakvenkat 1000.00 $tone March 10, 2017
Public

Hi Mall,
I received below error messages while migrating sales data .
Mage2SalesQuoteItem: Price is too long (maximum is 12 characters).
-- Base Price is too long (maximum is 12 characters).
-- Price Incl Tax is too long (maximum is 12 characters).
-- Base Price Incl Tax is too long (maximum is 12 characters).
Thanks
Vijay
 

#2
Profile photo of Mall Staff 184060.00 $tone March 10, 2017
Public

Hi there,
That issue because your database has some bad data in other context.
I have added more tweak code to handle that cases.
Lets re-download the file at: https://drive.google.com/file/d/0B4UfTo5yHHTKdldIRFMyQmxZOVU/view?usp=sharing
And re-upload replace it to the file at: pub/ub-tool/protected/controllers/Step7Controller.php
And then, you can continue.
Regards,
Mall.

#3
Profile photo of lakvenkat 1000.00 $tone March 10, 2017
Public

Hi Mall,
I received below error messages while migrating sales data .
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
Mage2SalesQuoteAddress: Discount Amount is too long (maximum is 12 characters).
-- Base Discount Amount is too long (maximum is 12 characters).
 
Thanks 
Vijay

#4
Profile photo of Mall Staff 184060.00 $tone June 24, 2022
Public

Hi there,

If i am not a paid user then how can i get this file ?

Only paid users can download the UB Data Migration Pro module and get support from us.
You can purchase the module at this page. After you become a paid user, please just let us know of your support question and we will assist you further.
 
Best regards,
Mall.

#7

Please login or Register to Submit Answer

Written By

Comments