Temporarily, solution 2. increasing the size of the field to 128 alter table procurement_order alter message type character varying(128);
Regards. -- 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 crashes when creating sale order with mrp_jit Status in OpenERP Addons (modules): Confirmed 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 _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
