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

[nalinilalla]

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 TABLE eav_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]]

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.