Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

OpenUpgrade: Migrate Database odoo from v11 to v12

migration openupgrade odoov11 odooV12

1 Beantwoorden

8827 Weergaven

Rihene

Hello my Friends;

I am trying to migrate an odoo database from the version 11 to the version12.

So, i am using OpenUpgrade.

But, the problem is that when i try to launch the process i got this error:

2019-07-26 13:46:36,059 9902 INFO ? odoo: Odoo version 12.0
2019-07-26 13:46:36,060 9902 INFO ? odoo: Using configuration file at /etc/odoo12.conf
2019-07-26 13:46:36,060 9902 INFO ? odoo: addons paths: ['/opt/OpenUpgrade/addons', '/opt/OpenUpgrade/odoo/addons']
2019-07-26 13:46:36,060 9902 INFO ? odoo: database: odoo12@default:default
2019-07-26 13:46:36,109 9902 CRITICAL ? odoo.modules.module: Couldn't load module base
2019-07-26 13:46:36,109 9902 CRITICAL ? odoo.modules.module: module 'odoo.tools' has no attribute 'yaml_import'
2019-07-26 13:46:36,110 9902 ERROR ? odoo.service.server: Failed to load server-wide module `base`.
Traceback (most recent call last):
File "/opt/OpenUpgrade/odoo/service/server.py", line 1063, in load_server_wide_modules
odoo.modules.module.load_openerp_module(m)
File "/opt/OpenUpgrade/odoo/modules/module.py", line 368, in load_openerp_module
__import__('odoo.addons.' + module_name)
File "<frozen importlib._bootstrap>", line 971, in _find_and_load
File "<frozen importlib._bootstrap>", line 955, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 656, in _load_unlocked
File "<frozen importlib._bootstrap>", line 626, in _load_backward_compatible
File "/opt/OpenUpgrade/odoo/modules/module.py", line 82, in load_module
exec(open(modfile, 'rb').read(), new_mod.__dict__)
File "<string>", line 5, in <module>
File "/opt/OpenUpgrade/odoo/addons/base/models/__init__.py", line 7, in <module>
from . import ir_model
File "/opt/OpenUpgrade/odoo/addons/base/models/ir_model.py", line 17, in <module>
from openupgradelib import openupgrade
File "/usr/local/lib/python3.6/dist-packages/openupgradelib/openupgrade.py", line 84, in <module>
yaml_import = tools.yaml_import
AttributeError: module 'odoo.tools' has no attribute 'yaml_import'
2019-07-26 13:46:36,138 9902 INFO database-demo odoo.modules.loading: loading 1 modules...
2019-07-26 13:46:36,147 9902 ERROR database-demo odoo.modules.migration: module base: Each pre-migration file must have a "migrate(cr, installed_version)" function
2019-07-26 13:46:36,150 9902 INFO database-demo odoo.modules.registry: module base: creating or updating database tables
2019-07-26 13:46:36,151 9902 ERROR database-demo odoo.sql_db: bad query: b"\n SELECT c.relname\n FROM pg_class c\n JOIN pg_namespace n ON (n.oid = c.relnamespace)\n WHERE c.relname IN ()\n AND c.relkind IN ('r', 'v', 'm')\n AND n.nspname = 'public'\n "
ERROR: syntax error at or near ")"
LINE 5: WHERE c.relname IN ()
^

Need your help please.

Thanks a lot in advance.

Best regards.

Kirubanidhi Rajarathinam

Please help this issue

ICTPACK SOLUTIONS LTD

I had this problem solved it by installing pyyaml==3.13 using pip.

Hope this helps!

Kirubanidhi Rajarathinam

