Odoo Help


Create contract results in "OpenERP Server Error"

Vitali Quiering
on 12/19/13, 6:01 AM 1,876 views


we are currently evaluating OpenERP and I found this error I couldn't pass. Whenever I create a contract as a user I get the following python error. When I close this error and just create the contract, it works, but how can I avoid this message? It doesn't happen, when I create a contact with the admin account but also when I grant admin rights to my user.

Thank you very much.

Client Traceback (most recent call last): File "/opt/openerp/server/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, *self.params) File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1128, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/opt/openerp/server/openerp/addons/web/controllers/main.py", line 1120, in _call_kw return getattr(req.session.model(model), method)(args, **kwargs) File "/opt/openerp/server/openerp/addons/web/session.py", line 42, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/opt/openerp/server/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/opt/openerp/server/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/opt/openerp/server/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/opt/openerp/server/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/opt/openerp/server/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, params) File "/opt/openerp/server/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/opt/openerp/server/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, args, *kwargs) File "/opt/openerp/server/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/opt/openerp/server/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/opt/openerp/server/openerp/addons/hr_timesheet_invoice/hr_timesheet_invoice.py", line 81, in on_change_partner_id pricelist = part.property_product_pricelist and part.property_product_pricelist.id or False File "/opt/openerp/server/openerp/osv/orm.py", line 494, in __getattr__ return self[name] File "/opt/openerp/server/openerp/osv/orm.py", line 402, in __getitem__ field_values = self._table.read(self._cr, self._uid, ids, field_names, context=self._context, load="_classic_write") File "/opt/openerp/server/openerp/osv/orm.py", line 3620, in read result = self._read_flat(cr, user, select, fields, context, load) File "/opt/openerp/server/openerp/osv/orm.py", line 3678, in _read_flat self.check_access_rule(cr, user, ids, 'read', context=context) File "/opt/openerp/server/openerp/osv/orm.py", line 3928, in check_access_rule [sub_ids] + where_params) File "/opt/openerp/server/openerp/sql_db.py", line 161, in wrapper return f(self, args, *kwargs) File "/opt/openerp/server/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: operator does not exist: integer = boolean LINE 1: ...artner.id FROM "res_partner" WHERE res_partner.id IN (false)... ^ HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

Vitali Quiering
On 12/20/13, 8:14 AM

Does anyone know this? How can I get rid of this?

Torsten Dörschel
On 2/5/14, 10:11 AM

We experience the same problem with our live system (administrated by external OpenERP partner), Version 7.0. Contracts Mgmt. module account_analytic_analysis version Python 2.7.3-0ubuntu2.2 PostgreSQL 9.1+129 Ubuntu 12.04 64bit Server

In a test system with Debian Nightly Builds (Version 7.0-20140205-002759), the problem does not occur. Contracts Mgmt. module account_analytic_analysis version as well. Python 2.7.5-5ubuntu1 PostgreSQL 9.3+146really9.1+148 Ubuntu 13.10 64bit Desktop

Hope someone can find the root of this error. In our live system, you can ignore it and go on creating the contract, but it is annoying for sure.

Erdem Uney
On 3/7/14, 11:21 PM

This was a bug that has been fixed and committed. You just need to upgrade to a current version.

~ 7Gates Interactive Technologies ~ 7gates.co ~ Istanbul - TR

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

2 follower(s)


Asked: 12/19/13, 6:01 AM
Seen: 1876 times
Last updated: 3/16/15, 8:10 AM