Facing error while sync latest records from M1

Hi there,

[Processing][run] in step #3: ..PHP Error[2]: get_class() expects parameter 1 to be object, null given in file /var/www/html/stuartnew/pub/ub-tool/protected/controllers/Step3Controller.php at line 388

It seems that you deleted at least one migrated Attribute Set in M2 after the first migration. To solve that issue you can try with these steps:

1. Run the following SQL queries in your M2 database:

DELETE FROM ub_migrate_map_step_3 WHERE entity_name = 'eav_attribute_set' AND m2_id NOT IN (SELECT attribute_set_id FROM eav_attribute_set);
DELETE FROM ub_migrate_map_step_3 WHERE entity_name = 'eav_attribute_group' AND m2_id NOT IN (SELECT attribute_group_id FROM eav_attribute_group);
DELETE FROM ub_migrate_map_step_3_attribute WHERE entity_name = 'eav_attribute' AND m2_id NOT IN (SELECT attribute_id FROM eav_attribute);
DELETE FROM ub_migrate_map_step_3_attribute_option WHERE entity_name = 'eav_attribute_option' AND m2_id NOT IN (SELECT option_id FROM eav_attribute_option);

2. Clean the cache of our module by running the command:
rm -rf pub/ub-tool/protected/runtime/cache/
3. You continue with data migration in step #3 by running the CLI command:

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

Message: Mage2SalesQuote: Items Qty is too long (maximum is 12 characters).
— Base Subtotal With Discount is too long (maximum is 12 characters).

Those referred to bad data cases. And such cases were already handled the Pro v3.2.0. I didn’t know why you still get those issues.
Please provide me information about your instance:

• URL and Admin credentials of your M2 instance
• SSH credentials of your M2 instance
• And let me know the path to the M2 folder

I will help to check further and get back to you then.
PS. Please make sure you mark your reply private or simply switch this ticket to the private mode. Then only you and our technical team can access it. 

Regards,
Mall.
 
 

Hi there,

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘4468’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_entity` (`group_id`, `store_id`, `is_active`,

To solve that issue, you can do steps as follows:

1. Run the following SQL queries in your M2 database:

Delete From customer_group Where customer_group_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'customer_group');
Delete From tax_class Where class_type='CUSTOMER' AND class_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'tax_class');
Delete From customer_entity Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'customer_entity');
Delete From customer_entity_varchar Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'customer_entity');
Delete From customer_entity_text Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'customer_entity');
Delete From customer_entity_int Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'customer_entity');
Delete From customer_entity_decimal Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'customer_entity');
Delete From customer_entity_datetime Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_6 where entity_name = 'customer_entity');

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

Regards,
Mall.

Hi there,

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘1625’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_order` (`total_item_count`, `paypal_ipn_customer_notified`, `fee`,

To solve that issue, you can try with these steps:

1. Run the following SQL queries in your M2 database:

Delete From salesrule Where rule_id NOT IN (Select m2_id From ub_migrate_map_step_7 where entity_name = 'salesrule');
Delete From quote Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_quote where entity_name = 'sales_flat_quote' OR entity_name = 'sales_flat_quote_active');
Delete From quote_item Where item_id NOT IN (Select m2_id From ub_migrate_map_step_7_quote_item where entity_name = 'sales_flat_quote_item');
Delete From quote_address Where address_id NOT IN (Select m2_id From ub_migrate_map_step_7_quote_address where entity_name = 'sales_flat_quote_address');
Delete From sales_order Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_order where entity_name = 'sales_flat_order');
Delete From sales_order_item Where item_id NOT IN (Select m2_id From ub_migrate_map_step_7_order_item where entity_name = 'sales_flat_order_item');
Delete From sales_order_address Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_order_address where entity_name = 'sales_flat_order_address');
Delete From sales_invoice Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_invoice where entity_name = 'sales_flat_invoice');
Delete From sales_invoice_item Where entity_id NOT IN (Select m2_id From ub_migrate_map_step_7_invoice_item where entity_name = 'sales_flat_invoice_item');

2. Once done, you continue with the data migration in step #7.

Regards,
Mall.

Hi there,

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

So, you can try with these steps:

1. Run this SQL query in your M2 database:

Delete From sales_order_grid Where entity_id = 1625;

2. Once done, you can continue to run the data migration in step #7.

Regards,
Mall.

Hi there,

: 1062 Duplicate entry ‘1403’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `sales_shipment_grid` (`entity_id`, `increment_id`, `store_id`,

Please try with these steps:

1. Run the SQL query in your M2 database:

Delete From sales_shipment_grid Where entity_id = 1403;

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

Regards,
Mall.

Hi there,

Is there any problem to delete the duplicate records from database?

Because you checked ‘KEEP ORIGINAL IDs’ setting in step #7 while you added new sales data in M2 after the first migration, in order to continue with delta migration in step #7 without the duplicated issue you mentioned, you have to delete all related newly added data in the sales data section in M2.
 
Regards,
Mall.