Перейти к содержимому
Чтобы взаимодействовать с сообществом, необходимо зарегистрироваться.
Все посты Люди Значки
Теги (Смотреть все)
odoo accounting v14 pos v15
Об этом форуме
Этот вопрос был отмечен
3 Ответы
3620 Представления
Аватар
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

Аватар
Отменить