Migration Failure - Foreign key constraint name =- FK-TaxTransactionComponent_Account
I am trying to upgrade a AccountRight Standard v19 file to AccountRight 2025 but get the following error msg:
2025-03-19 11:26:27.6101,MYOB.Huxley.UpgradeUtility.UpgradeUtility,Error,3,Failed: 'Inserting Constraints': A foreign key value cannot be inserted because a corresponding primary key value does not exist. [ Foreign key constraint name = FK_TaxTransactionComponent_Account ]
I use MYOB offline.
Please advise how I can move forward.
Hi GDCE,
This error typically arises if the tax codes in the file do not have linked accounts. I recommend going to the Lists menu and choosing Tax Codes. Check every tax code and ensure they have linked accounts. Then, perform the upgrade.
If the issue persists, make sure to reach out to our support team directly. You can reach them on Live Chat via our virtual assistant, MOCA or by submitting a support case via MyAccount.
Regards,
Earl
