Odoo Help


Invalid domain term ('id', 'in', 1) error while converting lead to opportunity

Alexander Mühlstein
on 11/14/13, 7:24 AM 6,792 views


when I try to convert a lead to an opportunity I get the following error message:

OpenERP Server Error
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 1132, in call_button
    action = self._call_kw(req, model, method, args, {})
  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/crm/wizard/crm_lead_to_opportunity.py", line 129, in action_apply
    self._convert_opportunity(cr, uid, ids, {'lead_ids': lead_ids}, context=context)
  File "/opt/openerp/server/openerp/addons/crm/wizard/crm_lead_to_opportunity.py", line 97, in _convert_opportunity
    partner_ids_map = self._create_partner(cr, uid, ids, context=context)
  File "/opt/openerp/server/openerp/addons/crm/wizard/crm_lead_to_opportunity.py", line 147, in _create_partner
    return lead.handle_partner_assignation(cr, uid, lead_ids, data.action, partner_id, context=context)
  File "/opt/openerp/server/openerp/addons/crm/crm_lead.py", line 800, in handle_partner_assignation
    self._lead_set_partner(cr, uid, lead, partner_id, context=context)
  File "/opt/openerp/server/openerp/addons/crm/crm_lead.py", line 774, in _lead_set_partner
    res_partner.write(cr, uid, partner_id, {'section_id': lead.section_id and lead.section_id.id or False})
  File "/opt/openerp/server/openerp/addons/partner_sequence/partner_sequence.py", line 53, in write
    ('ref', 'in', [False, '/']), ('id', 'in', ids)], context=context)
  File "/opt/openerp/server/openerp/osv/orm.py", line 2358, in search
    return self._search(cr, user, args, offset=offset, limit=limit, order=order, context=context, count=count)
  File "/opt/openerp/server/openerp/addons/base/res/res_partner.py", line 593, in _search
    count=count, access_rights_uid=access_rights_uid)
  File "/opt/openerp/server/openerp/osv/orm.py", line 4857, in _search
    query = self._where_calc(cr, user, args, context=context)
  File "/opt/openerp/server/openerp/osv/orm.py", line 4688, in _where_calc
    where_clause, where_params = e.to_sql()
  File "/opt/openerp/server/openerp/osv/expression.py", line 1206, in to_sql
    q, p = self.__leaf_to_sql(leaf)
  File "/opt/openerp/server/openerp/osv/expression.py", line 1131, in __leaf_to_sql
    raise ValueError("Invalid domain term %r" % (leaf,))
ValueError: Invalid domain term ('id', 'in', 1)

Is there a solution for this problem? thanks alex

Reposted as a comment: FROM christophe mollet: Hello,

I have exactly the same problem.

Did you solve it ?

Ray Carnes
on 2/6/14, 3:24 PM
shashank verma
On 8/25/14, 4:53 AM

Hello Alex,

Its just a syntax issue. This issue encountered while specifying wrong domain syntax in XML file.
Lets take an example:

.py file

'sale_id': fields.many2one('sale.order', 'sale order'),

.xml file
#Wrong syntax
<field name="block_id" domain="[('id','in',sale_id)]" colspan="2" />  


<field name="my_field" domain="[('id','in',[sale_id])]" colspan="2" />  

The reason is "IN" operator expecting list of values.





On 7/30/15, 11:12 AM


I've met similar error when replacing categ in product_templte from many2one to many2many. I solved it whith using a new column for saving my many2many categories.



Ray Carnes

--Ray Carnes--
| 9 7 9
Keyport, United States
--Ray Carnes--

Senior ERP Analyst

OpenERP 6.1, 7.0; Odoo 8.0, 9.0, 10.0 and 11.0.

Completed Odoo Functional and Technical Training.

Functional Areas:

  • CRM/Sales

  • Inventory

  • Manufacturing

  • Accounting

  • Purchasing

Major Skills:

  • Business Process Reengineering

  • Efficiency Consulting

  • User Needs and GAP Analysis;

  • Functional and Technical Design;

  • Prototyping and Proof of Concepts;

  • Requirements Specifications;

  • Agile Implementation;

  • Data Migration;

  • Configuration & Customization (UI and code);

  • Integration - Odoo and non Odoo Applications and Services;

  • Training and Knowledge Transfer;

  • Go Live Support;

  • Helpdesk;

  • Version Upgrades and Migration.

  • Accounting Expert.

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. 

I am a skilled Communicator and I only take the serious things seriously!

Ray Carnes
On 2/6/14, 3:24 PM

Reading through your traceback, perhaps the module 'partner_sequence' is causing problems? Uninstall it to verify.

christophe mollet
On 2/5/14, 12:21 PM


I have exactly the same problem.

Did you solve it ?

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: 11/14/13, 7:24 AM
Seen: 6792 times
Last updated: 7/30/15, 11:12 AM