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

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

crm
By
Alexander Mühlstein
on 11/14/13, 7:24 AM 4,332 views

Hello,

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 ?

Bista Solutions US, Ray Carnes
on 2/6/14, 3:24 PM
1
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" />  

#Correction

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

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

 

 

 

 

0
David Verove
On 7/30/15, 11:12 AM

Hello,

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.

David

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

Hello,

I have exactly the same problem.

Did you solve it ?

0

Ray Carnes

--Ray Carnes--
15697
| 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 2/6/14, 3:24 PM

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

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

2 follower(s)

Stats

Asked: 11/14/13, 7:24 AM
Seen: 4332 times
Last updated: 7/30/15, 11:12 AM