Problems Migrating Odoo Sites from v15 -> v16

[fresh0domi]

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!

[pedrobaeza]

This is outside the OpenUpgrade itself. Your instance seems to not accessing the proper DB.

[fresh0domi]

oh sorry;
I will post it directly on odoo.com
Should the page not work at all if the wrong DB is used?

[pedrobaeza]

No, what I'm stating is that it seems your deployment is somehow not correct, but not related with a problem in OpenUpgrade or Odoo itself.

[fresh0domi]

hmm ok thank you!

[fresh0domi]

hello again; since i am not getting closer i need to ask u one more thing cause im thinking that indeed the OpenUpgrader cause the Problem..
Because: the DB is accessed correctly.. im seeing my content when im entering the instanz.. so i dont know how its be possible that i entered the wrong DB.. and i had the same dbfilter "dbfilter = ^%h$" in both odoo versions..
Furthermore some sites are working fine expect for a few small things.. example: the site works till is change the header template.. than the sites crashes and is not accessable anymore..

[pedrobaeza]

Well, the error is saying a file is not found (/website/static/src/scss/options/user_values.scss), so you have to determine why, but without doing a deep audit in your system, it's not possible to go further. I can assure you that OpenUpgrade is working fine on all the instances I have migrated so far, but there's a lot of ways to screw up the DB before migrating that also leads to this result.