Install theme & extensions before delta migration

Hi there, 
 
Once you verify all migrated data ready for use, you can move forward with the theme and extension integration before performing the delta migration. 
 
Just a side note that if you did enable the Keep Original IDs setting in the first migration, then you need to delete your testing data (if any) added during the theme/extension integration before starting with the delta migration. Otherwise, it might lead to ID conflict issue. 
 
Regards,
Ubertheme team

Hi there, 

 I all ready have this issue with a test order.

We mean the conflict ID issue when you proceeding the delta migration. If you have any issue with the theme/extension integration, please check with the theme/extension provider first since it might not relate to the migration issue.

Which is the best way to delete/remove customer & order?

We will provide you the SQL query to delete sample testing/sample data added after the first migration when you start delta migration.
Regards,
Ubertheme team

Hi there,

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘5043’ for key ‘PRIMARY’. The SQL statement executed was:

To solve that issue, you have to delete all customers and associated data objects added in M2 after the first migration. You can try with these steps:

+ 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');

+ And then, you can continue with the delta migration in step #6 by running the CLI command:
php -f bin/ubdatamigration run --step=6 --mode=update;

Regards,
Mall.

Hi Harry,

Can you please advice for the following error in step 7 Delta.
Integrity constraint violation: 1062 Duplicate entry ‘30928’ for key ‘PRIMARY’

To handle that case, you can try the steps below:

+ 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');

+ Once done, you can continue with the delta migration in step #7 by running this command:
php -f bin/ubdatamigration run --step=7 --mode=update;

Regards,
Mall.

Hi there,

I have this Error on the last sql line
Delete From sales_invoice_item Where item_id NOT IN (Select m2_id From ub_migrate_map_step_7_invoice_item where entity_name = ‘sales_flat_invoice_item’)
#1054 — Unknown column ‘item_id’ in ‘IN/ALL/ANY subquery’

I have just edited the latest SQL in my reply #8. Pleas try again.
Regards,
Mall.

Hi there,

As i understand if i have same error for step 7 I can ran the same sql, Right?

Yes, that is right.
Regards,
Mall.

Hi there,

After that I still have the following error.
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entr y ‘30254’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote` (`store_id`, `is_active`, `is_virtual`, `is_ multi_shipping`,

That refers to another error. To get it solved, you can follow these steps:
+ Run the following SQL query in your M2 database to delete the duplicated data record in the ‘quote’ table:
Delete From quote Where entity_id = 30254;
+ Once done, you can continue with the data migration in step #7

Regards,
Mall.