Migrated pricing error

Hi there, 
This might relate to the catalog pricing rule, not our migration tool.
You can cross check directly in your migrated database compared with your M1 database.
There’s a high chance that it relates to your 3rd party setting in M1.
So please check this again at your end.
Regards,
Ubertheme team

Hi there,

We are currently facing two issues.1. step 5 gives me the error ubuntu@ip-172-31-17-186:/var/www/magento$ php -f bin/ubdatamigration run --step=5[Processing][run] in step #5: ………………….Status: failMessage: CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘AND entity_id = 534027 LIMIT 1’ at line 1. The SQL statement executed was: SELECT * FROM `catalog_product_entity_int` `t` WHERE attribute_id = 341 AND value = AND entity_id = 534027

That issue occurred because your M1 database had at least one bad data record in the ‘catalog_product_super_attribute_pricing’ table. These data records had a relation with a none-existing attribute options in the ‘eav_attribute_option’ table.

To solve that issue, you can follow these steps:

+ Run following SQL query in your M1 database to delete the bad data records mentioned above:

DELETE FROM catalog_product_super_attribute_pricing WHERE value_index IS NULL OR value_index = '' OR value_index NOT IN (SELECT option_id FROM eav_attribute_option);

+ Once done, you can continue with data migration in step #5 by running the CLI command:

php -f bin/ubdatamigration run --step=5;

Category migration completed but it did not migrate all the categories.

Did you check all categories in the settings of Step #4 to migrate? Did you get any related error message in step #4?
Please verify again the migrated categories in the table named ‘catalog_category_entity’ in your M2 database.

Regards,
Mall.

Hi there,

Step 5 is running again now. 
The category table has 567 records but only 66 of them migrated

So, please pause the data migration in step #5. And then consider finishing data migration in step #4 (migrating categories) first.

Meanwhile, please help to answer my question in my reply #2:

Did you check all categories in the settings of Step #4 to migrate? Did you get any related error message in step #4?

Regards,
Mall.

Hi there,

Yes we checked all categories for step 4. The problem is step 4 thinks it is finished so it doesn’t let me restart it and if I reset it and run it again I get the same result.

So, please provide us the following info, we will check further and get back to you then: 

• URL and admin credentials of your M2 instance
• SSH credentials of your M2 instance
• Let us know the path to your M2 folder

PS1. Please make sure you mark your reply private or simply switch this ticket to the private mode. Then it’s safe to share your site info here. 
PS2. Since we do not provide technical support via email, please help to add a direct reply via this ticket (not sending a reply via email notification). 
Regards,
Ubertheme team

Hi there, 
We tried to access your instance however we got this error https://prnt.sc/uppy29 (when accessing category management section in your backend). So please help to check on that issue first. 
Regards,
Ubertheme team 

Hi there, 

we got this error https://prnt.sc/uppy29 

Please try to manually re-update the setting data in the store_group table in M2 database. And make sure that the root_category_id assigned to each Store is existing in the catalog_category_entity table: https://prnt.sc/uprbhv

The category table has 567 records but only 66 of them migrated

We checked further into that issue. We noticed that our module detected that your M1 had 566 categories: https://prnt.sc/upr79d
And all 566 categories have been migrated by our module: https://prnt.sc/upr7x1
So, please check on both points we mentioned above again. 

Regards,
Ubertheme team

Hi there,

constraint violation: 1062 Duplicate entry ‘2536’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_order_grid` (`entity_id`, `status`, `store_id`, `store_name`,

To solve that issue, you can do steps as follows:
1. Run the following SQL query in your M2 database:

Delete From sales_order_grid Where entity_id = 2536;

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

Regards,
Mall.

Hi there,

1062 Duplicate entry ‘589240’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_item` (`quote_id`, `no_discount`, `weight`, `qty`, `price`, `base_price`, `discount_percent`,

Let’s try with steps as following:
1. Run the following SQL in your M2 database:

Delete From quote_item Where item_id = 589240;

2. And then you continue with data migration in step #7.
Regards,
Mall.
 
 

Hi there,

Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1814050’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `catalog_product_super_attribute` (`product_id`, `attribute_id`,

To solve that issue, you can do steps below:

1. Run the following SQL query in your M2 database to delete the duplicated record:

Delete From catalog_product_super_attribute Where product_super_attribute_id = '1814050';

2. And then, you continue with the data migration in step #5.

Please note that in order ensure full data relationship, you should finish data migration in step #5 before you do data migration in step #7.

Regards,
Mall.

Hi there, 
We noticed that your M2 instance is v2.3.3 with our module v3.2.2. Please consider upgrading our module to the latest version 3.2.4.

PW: uses a key file. How can I get that to you?

If the issue still persists, then provide us the SSH key (you can send over via info (at) ubertheme.com). We will follow up further then. 
Regards,
Ubertheme team