Odoo Help

Welcome!

This community 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.

0

Sales Analysis Report - Odoo Server Error

By
Mohamed Alsagoff
on 12/12/15, 5:18 AM 984 views

Odoo v9

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

Someone pls help resolve it.

Thanks

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.

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

Yes,

Sales ->  Configuration -> Settings

Clicked

'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.


Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

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