Tier-prices not shown in backend after migration

Hi!
I installed a fresh Magento 2.0.7 system without sample data. Then I installed your data migration pro 3 and walked through all 8 steps and made all console commands as described in your video. At the end I see in database table “store” one admin store, one default store from magento fresh system and my 5 migrated store. So far so good. In database tables catalog_product_entity_tier_price and catalog_product_index_tier_price I see all my tier prices of active products separated into my website_id 2 until 6 (my new 5 migrated stores), my inactive products are in website_id 0 (???). In magento backend I can see all tier prices of products in website_id = 0 but none for the other website_ids. Even if I change with the store selector my store nr 4 e.g. I can’t see tier prices. I can add manually tier prices but only for website_id = 0. It seems to me that my migrated webstores are not known in products -- catalog -- basic settings -- prices. Do you have any idea what is wrong here?
If I start with fresh magento 2.0.7 and delete default store, then I can’t start your migration tool. This is not the solution.

5 answers

Profile photo of Mall Staff 184060.00 $tone October 18, 2016
Public

Hi Oliver Kraetzig,

If I start with fresh magento 2.0.7 and delete default store, then I can’t start your migration tool. This is not the solution.

No, you should not to do it. 
Did you re-index the data after migrated? Let’s provide me the admin and ssh credentials and webroot path folder of your Magento 2.
I will check further and help you get out.
Regards,
Mall.

#1
Profile photo of Oliver Kraetzig 120.00 $tone October 18, 2016
Public

Hi Mall,
to delete the default store was only a test.
Unfortunately you will not have access to our system because we have our magento on a local server system. I can tell you that all directories and files have got correct rights. For error detection I can send you database or migration log.

#2
Profile photo of Mall Staff 184060.00 $tone October 18, 2016
Public

Hi Oliver Kraetzig,
Please provide me more information about your working:
Do you using version 3.0.1 of our tool in you working?
Do you find any issues in the log of our tool at the path:
pub/ub-tool/protected/runtime/application.log
vs
pub/ub-tool/protected/runtime/ub_migrate.log
Also, as you know Magento 2 CE 2.0.7 there are a lot of issues from releases.
Why you don’t use the latest version of Magento CE 2.1.2 at this time?
Regards,
Mall.
 
 

#3
Profile photo of Oliver Kraetzig 120.00 $tone October 19, 2016
Public

Hi Mall,
 
okay, now I use a magento 2.1.2 fresh installation without sample data and your data migration tool 3.0.1. I see that I can start migration via terminal and until step 4 everything is okay. During processing step 5 the migration stops with this error:
2016/10/19 12:42:24 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento212od`.`catalog_category_product`, CONSTRAINT `CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASC). The SQL statement executed was: INSERT INTO `catalog_category_product` (`position`, `category_id`, `product_id`) VALUES (:yp0, :yp1, :yp2).
2016/10/19 12:42:24 [error] [ub_migrate] CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento212od`.`catalog_category_product`, CONSTRAINT `CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASC). The SQL statement executed was: INSERT INTO `catalog_category_product` (`position`, `category_id`, `product_id`) VALUES (:yp0, :yp1, :yp2)
My source database does not change.
What can I do?

#4
Profile photo of Mall Staff 184060.00 $tone October 20, 2016
Public

Hi Oliver Kraetzig,

2016/10/19 12:42:24 [error] [system.db.CDbCommand] CDbCommand::execute() failed: SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`magento212od`.`catalog_category_product`, CONSTRAINT `CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity`

Seem you have bad records in the table catalog_category_product in Magento 1 database. I need a closer look to detect the root of issues. Kindly provide me the admin and SSH credentials of your site.
Regards,
Mall.
 

#5

Please login or Register to Submit Answer

Written By

Comments