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.

1

ProgrammingError: relation "account_invoice_report" does not exist

By
Marin
on 7/7/15, 12:27 PM 1,153 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

0
Marin
On 7/7/15, 4:04 PM

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

2
Bailey
On 7/13/15, 3:09 AM

Hi

   Put depends in module openerp..

0
Shawn Varghese
On 7/11/15, 4:55 PM

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.


0

Ray Carnes

--Ray Carnes--
15677
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 7/7/15, 2:36 PM

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: 7/7/15, 12:27 PM
Seen: 1153 times
Last updated: 7/13/15, 7:27 AM