RPC_ERROR

Odoo Server Error

Traceback (most recent call last):

File "/home/odoo/src/odoo/odoo/api.py", line 984, in get

cache_value = field_cache[record._ids[0]]

KeyError: 51675

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/src/odoo/odoo/fields.py", line 1160, in __get__

value = env.cache.get(record, self)

File "/home/odoo/src/odoo/odoo/api.py", line 991, in get

raise CacheMiss(record, field)

odoo.exceptions.CacheMiss: 'product.template(51675,).sales_count'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/src/odoo/odoo/api.py", line 984, in get

cache_value = field_cache[record._ids[0]]

KeyError: 27176

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/src/odoo/odoo/fields.py", line 1160, in __get__

value = env.cache.get(record, self)

File "/home/odoo/src/odoo/odoo/api.py", line 991, in get

raise CacheMiss(record, field)

odoo.exceptions.CacheMiss: 'product.product(27176,).sales_count'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/home/odoo/src/odoo/odoo/http.py", line 1584, in _serve_db

return service_model.retrying(self._serve_ir_http, self.env)

File "/home/odoo/src/odoo/odoo/service/model.py", line 133, in retrying

result = func()

File "/home/odoo/src/odoo/odoo/http.py", line 1611, in _serve_ir_http

response = self.dispatcher.dispatch(rule.endpoint, args)

File "/home/odoo/src/odoo/odoo/http.py", line 1815, in dispatch

result = self.request.registry['ir.http']._dispatch(endpoint)

File "/home/odoo/src/odoo/addons/website/models/ir_http.py", line 235, in _dispatch

response = super()._dispatch(endpoint)

File "/home/odoo/src/odoo/odoo/addons/base/models/ir_http.py", line 154, in _dispatch

result = endpoint(**request.params)

File "/home/odoo/src/odoo/odoo/http.py", line 697, in route_wrapper

result = endpoint(self, *args, **params_ok)

File "/home/odoo/src/odoo/addons/web/controllers/dataset.py", line 42, in call_kw

return self._call_kw(model, method, args, kwargs)

File "/home/odoo/src/odoo/addons/web/controllers/dataset.py", line 33, in _call_kw

return call_kw(request.env[model], method, args, kwargs)

File "/home/odoo/src/odoo/odoo/api.py", line 461, in call_kw

result = _call_kw_multi(method, model, args, kwargs)

File "/home/odoo/src/odoo/odoo/api.py", line 448, in _call_kw_multi

result = method(recs, *args, **kwargs)

File "/home/odoo/src/odoo/odoo/models.py", line 2982, in read

return self._read_format(fnames=fields, load=load)

File "/home/odoo/src/odoo/odoo/models.py", line 3154, in _read_format

vals[name] = convert(record[name], record, use_name_get)

File "/home/odoo/src/odoo/odoo/models.py", line 5876, in __getitem__

return self._fields[key].__get__(self, type(self))

File "/home/odoo/src/odoo/odoo/fields.py", line 1209, in __get__

self.compute_value(recs)

File "/home/odoo/src/odoo/odoo/fields.py", line 1387, in compute_value

records._compute_field_value(self)

File "/home/odoo/src/odoo/addons/mail/models/mail_thread.py", line 403, in _compute_field_value

return super()._compute_field_value(field)

File "/home/odoo/src/odoo/odoo/models.py", line 4211, in _compute_field_value

fields.determine(field.compute, self)

File "/home/odoo/src/odoo/odoo/fields.py", line 97, in determine

return needle(*args)

File "/home/odoo/src/odoo/addons/sale/models/product_template.py", line 61, in _compute_sales_count

product.sales_count = float_round(sum([p.sales_count for p in product.with_context(active_test=False).product_variant_ids]), precision_rounding=product.uom_id.rounding)

File "/home/odoo/src/odoo/addons/sale/models/product_template.py", line 61, in

product.sales_count = float_round(sum([p.sales_count for p in product.with_context(active_test=False).product_variant_ids]), precision_rounding=product.uom_id.rounding)

File "/home/odoo/src/odoo/odoo/fields.py", line 1209, in __get__

self.compute_value(recs)

File "/home/odoo/src/odoo/odoo/fields.py", line 1387, in compute_value

records._compute_field_value(self)

File "/home/odoo/src/odoo/addons/mail/models/mail_thread.py", line 403, in _compute_field_value

return super()._compute_field_value(field)

File "/home/odoo/src/odoo/odoo/models.py", line 4211, in _compute_field_value

fields.determine(field.compute, self)

File "/home/odoo/src/odoo/odoo/fields.py", line 97, in determine

return needle(*args)

File "/home/odoo/src/odoo/addons/sale/models/product_product.py", line 28, in _compute_sales_count

for group in self.env['sale.report']._read_group(domain, ['product_id', 'product_uom_qty'], ['product_id']):

File "/home/odoo/src/odoo/odoo/models.py", line 2148, in _read_group

return self.read_group(domain, fields, groupby, offset, limit, orderby, lazy)

File "/home/odoo/src/enterprise/sale_enterprise/report/sale_report.py", line 53, in read_group

res = super(SaleReport, self).read_group(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy)

File "/home/odoo/src/odoo/odoo/models.py", line 2188, in read_group

result = self._read_group_raw(domain, fields, groupby, offset=offset, limit=limit, orderby=orderby, lazy=lazy)

File "/home/odoo/src/odoo/odoo/models.py", line 2319, in _read_group_raw

self._cr.execute(query, where_clause_params)

File "/home/odoo/src/odoo/odoo/sql_db.py", line 321, in execute

res = self._obj.execute(query, params)

psycopg2.errors.SyntaxError: each UNION query must have the same number of columns

LINE 113: -MIN(l.id) AS id,

^

The above server error caused the following client error:

null