Back to Questions Page

Error on step 7 delta

1 Comment January 2, 2020
Vote Up
0
Vote Down
Answered
Public
Technical Question
Profile photo of biitsllc123 biitsllc123 asked January 2, 2020

Hello There,
 
I am receiving the following error on step 7 delta.
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘79171’ for key ‘PRIMARY’
Can you help me please?
 
Thank you

  1. Profile photo of biitsllc123biitsllc123 ⋅460.00 $tone January 2, 2020
    It also says run now and not delta

31 answers

Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 2, 2020
Public

Hi there,

CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘79171’ for key ‘PRIMARY’
Can you help me please?

That was because you had checked the ‘KEEP ORIGINAL IDs’ setting in step #7 of our migration tool, while you had sample or testing data in the sales data section after the first migration.

I need to know the name of data table which associated with that duplicated IDs issue.
 
Please provide me more details information about that. You can check and provide me full error message in the log file of our module at: pub/ub-tool/protected/runtime/ub_data_migration.log

I will help to check further and help you out.

Regards,
Mall.

#1
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 2, 2020
Public

Hi there,
 
I’ve checked the migration log you provided. 
 
Please perform additional steps as follows at your end:
+ Open the PHP file at: pub/ub-tool/index.php
and find the code line:

#defined('YII_DEBUG') or define('YII_DEBUG', true);

and replace it with:

defined('YII_DEBUG') or define('YII_DEBUG', true);

+ Once done, run the delta migration in step #7 by running the CLI command:
php -f bin/ubdatamigration run --step=7 --mode=update
 
And provide me details of error message if you come across.

Regards,
Mall.

#2
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 2, 2020
Public

