search

magento / data-migration-tool

Magento Data Migration Tool
https://devdocs.magento.com/guides/v2.3/migration/bk-migration-guide.html
Open Software License 3.0
334 stars 200 forks source link

SQLSTATE[42000]: Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint eav_entity_type` (`entity_type_id) #921

Open nalinilalla opened 6 months ago

nalinilalla commented 6 months ago

Preconditions

  1. Migrating from Magento 1.9.4.3 to Magento 2.4.6

Steps to reproduce

  1. php bin/magento migrate:data --reset --auto vendor/magento/data-migration-tool/etc/opensource-to-opensource/1.9.4.3/config.xml

Expected result

  1. No errors

Actual result

data migration][step: EAV Step]: started 0% [>---------------------------] Remaining Time: < 1 sec In Mysql.php line 109:

SQLSTATE[42000]: Syntax error or access violation: 1701 Cannot truncate a t
able referenced in a foreign key constraint (zskffssgtt.eav_attribute,
CONSTRAINT EAV_ATTRIBUTE_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID FO
REIGN KEY (entity_type_id) REFERENCES zskffssgtt.eav_entity_type (en tity_type_id), query was: TRUNCATE TABLEeav_entity_type`

In Mysql.php line 90:

SQLSTATE[42000]: Syntax error or access violation: 1701 Cannot truncate a t
able referenced in a foreign key constraint (zskffssgtt.eav_attribute,
CONSTRAINT EAV_ATTRIBUTE_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID FO
REIGN KEY (entity_type_id) REFERENCES zskffssgtt.eav_entity_type (`en
tity_type_id)

Additional notes

m2-assistant[bot] commented 6 months ago

Hi @nalinilalla. Thank you for your report. To speed up processing of this issue, make sure that you provided sufficient information. Add a comment to assign the issue: @magento I am working on this

Join Magento Community Engineering Slack and ask your questions in #github channel.