sybyl@sybyl-IdeaPad-3-15IIL05-Ua:~/OpenUpgrade$ /usr/bin/python3.7 ./odoo-bin -d live_jalaram -c /opt/odoo/odoo12.0/etc/odoo-12.conf --update all --stop-after-init --data-dir '/home/sybyl/.local/share/Odoo'
2023-02-07 10:30:33,752 42167 INFO ? odoo: Odoo version 12.0
2023-02-07 10:30:33,752 42167 INFO ? odoo: Using configuration file at /opt/odoo/odoo12.0/etc/odoo-12.conf
2023-02-07 10:30:33,752 42167 INFO ? odoo: addons paths: ['/home/sybyl/.local/share/Odoo/addons/12.0', '/opt/odoo/odoo12.0/odoo/addons', '/opt/odoo/odoo12.0/odoo/odoo/addons', '/home/sybyl/OpenUpgrade/addons', '/home/sybyl/OpenUpgrade/odoo/addons', '/home/sybyl/odoo/OpenUpgrade/scripts']
2023-02-07 10:30:33,752 42167 INFO ? odoo: database: odoo_12@localhost:5432
2023-02-07 10:30:33,762 42167 CRITICAL ? odoo.modules.module: Couldn't load module web
2023-02-07 10:30:33,762 42167 CRITICAL ? odoo.modules.module: odoo.addons.web.__spec__ is None
2023-02-07 10:30:33,762 42167 ERROR ? odoo.service.server: Failed to load server-wide module `web`.
The `web` module is provided by the addons found in the `openerp-web` project.
Maybe you forgot to add those addons in your addons_path configuration.
Traceback (most recent call last):
File "/home/sybyl/OpenUpgrade/odoo/service/server.py", line 1111, in load_server_wide_modules
odoo.modules.module.load_openerp_module(m)
File "/home/sybyl/OpenUpgrade/odoo/modules/module.py", line 368, in load_openerp_module
__import__('odoo.addons.' + module_name)
File "<frozen importlib._bootstrap>", line 983, in _find_and_load
File "<frozen importlib._bootstrap>", line 967, in _find_and_load_unlocked
File "<frozen importlib._bootstrap>", line 668, in _load_unlocked
File "<frozen importlib._bootstrap>", line 638, in _load_backward_compatible
File "/home/sybyl/OpenUpgrade/odoo/modules/module.py", line 82, in load_module
exec(open(modfile, 'rb').read(), new_mod.__dict__)
File "<string>", line 4, in <module>
File "/opt/odoo/odoo12.0/odoo/addons/web/controllers/__init__.py", line 4, in <module>
from . import main, pivot
File "/opt/odoo/odoo12.0/odoo/addons/web/controllers/main.py", line 58, in <module>
loader = jinja2.PackageLoader('odoo.addons.web', "views")
File "/usr/local/lib/python3.7/dist-packages/jinja2/loaders.py", line 292, in __init__
spec = importlib.util.find_spec(package_name)
File "/usr/lib/python3.7/importlib/util.py", line 114, in find_spec
raise ValueError('{}.__spec__ is None'.format(name))
ValueError: odoo.addons.web.__spec__ is None
2023-02-07 10:30:34,019 42167 INFO ? odoo.addons.base.models.ir_actions_report: Will use the Wkhtmltopdf binary at /usr/local/bin/wkhtmltopdf
2023-02-07 10:30:34,119 42167 ERROR ? odoo.sql_db: bad query: CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1
ERROR: relation "base_registry_signaling" already exists

2023-02-07 10:30:34,119 42167 ERROR ? odoo.modules.registry: Failed to load registry
Traceback (most recent call last):
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 83, in new
registry.setup_signaling()
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 403, in setup_signaling
cr.execute("CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1")
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists

2023-02-07 10:30:34,119 42167 CRITICAL ? odoo.service.server: Failed to initialize database `live_jalaram`.
Traceback (most recent call last):
File "/home/sybyl/OpenUpgrade/odoo/service/server.py", line 1164, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 83, in new
registry.setup_signaling()
File "/home/sybyl/OpenUpgrade/odoo/modules/registry.py", line 403, in setup_signaling
cr.execute("CREATE SEQUENCE base_registry_signaling INCREMENT BY 1 START WITH 1")
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 148, in wrapper
return f(self, *args, **kwargs)
File "/home/sybyl/OpenUpgrade/odoo/sql_db.py", line 225, in execute
res = self._obj.execute(query, params)
psycopg2.errors.DuplicateTable: relation "base_registry_signaling" already exists

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
How to: upgrade from V11CE to V12CE upgrade openupgrade odoov11 odooV12	3 jun. 19	7381
Asset Management migration V12.0 to new versions migration openupgrade	0 mei 23	3073
How to set up 2 OpenUpgrade Servers Opgelost migration openupgrade	1 aug. 19	5343
Error openupgrade hr module migration openupgrade	1 mrt. 15	6398
Database Migration error from Odoo 14 to 15(Community) using Openeupgrade. migration openupgrade databasemigration	1 mei 25	3001

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!