Hi dear Team,

I am testing Odoo 16 on debian 10 with Postgresql 11.22

Here below issue face when I want to open customers our suppliers  for to update  some details as Phone number, customers account as per chart of account or any others details.

Would you mind to help me about this topic?

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 989, in get
    cache_value = field_cache[record._ids[0]]
KeyError: 14

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1160, in __get__
    value = env.cache.get(record, self)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 996, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: 'res.partner(14,).total_invoiced'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1589, 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 1616, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 1820, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/usr/lib/python3/dist-packages/odoo/addons/base/models/ir_http.py", line 154, in _dispatch
    result = endpoint(**request.params)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 697, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 42, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 466, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/usr/lib/python3/dist-packages/odoo/api.py", line 453, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2989, in read
    return self._read_format(fnames=fields, load=load)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 3168, in _read_format
    vals[name] = convert(record[name], record, use_name_get)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 5904, in __getitem__
    return self._fields[key].__get__(self, type(self))
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1209, in __get__
    self.compute_value(recs)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1391, in compute_value
    records._compute_field_value(self)
  File "/usr/lib/python3/dist-packages/odoo/addons/mail/models/mail_thread.py", line 403, in _compute_field_value
    return super()._compute_field_value(field)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4225, in _compute_field_value
    fields.determine(field.compute, self)
  File "/usr/lib/python3/dist-packages/odoo/fields.py", line 97, in determine
    return needle(*args)
  File "/usr/lib/python3/dist-packages/odoo/addons/account/models/partner.py", line 393, in _invoice_total
    price_totals = self.env['account.invoice.report'].read_group(domain, ['price_subtotal'], ['partner_id'])
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2196, in read_group
    result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 2327, in _read_group_raw
    self._cr.execute(query, where_clause_params)
  File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 321, in execute
    res = self._obj.execute(query, params)
psycopg2.ProgrammingError: ERREUR:  erreur de syntaxe sur ou près de « MATERIALIZED »
LIGNE 5 :             AS MATERIALIZED
                         ^


The above server error caused the following client error:
null

 Regards