Skip to Content
This question has been flagged
3 Replies
2707 Views
Avatar
Divyabharathi

I am facing an issue while running a database migration command in Odoo version 16 with my custom module. The error message I am encountering is as follows:

bad query: ALTER TABLE "stock_route_warehouse" ADD FOREIGN KEY ("route_id") REFERENCES "stock_route"("id") ON DELETE cascade
ERROR: insert or update on table "stock_route_warehouse" violates foreign key constraint "stock_route_warehouse_route_id_fkey"
DETAIL:  Key (route_id)=(2) is not present in table "stock_route".


Avatar
Discard
Avatar
Joel Oates
Best Answer

Hi,

I recently have been doing a odoo 16 Migration and ran into the same issue, I have found that the Openupgrade package isn't quite yet got full coverage as layout in their documentation found on the openupdate website


I went looking in the migration scripts and found there isnt any migration scripts in the stocks but there is an upgrade_analysis.txt​ which describes all the changes that have happened for the stock module from 15 -> 16. 


Solution: I found the work has been done for stock in a pull request, You can go to that pull request to see the files and test it for yourself, I found there was a few issues (I commented on the PR) but eventually got it working. See the PR


https://github.com/OCA/OpenUpgrade/pull/3966/commits/d6dfed8ce9947369e134902685c296d568c8df7c


I hope this helps you or future people with this problem.

Avatar
Discard
Avatar
Bertus Kruger
Best Answer

currently there is work being done on the migration of the stock/inventory app..

https://github.com/OCA/OpenUpgrade/pull/3966/commits/d6dfed8ce9947369e134902685c296d568c8df7c

It has not been approved yet but it helped me migrate "stock"

There were some issues with renaming fields that I commented out.


Avatar
Discard
Joel Oates

Found this to get over the stock migration issue, thanks (edited my answer to reflect)

Avatar
Niyas Raphy (Walnut IT)
Best Answer

Hi,

You should little more information like which service you are using. Is it odoo enterprise upgrade service or using any other third party ?


If you are using enterprise upgrade, you can log a ticket for the migration issue and you will get a person assigned for your migration ticket to provide support.

https://www.odoo.com/help


if you are testing the migration from staging, in v15, try upgrading the base or stock module and trigger the migration again and see, if it makes any difference.


Thanks

Avatar
Discard