Skip to Content
Menu
This question has been flagged
5 Replies
22478 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

Avatar
Discard

Reposted as a comment: FROM christophe mollet: Hello,

I have exactly the same problem.

Did you solve it ?

Best Answer

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.

 

 

 

 

Avatar
Discard
Best Answer

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

Avatar
Discard
Best Answer

Hello,

I have exactly the same problem.

Did you solve it ?

Avatar
Discard
Best Answer

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

Avatar
Discard
Related Posts Replies Views Activity
3
Nov 24
1841
2
Nov 24
257
2
Jun 24
519
2
Jan 24
5010
1
Nov 23
762