Skip to Content
คุณต้องลงทะเบียนเพื่อโต้ตอบกับคอมมูนิตี้
All Posts คน เหรียญรางวัล
แท็ก (View all)
odoo accounting v14 pos v15
เกี่ยวกับฟอรั่มนี้
คำถามนี้ถูกตั้งค่าสถานะ
3 ตอบกลับ
3574 มุมมอง
อวตาร
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".


อวตาร
ละทิ้ง
อวตาร
Joel Oates
คำตอบที่ดีที่สุด

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.

อวตาร
ละทิ้ง
อวตาร
Bertus Kruger
คำตอบที่ดีที่สุด

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.


อวตาร
ละทิ้ง
Joel Oates

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

อวตาร
Niyas Raphy (Walnut Software Solutions)
คำตอบที่ดีที่สุด

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

อวตาร
ละทิ้ง