openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #13243
[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
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Launchpad Bug Tracker, 2013-01-25
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Amit Dodiya (OpenERP), 2013-01-02
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Vinay Rana (openerp), 2012-12-31
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: José Blanco -- BLB Software, 2012-09-17
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Serpent Consulting Services, 2012-08-04
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Damián Soriano, 2012-07-05
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Serpent Consulting Services, 2012-07-05
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Damián Soriano, 2012-07-05
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Serpent Consulting Services, 2012-07-03
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Damián Soriano, 2012-07-03
-
[Bug 1020615] Re: New database crashes when creating sale order with mrp_jit
From: Serpent Consulting Services, 2012-07-03
-
[Bug 1020615] [NEW] New database crushes when creating sale order with mrp_jit
From: Damián Soriano, 2012-07-03
References