Hi there,

Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integr ity constraint violation: 1062 Duplicate entry ‘79171’ for key ‘PRIMARY’. The SQ L statement executed was: INSERT INTO `quote` (`store_id`, `is_active`, `is_virt…

To solve that issue, you can follow these steps:

+ Run the following SQL query in your M2 database:

Delete From quote Where entity_id = 79171;

+ Once done, you can continue with the delta migration in step #7 by running the CLI command:
php -f bin/ubdatamigration run --step=7;
 
PS. Since we do not provide technical support via email, please reply to us directly via this thread. 

Regards,
Mall.
 

#3
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 2, 2020
Public

The command finished running and gave me this now.
 
 
……………………………………………………………………………….
[Processing][delta] Step #7 migration completed with 100 Sales Rules;
….
[Processing][delta] Step #7 migration completed with 1 Sales Rules;
…………………
[Processing][delta] Step #7 migration completed with 12 Sales Order Statuses;
……………………………….PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php at line 1559
#0 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1457): Step7Controller->_migrateSalesQuote()
#1 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(254): Step7Controller->_migrateSalesOrders()
#2 /var/www/magento/pub/ub-tool/protected/commands/RunCommand.php(74): Step7Controller->actionRun()
#3 /var/www/magento/pub/ub-tool/protected/commands/RunCommand.php(33): RunCommand->_migrateData()
#4 unknown(0): RunCommand->actionIndex()
#5 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#6 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): RunCommand->run()
#7 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#8 /var/www/magento/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#9 /var/www/magento/pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->run()
#10 /var/www/magento/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#11 /var/www/magento/bin/ubdatamigration(4): require_once()
ubuntu@ip-172-31-17-186:/var/www/magento$

#4
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 2, 2020
Public

Hi there,

Trying to get property ‘attributes’ of non-object
in file /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php at line 1559
#0 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1457): Step7Controller->_migrateSalesQuote()

If you are using the latest Pro version 3.2.2, please try with the steps as follows:
 
+ Run this CLI command: 
php -f bin/ubdatamigration rmdeleted --step=7;

+ Once done, continue with the data migration in step #7:
php -f bin/ubdatamigration run --step=7;
 
Regards,
Mall.
 

#5
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 3, 2020
Public

I ran the commands and received this error.
 
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘32890’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_payment` (`quote_id`, `cc_exp_year`, `cc_ss_start_month`, `cc_ss_start_year`, `payment_id`, `created_at`, `updated_at`, `method`, `cc_exp_month`, `additional_data`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9)
ubuntu@ip-172-31-17-186:/var/www/magento$
 
 

#6
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 4, 2020
Public

Hi there,

 1062 Duplicate entry ‘32890’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_payment`

To solve that issue, lets do steps as following:
+ Run following SQL in your M2 database:

Delete From quote_payment Where payment_id = 32890;

+ Once done, continue with data migration in step #7:
php -f bin/ubdatamigration run --step=7;
 
Regards,
Mall.

#7
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 4, 2020
Public

The delete worked however the following error occurred when I ran the other command
 
…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php at line 1797
#0 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1600): Step7Controller->_migrateSalesQuoteItem()
#1 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1457): Step7Controller->_migrateSalesQuote()
#2 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(254): Step7Controller->_migrateSalesOrders()
#3 /var/www/magento/pub/ub-tool/protected/commands/RunCommand.php(74): Step7Controller->actionRun()
#4 /var/www/magento/pub/ub-tool/protected/commands/RunCommand.php(33): RunCommand->_migrateData()
#5 unknown(0): RunCommand->actionIndex()
#6 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#7 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): RunCommand->run()
#8 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#9 /var/www/magento/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#10 /var/www/magento/pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->run()
#11 /var/www/magento/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#12 /var/www/magento/bin/ubdatamigration(4): require_once()
ubuntu@ip-172-31-17-186:/var/www/magento$
 

#8
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 5, 2020
Public

Hi there,

PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php at line 1797
#0 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1600): Step7Controller->_migrateSalesQuoteItem()

Lets try with steps as following:
+ Run SQLs in your M2 database:

DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule' AND m2_id NOT IN (Select rule_id From salesrule); 
DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule_coupon' AND m2_id NOT IN (Select coupon_id From salesrule_coupon); 
DELETE FROM ub_migrate_map_step_7_order_item WHERE entity_name = 'sales_flat_order_item' AND m2_id NOT IN (Select item_id From sales_order_item); 
DELETE FROM ub_migrate_map_step_7_order_address WHERE entity_name = 'sales_flat_order_address' AND m2_id NOT IN (Select entity_id From sales_order_address); 
DELETE FROM ub_migrate_map_step_7_quote WHERE entity_name = 'sales_flat_quote' AND m2_id NOT IN (Select entity_id From quote); 
DELETE FROM ub_migrate_map_step_7_quote_item WHERE entity_name = 'sales_flat_quote_item' AND m2_id NOT IN (Select item_id From quote_item); 
DELETE FROM ub_migrate_map_step_7_quote_address WHERE entity_name = 'sales_flat_quote_address' AND m2_id NOT IN (Select address_id From quote_address);

+ Once done, clean the cache of our module by run command:
rm -rf pub/ub-tool/protected/runtime/cache/
+ And then, you can continue with data migration in step #7.
Regards,
Mall.

#9
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 5, 2020
Public

Now I get this message
 
 
ubuntu@ip-172-31-17-186:/var/www/magento$ php -f bin/ubdatamigration run --step=7;
[Processing][run] in step #7: …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘170927’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_address` (`quote_id`, `save_in_address_book`, `same_as_billing`, `collect_shipping_rates`, `weight`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `tax_amount`, `base_tax_amount`, `shipping_amount`, `base_shipping_amount`, `discount_amount`, `base_discount_amount`, `grand_total`, `base_grand_total`, `free_shipping`, `address_id`, `created_at`, `updated_at`, `customer_id`, `address_type`, `email`, `firstname`, `lastname`, `street`, `city`, `region`, `region_id`, `postcode`, `country_id`, `telephone`, `shipping_method`, `shipping_description`, `shipping_tax_amount`, `base_shipping_tax_amount`, `applied_taxes`, `shipping_discount_amount`, `base_shipping_discount_amount`, `subtotal_incl_tax`, `discount_tax_compensation_amount`, `base_discount_tax_compensation_amount`, `shipping_discount_tax_compensation_amount`, `shipping_incl_tax`, `base_shipping_incl_tax`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36, :yp37, :yp38, :yp39, :yp40, :yp41, :yp42, :yp43, :yp44, :yp45)
ubuntu@ip-172-31-17-186:/var/www/magento$

#10
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 5, 2020
Public

Hi there,

1062 Duplicate entry ‘170927’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_address` (`quote_id`, `save_in_address_book`,

Lets run following SQL in your M2 database:

Delete From quote_address Where address_id = 170927;

Once done, you can continue with data migration in step #7.
Regards,
Mall.
 

#11
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 5, 2020
Public

I got this now.
Should I just keep deleting until it fets to a different error or completes?
 
 
[Processing][run] in step #7: ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘170928’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote_address` (`quote_id`, `save_in_address_book`, `same_as_billing`, `collect_shipping_rates`, `weight`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `tax_amount`, `base_tax_amount`, `shipping_amount`, `base_shipping_amount`, `discount_amount`, `base_discount_amount`, `grand_total`, `base_grand_total`, `free_shipping`, `address_id`, `created_at`, `updated_at`, `customer_id`, `customer_address_id`, `address_type`, `email`, `firstname`, `lastname`, `street`, `city`, `region`, `region_id`, `postcode`, `country_id`, `telephone`, `shipping_tax_amount`, `base_shipping_tax_amount`, `applied_taxes`, `subtotal_incl_tax`, `shipping_incl_tax`, `base_shipping_incl_tax`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36, :yp37, :yp38, :yp39)
ubuntu@ip-172-31-17-186:/var/www/magento$

#12
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 5, 2020
Public

Hi there,
Lets run more following SQL in your M2 database:

Delete From quote_address Where address_id = 170928;

Once done, you can continue with data migration in step #7.
Regards,
Mall.

#13
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 5, 2020
Public

Now I get this
 
 
[Processing][run] in step #7: ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘79174’ 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`, `base_grand_total`, `customer_group_id`, `customer_note_notify`, `customer_is_guest`, `trigger_recollect`, `is_persistent`, `entity_id`, `created_at`, `updated_at`, `base_currency_code`, `store_currency_code`, `quote_currency_code`, `customer_id`, `customer_tax_class_id`, `customer_email`, `customer_firstname`, `customer_lastname`, `remote_ip`, `applied_rule_ids`, `reserved_order_id`, `global_currency_code`, `base_to_global_rate`, `base_to_quote_rate`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `is_changed`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31, :yp32, :yp33, :yp34, :yp35, :yp36, :yp37)

#14
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 6, 2020
Public

Hi there,

1062 Duplicate entry ‘79174’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote` (`store_id`, `is_active`, `is_virtual`, `is_multi_shipping`, `items_count`,

Please follow these steps:

+ Run the following SQL query in your M2 database:

Delete From quote Where entity_id = 79174;

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

Regards,
Mall.

#15
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 6, 2020
Public

Now i get this error below.
Can I just have you guys login and fix it, I am supposed to start testing tomorrow and cant because we have to keep waiting on a reply for the next step on these errors.
 
 
………………………………………………………………………………………………………………………………………………………………….PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php at line 1797
#0 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1600): Step7Controller->_migrateSalesQuoteItem()
#1 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1457): Step7Controller->_migrateSalesQuote()
#2 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(254): Step7Controller->_migrateSalesOrders()
#3 /var/www/magento/pub/ub-tool/protected/commands/RunCommand.php(74): Step7Controller->actionRun()
#4 /var/www/magento/pub/ub-tool/protected/commands/RunCommand.php(33): RunCommand->_migrateData()
#5 unknown(0): RunCommand->actionIndex()
#6 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleCommand.php(172): ReflectionMethod->invokeArgs()
#7 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleCommandRunner.php(71): RunCommand->run()
#8 /var/www/magento/pub/ub-tool/yii-1.1.19/console/CConsoleApplication.php(92): CConsoleCommandRunner->run()
#9 /var/www/magento/pub/ub-tool/yii-1.1.19/base/CApplication.php(185): CConsoleApplication->processRequest()
#10 /var/www/magento/pub/ub-tool/yii-1.1.19/yiic.php(33): CConsoleApplication->run()
#11 /var/www/magento/pub/ub-tool/protected/ubdatamigration_cli.php(5): require_once()
#12 /var/www/magento/bin/ubdatamigration(4): require_once()
ubuntu@ip-172-31-17-186:/var/www/magento$

#16
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 6, 2020
Public

Hi there,

PHP Error[8]: Trying to get property ‘attributes’ of non-object
in file /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php at line 1797
#0 /var/www/magento/pub/ub-tool/protected/controllers/Step7Controller.php(1600): Step7Controller->_migrateSalesQuoteItem()

You can solve that issue by following the steps suggested in my reply #9.

Regards,
Mall.

#17
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 6, 2020
Public

Hi there,

I still get the same error after doing #9 again.

That is strange. Please provide me information of your instance:

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

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, than it’s safe to share your site info here. Only you and our technical team can access. 
 
Regards,
Mall.

#19
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 6, 2020
Public

Hi there,

 I still get the same error after doing #9 again.

It seems that you have enabled PHP memcache option in our module. If that’s the case, please try to refresh PHP memcache.
 
Once done, you can continue with the data migration in step #7:
php -f bin/ubdatamigration run --step=7

If the issue still persists then provide me credentials of your instance as suggested in my reply #19 above.

Regards,
Mall.

#20
Vote Up
0
Vote Down
Profile photo of ubdev ⋅ Staff ⋅98150.00 $tone January 6, 2020
Public

Hi there, 
Since you’ve sent us your site credentials, please pause all activities at your end. Once we debug the issue, we will keep you updated.
Regards,
Ubertheme team

#23
Vote Up
0
Vote Down
Profile photo of ubdev ⋅ Staff ⋅98150.00 $tone January 6, 2020
Public

Hi there, 
While logging in your site to verify the credentials, we noticed that your site admin showed 500 error -- https://prnt.sc/qjw29v. The SSH credentials were working fine though.
Just for your information. 
Regards,
Ubertheme team 

#25
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 6, 2020
Public

Hi there,

I have checked your instance and saw the root cause of all issues you mentioned in step #7.  
I noticed that you had a lot of sales quote data changes in M1 and M2 after the first migration with our module. Thus I updated SQLs in the following steps to cover the changes of sales quotes actives which had been migrated to M2 in the first migration while they were converted to sales orders after the first migration completed.

For your information, I performed the following steps at my end:

+ Run these SQLs in your M2 database:

DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule' AND m2_id NOT IN (Select rule_id From salesrule); 
DELETE FROM ub_migrate_map_step_7 WHERE entity_name = 'salesrule_coupon' AND m2_id NOT IN (Select coupon_id From salesrule_coupon); 
DELETE FROM ub_migrate_map_step_7_order_item WHERE entity_name = 'sales_flat_order_item' AND m2_id NOT IN (Select item_id From sales_order_item); 
DELETE FROM ub_migrate_map_step_7_order_address WHERE entity_name = 'sales_flat_order_address' AND m2_id NOT IN (Select entity_id From sales_order_address); 
DELETE FROM ub_migrate_map_step_7_quote WHERE (entity_name = 'sales_flat_quote' OR entity_name = 'sales_flat_quote_active') AND m2_id NOT IN (Select entity_id From quote); 
DELETE FROM ub_migrate_map_step_7_quote_item WHERE entity_name = 'sales_flat_quote_item' AND m2_id NOT IN (Select item_id From quote_item); 
DELETE FROM ub_migrate_map_step_7_quote_address WHERE entity_name = 'sales_flat_quote_address' AND m2_id NOT IN (Select address_id From quote_address);

+ And, clean the cache of our module by running the command:
rm -rf pub/ub-tool/protected/runtime/cache/

+ Then, continue with the data migration in step #7:
php -f bin/ubdatamigration run --step=7

And here’s the result at my end: http://prntscr.com/qjwtpo

And I have terminated the process in step #7 at my end. Now you can continue with the data migration in step #7 at your end by running the CLI command:
php -f bin/ubdatamigration run --step=7

Regards,
Mall.

#27
Vote Up
0
Vote Down
Profile photo of biitsllc123 ⋅460.00 $tone January 6, 2020
Public

It ran for about 3 hours then gave this error
 
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘79926’ 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`, `base_grand_total`, `customer_group_id`, `customer_note_notify`, `customer_is_guest`, `trigger_recollect`, `is_persistent`, `entity_id`, `created_at`, `updated_at`, `base_currency_code`, `store_currency_code`, `quote_currency_code`, `customer_tax_class_id`, `remote_ip`, `global_currency_code`, `base_to_global_rate`, `base_to_quote_rate`, `subtotal`, `base_subtotal`, `subtotal_with_discount`, `base_subtotal_with_discount`, `is_changed`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6, :yp7, :yp8, :yp9, :yp10, :yp11, :yp12, :yp13, :yp14, :yp15, :yp16, :yp17, :yp18, :yp19, :yp20, :yp21, :yp22, :yp23, :yp24, :yp25, :yp26, :yp27, :yp28, :yp29, :yp30, :yp31)

#30
Vote Up
0
Vote Down
Profile photo of Mall ⋅ Staff ⋅184060.00 $tone January 6, 2020
Public

Hi there,

Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘79926’ for key ‘PRIMARY’. The SQL statement executed was: INSERT INTO `quote` (`store_id`, `is_active`, `is_virtual`, `is_multi_shipping`, `items_count`,

Please follow these steps:

+ Run the following SQL query in your M2 database:

Delete From quote Where entity_id = 79926;

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

Regards,
Mall.

#31

Please login or Register to Submit Answer

Written By

Further Reading

Comments