Migrate Categories Integrity constraint violation

Using UB Data Migration Pro -- 3.0.4 module, I tried to migrate data, however i got an error at  step 4 -- Migrate Categories
http://prntscr.com/e3zb84
CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_set_id’ cannot be null
Error by running command form CLI 
Processing in step #4….
Status: fail
Message: CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘attribute_set_id’ cannot be null. The SQL statement executed was: UPDATE `catalog_category_entity` SET `attribute_set_id`=:yp0, `parent_id`=:yp1, `level`=:yp2, `entity_id`=:yp3, `created_at`=:yp4, `updated_at`=:yp5, `path`=:yp6, `position`=:yp7, `children_count`=:yp8 WHERE `catalog_category_entity`.`entity_id`=’343′
I looked into database table catalog_category_entity and column attribute_set_id
SELECT GROUP_CONCAT(`attribute_set_id`) FROM `catalog_category_entity` ORDER BY `attribute_set_id` DESC LIMIT 500
0,3,0,0,3,3,0,0,0,3,3,3,3,0,0,0,0,0,0,0,0,0,3,3,3,0,0,0,0,0,0,3,3,3,0,0,0,3,3,0,0,0,0,0,0,0,0,0,3,3,3,3,3,3,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,0,3,0,3,3,3,0,0,0,3,0,0,0,3,3,0,3,0,0,0,0,0,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3
None of all entities has null
 
I can send you any of db dump or database structure.
Or if it is exist some logs form UB Data Migration module. (I did not find any)
 
Thank you for help.

1 answer

Profile photo of Mall Staff 184060.00 $tone February 3, 2017
Public

Hi Filip Krejci,
That is a strangle issue. I seem comes from bad data of your categories in Magento1’s database.
Let’s provide me the admin and root ssh credentials of your Magento2. I will check further and help you out.
Regards,
Mall.

#1

Please login or Register to Submit Answer

Written By

Comments