← Back to team overview

openerp-india team mailing list archive

[Bug 1020615] [NEW] New database crushes when creating sale order with mrp_jit

 

Public bug reported:

I have installed on OpenERP v6.1 (last nightly build: OpenERP Server
6.1-20120702-233311) on Ubuntu 10.04 and PostgreSQL 9.1.4.

1) I create a new instance of OpenERP.
2) Install module mrp_jit.
3) Create an product with type 'product' that does not have any stock.
4) I create a new sale order and a sale order line pointing to that product.
5) When I try to confirm the sale order I get the following error:


Client Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
    response["result"] = method(controller, self, **self.params)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1054, in exec_workflow
    r = req.session.exec_workflow(model, id, signal)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/session.py", line 100, in exec_workflow
    r = self.proxy('object').exec_workflow(self._db, self._uid, self._password, model, signal, id)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
    result = self.connector.send(self.service_name, method, *args)
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 611, in send
    raise fault


Server Traceback (most recent call last):
  File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 592, in send
    result = openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 586, in dispatch
    res = fn(db, uid, *params)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 196, in exec_workflow
    res = self.exec_workflow_cr(cr, uid, obj, method, *args)
  File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 189, in exec_workflow_cr
    return wf_service.trg_validate(uid, obj, args[0], method, cr)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_service.py", line 124, in trg_validate
    res2 = instance.validate(cr, id, ident, signal)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/instance.py", line 48, in validate
    workitem.process(cr, witem, ident, signal, force_running, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 53, in process
    result = _execute(cr, workitem, activity, ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 107, in _execute
    returned_action = wkf_expr.execute(cr, ident, workitem, activity)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 68, in execute
    return _eval_expr(cr, ident, workitem, activity['action'])
  File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
    ret = eval(line, env, nocopy=True)
  File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
    return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 368, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 862, in action_ship_create
    self._create_pickings_and_procurements(cr, uid, order, order.order_line, None, context=context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 845, in _create_pickings_and_procurements
    wf_service.trg_validate(uid, 'procurement.order', proc_id, 'button_confirm', cr)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_service.py", line 124, in trg_validate
    res2 = instance.validate(cr, id, ident, signal)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/instance.py", line 48, in validate
    workitem.process(cr, witem, ident, signal, force_running, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
    _join_test(cr, t[0], t[1], ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
    create(cr,[activity], inst_id, ident, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
    process(cr, res, ident, stack=stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
    ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
  File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 158, in _split_test
    if wkf_expr.check(cr, workitem, ident, transition,signal):
  File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 81, in check
    return _eval_expr(cr, ident, workitem, transition['condition'])
  File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
    ret = eval(line, env, nocopy=True)
  File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
    return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
  File "", line 1, in <module>
  File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 368, in function_proxy
    return attr(self._cr, self._uid, [self._id], *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/addons/procurement/procurement.py", line 255, in check_make_to_stock
    ok = ok and self._check_make_to_stock_product(cr, uid, procurement, context)
  File "/usr/lib/pymodules/python2.7/openerp/addons/procurement/procurement.py", line 387, in _check_make_to_stock_product
    cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
    res = self._obj.execute(query, params)
DataError: value too long for type character varying(64)

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1020615

Title:
  New database crushes when creating sale order with mrp_jit

Status in OpenERP Addons (modules):
  New

Bug description:
  I have installed on OpenERP v6.1 (last nightly build: OpenERP Server
  6.1-20120702-233311) on Ubuntu 10.04 and PostgreSQL 9.1.4.

  1) I create a new instance of OpenERP.
  2) Install module mrp_jit.
  3) Create an product with type 'product' that does not have any stock.
  4) I create a new sale order and a sale order line pointing to that product.
  5) When I try to confirm the sale order I get the following error:

  
  Client Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 180, in dispatch
      response["result"] = method(controller, self, **self.params)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1054, in exec_workflow
      r = req.session.exec_workflow(model, id, signal)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/session.py", line 100, in exec_workflow
      r = self.proxy('object').exec_workflow(self._db, self._uid, self._password, model, signal, id)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/openerplib/main.py", line 117, in proxy
      result = self.connector.send(self.service_name, method, *args)
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 611, in send
      raise fault

  
  Server Traceback (most recent call last):
    File "/usr/lib/pymodules/python2.7/openerp/addons/web/common/http.py", line 592, in send
      result = openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 360, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 586, in dispatch
      res = fn(db, uid, *params)
    File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 121, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 196, in exec_workflow
      res = self.exec_workflow_cr(cr, uid, obj, method, *args)
    File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 189, in exec_workflow_cr
      return wf_service.trg_validate(uid, obj, args[0], method, cr)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_service.py", line 124, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 53, in process
      result = _execute(cr, workitem, activity, ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 107, in _execute
      returned_action = wkf_expr.execute(cr, ident, workitem, activity)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 68, in execute
      return _eval_expr(cr, ident, workitem, activity['action'])
    File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
      return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
    File "", line 1, in <module>
    File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 368, in function_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 862, in action_ship_create
      self._create_pickings_and_procurements(cr, uid, order, order.order_line, None, context=context)
    File "/usr/lib/pymodules/python2.7/openerp/addons/sale/sale.py", line 845, in _create_pickings_and_procurements
      wf_service.trg_validate(uid, 'procurement.order', proc_id, 'button_confirm', cr)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_service.py", line 124, in trg_validate
      res2 = instance.validate(cr, id, ident, signal)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/instance.py", line 48, in validate
      workitem.process(cr, witem, ident, signal, force_running, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 176, in _split_test
      _join_test(cr, t[0], t[1], ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 184, in _join_test
      create(cr,[activity], inst_id, ident, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 41, in create
      process(cr, res, ident, stack=stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 61, in process
      ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack)
    File "/usr/lib/pymodules/python2.7/openerp/workflow/workitem.py", line 158, in _split_test
      if wkf_expr.check(cr, workitem, ident, transition,signal):
    File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 81, in check
      return _eval_expr(cr, ident, workitem, transition['condition'])
    File "/usr/lib/pymodules/python2.7/openerp/workflow/wkf_expr.py", line 58, in _eval_expr
      ret = eval(line, env, nocopy=True)
    File "/usr/lib/pymodules/python2.7/openerp/tools/safe_eval.py", line 241, in safe_eval
      return eval(test_expr(expr,_SAFE_OPCODES, mode=mode), globals_dict, locals_dict)
    File "", line 1, in <module>
    File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 368, in function_proxy
      return attr(self._cr, self._uid, [self._id], *args, **kwargs)
    File "/usr/lib/pymodules/python2.7/openerp/addons/procurement/procurement.py", line 255, in check_make_to_stock
      ok = ok and self._check_make_to_stock_product(cr, uid, procurement, context)
    File "/usr/lib/pymodules/python2.7/openerp/addons/procurement/procurement.py", line 387, in _check_make_to_stock_product
      cr.execute('update procurement_order set message=%s where id=%s', (message, procurement.id))
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 152, in wrapper
      return f(self, *args, **kwargs)
    File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 212, in execute
      res = self._obj.execute(query, params)
  DataError: value too long for type character varying(64)

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1020615/+subscriptions


Follow ups

References