Issue with Account Tags During Migration from Odoo 16 to 17 CE

[torcuato86]

Hi everyone,

I’m currently facing an issue while migrating from Odoo 16 to Odoo 17 Community Edition. Specifically, the problem seems to be related to account tags. During the migration process, I encountered the following error with multiple ids

2025-03-25 10:59:00,729 7 INFO demo odoo.addons.base.models.ir_model: Deleting 9@account.account.tag (l10n_es.mod_111_09) 
2025-03-25 10:59:00,773 7 ERROR demo odoo.sql_db: bad query: DELETE FROM "account_account_tag" WHERE id IN (9)

ERROR: update or delete on table "account_account_tag" violates foreign key constraint "account_account_tag_account_move_li_account_account_tag_id_fkey" on table "account_account_tag_account_move_line_rel"
DETAIL:  Key (id)=(9) is still referenced from table "account_account_tag_account_move_line_rel".
 
2025-03-25 10:59:00,774 7 WARNING demo odoo.addons.openupgrade_framework.odoo_patch.odoo.models: Could not delete obsolete record with ids [9] of model account.account.tag: update or delete on table "account_account_tag" violates foreign key constraint "account_account_tag_account_move_li_account_account_tag_id_fkey" on table "account_account_tag_account_move_line_rel"
DETAIL:  Key (id)=(9) is still referenced from table `"account_account_tag_account_move_line_rel".

Has anyone else experienced this problem? If so, could you share any solutions or workarounds?

Thanks in advance for your help!

[pedrobaeza]

This is not really a problem, as it's normal that the tags are not removed if they have been used, but that shouldn't prevent the migration itself.

[torcuato86]

Hello everyone,

I would like to inform you that the issue raised in this discussion has been addressed in PR 4916 .