Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
migrationopenupgradeodoov11odooV12
1 Odgovori
8884 Prikazi
Avatar
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.

Avatar
Opusti
Kirubanidhi Rajarathinam

Please help this issue

Avatar
ICTPACK SOLUTIONS LTD
Best Answer

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

Hope this helps!

Avatar
Opusti
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

Related Posts Odgovori Prikazi Aktivnost
How to: upgrade from V11CE to V12CE
upgrade openupgrade odoov11 odooV12
Avatar
Avatar
Avatar
Avatar
3
jun. 19
7409
Asset Management migration V12.0 to new versions
migration openupgrade
Avatar
0
maj 23
3107
How to set up 2 OpenUpgrade Servers Solved
migration openupgrade
Avatar
1
avg. 19
5381
Error openupgrade hr module
migration openupgrade
Avatar
Avatar
1
mar. 15
6424
Database Migration error from Odoo 14 to 15(Community) using Openeupgrade.
migration openupgrade databasemigration
Avatar
Avatar
1
maj 25
3036