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:
nullRegards
