콘텐츠로 건너뛰기
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
모든 게시물 사용자 배지
태그 (모두 보기)
odoo accounting v14 pos v15
게시판 정보
신고된 질문입니다
3 답글
3565 화면
아바타
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

아바타
취소