Problems Migrating (OpenUpgrade) Odoo Sites from v15 -> v16

migration openupgrade odoo16

2 Replies

4423 Rodiniai

Hi,

i currently migrating our Odoo Instances to a newer Version using OpenUpgrade

The Upgrade running throw and the Website is running; But i still have two Problems:

Once im logged in this error appears in the logs:

ERROR odoo odoo.sql_db: bad query:
            SELECT latest_version
            FROM ir_module_module
             WHERE name='base'

ERROR: relation "ir_module_module" does not exist
LINE 3:             FROM ir_module_module
                         ^

when i query it directly in postgres i get:

SELECT latest_version FROM ir_module_module WHERE name='base';
 latest_version 
----------------
 16.0.1.3
(1 row)

It looks like that the Whitespaces causing the error but i dont know how to debugg any further..

Second Problem is once i changing the template of the header/navigation the complete Site crashes.. not repairable and i need to restore the backup..

I know that odoo did not find some files but thats all...

2025-01-29 15:12:19,400 787 ERROR ************* odoo.http: Exception during request handling.
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 85, in lookup
    r = d[key]
  File "<decorator-gen-8>", line 2, in __getitem__
  File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked
    return func(inst, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/tools/lru.py", line 34, in __getitem__
    a = self.d[obj]
KeyError: ('ir.qweb', <function IrQWeb._generate_asset_nodes_cache at 0x7fe837c55870>, 'web.assets_frontend', True, False, '', False, False, False, False, ('de_DE', True, None, False, None, None, None, 1))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 85, in lookup
    r = d[key]
  File "<decorator-gen-8>", line 2, in __getitem__
  File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 87, in locked
    return func(inst, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/tools/lru.py", line 34, in __getitem__
    a = self.d[obj]
KeyError: ('ir.qweb', <function IrQWeb._get_asset_content at 0x7fe837c55a20>, 'web.assets_frontend', False, False, None, ('de_DE', True, None, False, None, None, None, 1))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "<456>", line 1409, in template_456
  File "<456>", line 1002, in template_456_content
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2461, in _load_values
    return get_value()
  File "<456>", line 992, in template_456_t_cache_0_cache
  File "<456>", line 426, in template_456_t_cache_0
  File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_qweb.py", line 122, in _get_asset_nodes
    return super(IrQWeb, self_website)._get_asset_nodes(bundle, css=css, js=js, debug=debug, async_load=async_load, defer_load=defer_load, lazy_load=lazy_load, media=media)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2433, in _get_asset_nodes
    return self._generate_asset_nodes_cache(bundle, css, js, debug, async_load, defer_load, lazy_load, media)
  File "<decorator-gen-71>", line 2, in _generate_asset_nodes_cache
  File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 90, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2488, in _generate_asset_nodes_cache
    return self._generate_asset_nodes(bundle, css, js, debug, async_load, defer_load, lazy_load, media)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2559, in _generate_asset_nodes
    files, remains = self._get_asset_content(bundle, defer_load=defer_load, lazy_load=lazy_load, media=css and media or None)
  File "<decorator-gen-72>", line 2, in _get_asset_content
  File "/usr/lib/python3/dist-packages/odoo/tools/cache.py", line 90, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 2492, in _get_asset_content
    asset_paths = self.env['ir.asset']._get_asset_paths(bundle=bundle, css=True, js=True)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 121, in _get_asset_paths
    self._fill_asset_paths(bundle, addons, installed, css, js, asset_paths, [])
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 207, in _fill_asset_paths
    process_path(directive, target, path_def)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 167, in process_path
    self._fill_asset_paths(path_def, addons, installed, css, js, asset_paths, seen + [bundle])
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 207, in _fill_asset_paths
    process_path(directive, target, path_def)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 167, in process_path
    self._fill_asset_paths(path_def, addons, installed, css, js, asset_paths, seen + [bundle])
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 211, in _fill_asset_paths
    process_path(asset.directive, asset.target, asset.path)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 179, in process_path
    target_index = asset_paths.index(target_to_index, addon, bundle)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 389, in index
    self._raise_not_found(path, bundle)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_asset.py", line 422, in _raise_not_found
    raise ValueError("File(s) %s not found in bundle %s" % (path, bundle))
ValueError: File(s) /website/static/src/scss/options/user_values.scss not found in bundle web._assets_primary_variables

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 2066, in __call__
    response = request._serve_db()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1653, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 133, in retrying
    result = func()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1681, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1795, in dispatch
    return self.request.registry['ir.http']._dispatch(endpoint)
  File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_http.py", line 237, in _dispatch
    response = super()._dispatch(endpoint)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 156, in _dispatch
    result.flatten()
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1182, in flatten
    self.response.append(self.render())
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1174, in render
    return request.env["ir.ui.view"]._render_template(self.template, self.qcontext)
  File "/usr/lib/python3/dist-packages/odoo/addons/website/models/ir_ui_view.py", line 419, in _render_template
    return super()._render_template(template, values=values)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_ui_view.py", line 2129, in _render_template
    return self.env['ir.qweb']._render(template, values)
  File "/usr/lib/python3/dist-packages/odoo/tools/profiler.py", line 294, in _tracked_method_render
    return method_render(self, template, values, **options)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_qweb.py", line 588, in _render
    result = ''.join(rendering)
  File "<453>", line 39, in template_453
  File "<453>", line 28, in template_453_content
  File "<456>", line 1415, in template_456
odoo.addons.base.models.ir_qweb.QWebException: Error while render the template
ValueError: File(s) /website/static/src/scss/options/user_values.scss not found in bundle web._assets_primary_variables
Template: website.layout
Path: /t/html/head/t[9]
Node: <t t-call-assets="web.assets_frontend" t-js="false"/>
2025-01-29 15:12:19,402 787 INFO *********** werkzeug: ******** - - [29/Jan/2025 15:12:19] "GET / HTTP/1.1" 500 - 173 0.052 0.147

Hope anyone can Help!

Thanks!

Autorius

hi,

thank u, to be honest, I've given up on the project for now; maybe I'll invest a few more hours in it next year.

But thanks fr your advise i will definetly check that next time;

cheers

Cybrosys Techno Solutions Pvt.Ltd

Hi,

The ir_module_module does not exist error is not caused by whitespace but by a registry or module-state issue during startup.

Check that the base module is in state installed in ir_module_module; if not, set it and restart Odoo with -u base.

Make sure the Odoo server version, OpenUpgrade branch, and database version are exactly the same (for example all 16.0).

After the migration, explicitly upgrade core modules by running Odoo with -u web,website --stop-after-init.

The website crash happens because a missing SCSS file is still referenced in ir_asset; remove stale asset records and clear cached asset attachments.

Uninstall old or custom website themes, switch back to the default theme, and only then change header or navigation templates.

Hope it helps.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registracija

Related Posts	Replies	Rodiniai
Asset Management migration V12.0 to new versions migration openupgrade	0 geg. 23	4074
How to set up 2 OpenUpgrade Servers Solved migration openupgrade	1 rugp. 19	6767
Error openupgrade hr module migration openupgrade	1 kov. 15	7867
migration from odoo16 to 17 migration odoo17 odoo16	1 lapkr. 25	3245
Database Migration error from Odoo 14 to 15(Community) using Openeupgrade. migration openupgrade databasemigration	1 geg. 25	4198

This question has been flagged

Enjoying the discussion? Don't just read, join in!