Install theme & extensions before delta migration

Hello
The migration has gone well!! 
Can I Install theme & extensions before delta migration?
Thanks

  1. Profile photo of Harry Zampetoulasdrharrygr 560.00 $tone May 25, 2020
    Practical.. this is the only way....

14 answers

Profile photo of ubdev Staff 63820.00 $tone May 25, 2020
Public

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

#1
Profile photo of ubdev Staff 63820.00 $tone May 25, 2020
Public

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

#3
Profile photo of Harry Zampetoulas 560.00 $tone May 25, 2020
Public

Hello
This is my error
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘5043’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `customer_entity` (`group_id`, `store_id`, `is_active`, `disable_auto_group_change`, `failures_num`, `entity_id`, `website_id`, `email`, `created_at`, `updated_at`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9)
 
Now the status on step 7 is ERROR and the button shows RUN not DELTA (like the other steps)
How i can reset this and switch to Delta
Thanks

#4
Profile photo of Mall Staff 142250.00 $tone May 26, 2020
Public

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.

#6
Profile photo of Harry Zampetoulas 560.00 $tone May 28, 2020
Public

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

#7
Profile photo of Mall Staff 142250.00 $tone May 28, 2020
Public

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.

#8
Profile photo of Harry Zampetoulas 560.00 $tone May 28, 2020
Public

Hello Mall
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’

#9
Profile photo of Mall Staff 142250.00 $tone May 28, 2020
Public

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.

#10
Profile photo of Mall Staff 142250.00 $tone May 28, 2020
Public

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.

#12
Profile photo of Harry Zampetoulas 560.00 $tone June 2, 2020
Public

Hi there
I have error on Step 7.
I run the delete SQL queries you sent me before for step 7.
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`, `items_count`, `items_qty`, `orig_order_id`, `store_to_base_rate`, `store_to_quote_rate`, `grand_total`, `ba se_grand_total`, `customer_group_id`, `customer_note_notify`, `customer_is_guest`, `trigger_recollect`, `is_persistent`, `ent ity_id`, `created_at`, `updated_at`, `base_currency_code`, `store_currency_code`, `quote_currency_code`, `customer_id`, `cust omer_tax_class_id`, `customer_email`, `customer_firstname`, `customer_lastname`, `remote_ip`, `reserved_order_id`, `global_cu rrency_code`, `base_to_global_rate`, `base_to_quote_rate`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subto tal_with_discount`, `is_changed`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :y p13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, : yp31, :yp32, :yp33, :yp34, :yp35, :yp36)
Please advice 

#13
Profile photo of Mall Staff 142250.00 $tone June 2, 2020
Public

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.
 

#14

Please login or Register to Submit Answer

Written By

Comments