magento / magento/data-migration-tool
Delta Migration issue Integrity constraint violation
Nobody has claimed this yet.
- Dominant language
- PHP
- Stars
- 339
- Forks
- 195
- PR merge metrics
- No merged PRs in 30d
Description
Hello Support,
I hope you are doing fine.
I have Magento 1 site having version 1.9.3.4 and I am migrating it to 2.4.2-p1 and having php version 7.4. Settings and data migration is done successfully and now after installing theme and other changes now when trying to do delta migration, I am getting this below error
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-37
22' for key 'CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID'
https://prnt.sc/1qdyzav
Please let me know if you need anything else.
Thanks
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file, test, or code entry point is named. Start by reproducing the delta migration with the reported Magento and PHP versions, then inspect the migration output and database rows involved in the duplicate catalog product-link key; done means the delta migration completes without the integrity constraint violation.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- php, sql
- Domain
- databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100