Odoo Help


Sales Analysis Report - Odoo Server Error

Mohamed Alsagoff
on 12/12/15, 5:18 AM 1,785 views

Odoo v9

When i click Sales -> Report -> Sales
i get this (below)

Someone pls help resolve it.


Odoo Server Error
Traceback (most recent call last):
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 605, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 642, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 316, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/service/model.py", line 118, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 309, in checked_call
    result = self.endpoint(*a, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 893, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/http.py", line 471, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 892, in call_kw
    return self._call_kw(model, method, args, kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/addons/web/controllers/main.py", line 884, in _call_kw
    return getattr(request.registry.get(model), method)(request.cr, request.uid, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/api.py", line 238, in wrapper
    return old_api(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/models.py", line 2123, in read_group
    cr.execute(query, where_clause_params)
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 139, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/python2.7/dist-packages/openerp/sql_db.py", line 215, in execute
    res = self._obj.execute(query, params)
ProgrammingError: relation "sale_report" does not exist
LINE 3:             FROM "sale_report" LEFT JOIN "crm_team" as "sale...

Did you uninstall any module recently? This has happened to me earlier when I uninstalled a different module, but for some reason some sales report dependent tables got dropped as well.

ePillars Systems LLC, Shawn Varghese
on 12/12/15, 11:53 AM
Mohamed Alsagoff
On 12/12/15, 1:38 PM


Sales ->  Configuration -> Settings


'Salespeople do not need to view margins when quoting'
from 'Display margins on quotations and sales orders'

Now i clicked back

'Display margins on quotations and sales orders'
apparently seems ok now.

Odoo 9 still has freq bugs.

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 12/12/15, 5:18 AM
Seen: 1785 times
Last updated: 12/12/15, 1:38 PM