Skip to Content
Musisz się zarejestrować, aby móc wchodzić w interakcje z tą społecznością.
Wszystkie posty Osoby Odznaki
Tagi (Zobacz wszystko)
odoo accounting v14 pos v15
O tym forum
To pytanie dostało ostrzeżenie
3 Odpowiedzi
3589 Widoki
Awatar
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".


Awatar
Odrzuć
Awatar
Joel Oates
Najlepsza odpowiedź

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.

Awatar
Odrzuć
Awatar
Bertus Kruger
Najlepsza odpowiedź

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.


Awatar
Odrzuć
Joel Oates

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

Awatar
Niyas Raphy (Walnut Software Solutions)
Najlepsza odpowiedź

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

Awatar
Odrzuć