This question has been flagged
4 Replies
6679 Views

Hi

I am getting this error when going to sales:



Odoo Server Error

Traceback (most recent call last):

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 537, in _handle_exception

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 574, in dispatch

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 310, in _call_function

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

File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 113, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 307, in checked_call

return self.endpoint(*a, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 803, in __call__

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

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 403, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 884, in search_read

return self.do_search_read(model, fields, offset, limit, domain, sort)

File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 905, in do_search_read

request.context)

File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 908, in proxy

result = meth(cr, request.uid, *args, **kw)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 5144, in search_read

result = self.read(cr, uid, record_ids, fields, context=read_ctx)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3139, in read

result = BaseModel.read(records, fields, load=load)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3174, in read

self._read_from_database(stored, inherited)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 239, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 3352, in _read_from_database

res2 = self._columns[f].get(cr, self._model, ids, f, user, context=context, values=result)

File "/usr/lib/python2.7/dist-packages/openerp/osv/fields.py", line 1466, in get

result = self._fnct(obj, cr, uid, ids, name, self._arg, context)

File "/usr/lib/python2.7/dist-packages/openerp/addons/sale/sales_team.py", line 39, in _get_invoices_data

values = self.__get_bar_values(cr, uid, obj, created_domain, ['price_total', 'date'], 'price_total', 'date', context=context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/addons/sales_team/sales_team.py", line 58, in __get_bar_values

group_obj = obj.read_group(cr, uid, domain, read_fields, groupby_field, context=context)

File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 241, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 2140, in read_group

cr.execute(query, where_clause_params)

File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 158, in wrapper

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

File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 234, in execute

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

ProgrammingError: relation "account_invoice_report" does not exist

LINE 3: FROM "account_invoice_report"

^



Can you maybe help me?
Thanks

Avatar
Discard
Author Best Answer

I have but it did not help, reinstall of sales module helped

Avatar
Discard
Best Answer

Hi

   Put depends in module openerp..

Avatar
Discard
Best Answer

I faced this issue too. For me it happened when I uninstalled the Sales module. It seems this particular table - account_invoice_report gets uninstalled as well, which is incorrect. If you don't install Sales module at all, I think it works fine. But once you install it, you cannot uninstall it or this error might crop up.

I saw a link recently that mentioned how you can manually recreate the account_invoice_report table if no other solution works out....I'll post it here if I find it.


Avatar
Discard
Best Answer

Have you searched for an existing question that may help?

Such as https://www.odoo.com/forum/help-1/question/programmingerror-relation-account-invoice-report-does-not-exist-45472



Avatar
Discard