Message: Mage2SalesQuote: Items Qty is too long (maximum is 12 characters).
-- Base Subtotal With Discount is too long (maximum is 12 characters).
please help
-
Mag M ⋅790.00 $tone August 29, 2019
Message: Mage2SalesQuote: Base Subtotal With Discount is too long (maximum is 12 characters). -
Message: Mage2SalesQuoteItem: Qty is too long (maximum is 12 characters).
Mag M ⋅790.00 $tone
August 29, 2019
13 answers
Hi there,
Message: Mage2SalesQuoteItem: Qty is too long (maximum is 12 characters).
That issue occurred because your M1 database has at least one record which has the bad data in the ‘qty’ field in the table ‘sales_flat_quote_item’.
Since I need to add a few additional tweak code to resolve that issue, please provide us your site info below, I will help to implement the changes at my end:
- URL and Admin credentials of your M2 instance
- SSH credentials of your M2 instance
- Let me know the path to your M2 folder
Regards,
Mall.
Hi there,
Use ssh , you have root access
I have used your SSH key and tried to connect to your server via SSH from Ubuntu. However, I had no permission to change any files: http://prntscr.com/ozhjkk
Please help to check again.
Regards,
Mall.
Hi there,
I tried again with sudo in SSH, and added additional tweak code in step #7 of our migration tool in the PHP file:
pub/ub-tool/protected/controllers/Step7Controller.php
Now, you can continue with the data migration in the step #7:
php -f bin/ubdatamigration run --step=7;
Regards,
Mall.
Hi there,
And what about advance pricing issue ?
Lets provide me more details about that issue. There are some prices in advance pricing information tab.
What exactly issue you want to mentioned? Is that issue happens with all migrated products?
And provide me the product’s SKU which has that issue.
I will help to check further and get back you then.
Regards,
Mall.
catalog_product_entity_tier_price has data.
Assuming this stores tier price, the entity id that has value does not show in the admin panel. Can you please help to resolve this?
Hi there,
I checked further in your instance and I saw the issue you mentioned.
And i think the root of issues you mentioned because you have not reindex data successfully yet.
Lets try reindex at your end by run below CLI command:
php -f bin/magento indexer:reset
php -d memory_limit=-1 -f bin/magento indexer:reindex;
php -f bin/magento cache:clean
Regards,
Mall.
We did still it does not show advance pricing in admin
Design Config Grid index has been rebuilt successfully in 00:00:00
Customer Grid index has been rebuilt successfully in 00:06:57
Category Products index has been rebuilt successfully in 00:00:13
Product Categories index has been rebuilt successfully in 00:00:00
Catalog Rule Product index has been rebuilt successfully in 00:00:04
Product EAV index has been rebuilt successfully in 00:01:59
Stock index has been rebuilt successfully in 00:00:04
Inventory index has been rebuilt successfully in 00:00:00
Catalog Product Rule index has been rebuilt successfully in 00:00:00
Product Price index has been rebuilt successfully in 00:02:39
Catalog Search index has been rebuilt successfully in 00:02:58
Hi there,
I checked further in your back-end and I saw your M2 is ver.2.3.2 but I saw a strange label ‘Customer Group Price‘: https://prnt.sc/p1batt
M2 was removed Group prices and using Tier prices. And Tier prices data stored in table ‘catalog_product_entity_tier_price‘
Here is a example on migrated product which has Tier prices in my local in M2.3.2: http://prntscr.com/p1bcn3
You could see there isn’t the strange label ‘Customer Group Price’ as in your M2 site. How you get current M2.3.2 in your instance?
Also, I saw you have installed a lot of third party extensions in your M2 site. Does these extensions effects to that strange issue.
If you check migrated data in table ‘catalog_product_entity_tier_price’ in your M1 and M2 database, you could see our migration was migrated correct for all data records.
Regards,
Mall.
