Skip to Content
This question has been flagged
sale.order
1 Respondre
3189 Vistes
Avatar
Edi Rahmadi

I have error when I wan edit product in Inventory and POS, relation "sale_report" does not exist



Error:

Odoo Server Error

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 936, in __get__

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

File "/usr/lib/python3/dist-packages/odoo/api.py", line 960, in get

value = self._data[field][record.id][key]

KeyError: <odoo.api.Environment object at 0x7f7d56772be0>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 936, in __get__

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

File "/usr/lib/python3/dist-packages/odoo/api.py", line 960, in get

value = self._data[field][record.id][key]

KeyError: <odoo.api.Environment object at 0x7f7d56772be0>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/http.py", line 647, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 307, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 87, in reraise

raise value

File "/usr/lib/python3/dist-packages/odoo/http.py", line 689, in dispatch

result = self._call_function(**self.params)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 97, in wrapper

return f(dbname, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 332, in checked_call

result = self.endpoint(*a, **kw)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 933, in __call__

return self.method(*args, **kw)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 512, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 930, in call_kw

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

File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 922, in _call_kw

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

File "/usr/lib/python3/dist-packages/odoo/api.py", line 689, in call_kw

return call_kw_multi(method, model, args, kwargs)

File "/usr/lib/python3/dist-packages/odoo/api.py", line 680, in call_kw_multi

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

File "/usr/lib/python3/dist-packages/odoo/models.py", line 2535, in read

values[name] = field.convert_to_read(record[name], record, use_name_get)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 4675, in __getitem__

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

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 940, in __get__

self.determine_value(record)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in determine_value

self.compute_value(recs)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1007, in compute_value

self._compute_value(records)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 998, in _compute_value

getattr(records, self.compute)()

File "/usr/lib/python3/dist-packages/odoo/addons/sale/models/product_template.py", line 27, in _sales_count

product.sales_count = sum([p.sales_count for p in product.product_variant_ids])

File "/usr/lib/python3/dist-packages/odoo/addons/sale/models/product_template.py", line 27, in <listcomp>

product.sales_count = sum([p.sales_count for p in product.product_variant_ids])

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 940, in __get__

self.determine_value(record)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1051, in determine_value

self.compute_value(recs)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1007, in compute_value

self._compute_value(records)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 998, in _compute_value

getattr(records, self.compute)()

File "/usr/lib/python3/dist-packages/odoo/addons/sale/models/product_product.py", line 19, in _sales_count

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

File "/usr/lib/python3/dist-packages/odoo/models.py", line 1843, 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 1933, in _read_group_raw

self._cr.execute(query, where_clause_params)

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 155, in wrapper

return f(self, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 232, in execute

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

psycopg2.ProgrammingError: relation "sale_report" does not exist

LINE 3: FROM "sale_report" LEFT JOIN "product_product" a...

^

Avatar
Descartar
Ermin Trevisan

It works in standard Odoo.

Avatar
Bhavin Patel
Best Answer

The error message you are receiving suggests that there is an issue with the "sale_report" relation, which is used by the "sales_count" field in the "product.product" model. Specifically, the error indicates that the "sale_report" relation does not exist.

This could be caused by a few different things, such as a missing or incorrect module installation, a database inconsistency, or an issue with the codebase itself. Here are a few steps you can take to try and resolve the issue:

  1. Check your module installations: If you recently installed a new module or updated an existing one, it's possible that there was an error during the installation process that caused the "sale_report" relation to not be created properly. Check the module's installation log and verify that it installed without errors. You may also want to try reinstalling the module to see if that resolves the issue.

  2. Verify your database consistency: It's possible that there is a problem with your database that is preventing the "sale_report" relation from being created properly. You can use Odoo's built-in database management tools to check for and repair any inconsistencies. To do this, navigate to the "Settings" menu in Odoo, click "Technical" in the top-right corner, then select "Database Structure" > "Database Integrity". This will run a check on your database and display any inconsistencies that are found. If any inconsistencies are found, you can use the "Repair" button to fix them.

  3. Check the codebase: If neither of the above steps resolves the issue, it's possible that there is a problem with the codebase itself. Check the source code for the "product.product" model and verify that the "sales_count" field is defined correctly and that it references the "sale_report" relation properly. If you're not comfortable with modifying the codebase yourself, you may want to reach out to the Odoo community or a developer for assistance.

Hopefully one of these steps will help you resolve the issue.

Avatar
Descartar
Related Posts Respostes Vistes Activitat
Display field only for one company on list view Solved
sale.order
Avatar
Avatar
1
de maig 25
1992
Sale order Balance
sale.order
Avatar
Avatar
Avatar
2
de nov. 24
2977
Mark a sales order as fully invoiced despite Order amount and invoiced amount do not match () Solved
sale.order
Avatar
Avatar
Avatar
Avatar
Avatar
4
de febr. 24
13765
sale / delivery Solved
sale.order
Avatar
Avatar
1
de gen. 24
2405
signature and stamp / sale order
sale.order
Avatar
0
de maig 23
2621