← Back to team overview

openerp-india team mailing list archive

[Bug 1101045] [NEW] [7.0] Stock picking no saved make stock moves crash

 

Public bug reported:

How to reproduce:
1. New demo database
2. create an incoming stock picking (dont save it!)
3. choose supplier (not relevant)
4. create a SM with one product, one quantity
5. save the SM
6. try to edit again the SM line quantity 
7. OpenERP claims for a missing SP id

Client Traceback (most recent call last):
  File "/home/eric/openerp/CVS/7.0/web/addons/web/http.py", line 195, in dispatch
    response["result"] = method(self, **self.params)
  File "/home/eric/openerp/CVS/7.0/web/addons/web/controllers/main.py", line 1078, in call_kw
    return self._call_kw(req, model, method, args, kwargs)
  File "/home/eric/openerp/CVS/7.0/web/addons/web/controllers/main.py", line 1070, in _call_kw
    return getattr(req.session.model(model), method)(*args, **kwargs)
  File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 40, in proxy
    result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
  File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 28, in proxy_method
    result = self.session.send(self.service_name, method, *args)
  File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 101, in send
    raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)


Server Traceback (most recent call last):
  File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 87, in send
    return openerp.netsvc.dispatch_rpc(service_name, method, args)
  File "/home/eric/openerp/CVS/7.0/server/openerp/netsvc.py", line 289, in dispatch_rpc
    result = ExportService.getService(service_name).dispatch(method, params)
  File "/home/eric/openerp/CVS/7.0/server/openerp/service/web_services.py", line 614, in dispatch
    res = fn(db, uid, *params)
  File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 169, in execute_kw
    return self.execute(db, uid, obj, method, *args, **kw or {})
  File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 123, in wrapper
    return f(self, dbname, *args, **kwargs)
  File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 179, in execute
    res = self.execute_cr(cr, uid, obj, method, *args, **kw)
  File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 166, in execute_cr
    return getattr(object, method)(cr, uid, *args, **kw)
  File "/home/eric/openerp/CVS/7.0/addons/stock/stock.py", line 1849, in onchange_quantity
    for move in self.read(cr, uid, ids, ['product_qty']):
  File "/home/eric/openerp/CVS/7.0/server/openerp/osv/orm.py", line 3606, in read
    result = self._read_flat(cr, user, select, fields, context, load)
  File "/home/eric/openerp/CVS/7.0/server/openerp/osv/orm.py", line 3658, in _read_flat
    cr.execute(query, [tuple(sub_ids)] + rule_params)
  File "/home/eric/openerp/CVS/7.0/server/openerp/sql_db.py", line 162, in wrapper
    return f(self, *args, **kwargs)
  File "/home/eric/openerp/CVS/7.0/server/openerp/sql_db.py", line 227, in execute
    res = self._obj.execute(query, params)
DataError: invalid input syntax for integer: "one2many_v_id_304"
LINE 1: ...move.id FROM "stock_move" WHERE stock_move.id IN ('one2many_...
                                                             ^

Implicitely saving the Stockpicking avoids the bug

** 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/1101045

Title:
  [7.0] Stock picking no saved make stock moves crash

Status in OpenERP Addons (modules):
  New

Bug description:
  How to reproduce:
  1. New demo database
  2. create an incoming stock picking (dont save it!)
  3. choose supplier (not relevant)
  4. create a SM with one product, one quantity
  5. save the SM
  6. try to edit again the SM line quantity 
  7. OpenERP claims for a missing SP id

  Client Traceback (most recent call last):
    File "/home/eric/openerp/CVS/7.0/web/addons/web/http.py", line 195, in dispatch
      response["result"] = method(self, **self.params)
    File "/home/eric/openerp/CVS/7.0/web/addons/web/controllers/main.py", line 1078, in call_kw
      return self._call_kw(req, model, method, args, kwargs)
    File "/home/eric/openerp/CVS/7.0/web/addons/web/controllers/main.py", line 1070, in _call_kw
      return getattr(req.session.model(model), method)(*args, **kwargs)
    File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 40, in proxy
      result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw)
    File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 28, in proxy_method
      result = self.session.send(self.service_name, method, *args)
    File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 101, in send
      raise xmlrpclib.Fault(openerp.tools.exception_to_unicode(e), formatted_info)

  
  Server Traceback (most recent call last):
    File "/home/eric/openerp/CVS/7.0/web/addons/web/session.py", line 87, in send
      return openerp.netsvc.dispatch_rpc(service_name, method, args)
    File "/home/eric/openerp/CVS/7.0/server/openerp/netsvc.py", line 289, in dispatch_rpc
      result = ExportService.getService(service_name).dispatch(method, params)
    File "/home/eric/openerp/CVS/7.0/server/openerp/service/web_services.py", line 614, in dispatch
      res = fn(db, uid, *params)
    File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 169, in execute_kw
      return self.execute(db, uid, obj, method, *args, **kw or {})
    File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 123, in wrapper
      return f(self, dbname, *args, **kwargs)
    File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 179, in execute
      res = self.execute_cr(cr, uid, obj, method, *args, **kw)
    File "/home/eric/openerp/CVS/7.0/server/openerp/osv/osv.py", line 166, in execute_cr
      return getattr(object, method)(cr, uid, *args, **kw)
    File "/home/eric/openerp/CVS/7.0/addons/stock/stock.py", line 1849, in onchange_quantity
      for move in self.read(cr, uid, ids, ['product_qty']):
    File "/home/eric/openerp/CVS/7.0/server/openerp/osv/orm.py", line 3606, in read
      result = self._read_flat(cr, user, select, fields, context, load)
    File "/home/eric/openerp/CVS/7.0/server/openerp/osv/orm.py", line 3658, in _read_flat
      cr.execute(query, [tuple(sub_ids)] + rule_params)
    File "/home/eric/openerp/CVS/7.0/server/openerp/sql_db.py", line 162, in wrapper
      return f(self, *args, **kwargs)
    File "/home/eric/openerp/CVS/7.0/server/openerp/sql_db.py", line 227, in execute
      res = self._obj.execute(query, params)
  DataError: invalid input syntax for integer: "one2many_v_id_304"
  LINE 1: ...move.id FROM "stock_move" WHERE stock_move.id IN ('one2many_...
                                                               ^

  Implicitely saving the Stockpicking avoids the bug

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


Follow ups

References