Hi Quentin, thanks for the feedback! Keep us updated if you find any other issues.
-- You received this bug notification because you are a member of OpenUpgrade Committers, which is subscribed to OpenUpgrade Server. https://bugs.launchpad.net/bugs/1045388 Title: ir.sequence does not exist Status in OpenUpgrade Server: Invalid Bug description: Versions ------------ openupgrade-server : rev 3990 openupgrade-addons : rev 6605 Description ---------------- I try to duplicate a sale order or to validate an invoice and the system crashes with this beautiful error : Server Traceback (most recent call last): File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/web/common/http.py", line 593, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/home/quentin/.virtualenvs/nqi/server/openerp/netsvc.py", line 360, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/home/quentin/.virtualenvs/nqi/server/openerp/service/web_services.py", line 586, in dispatch res = fn(db, uid, *params) File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 121, in wrapper return f(self, dbname, *args, **kwargs) File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 196, in exec_workflow res = self.exec_workflow_cr(cr, uid, obj, method, *args) File "/home/quentin/.virtualenvs/nqi/server/openerp/osv/osv.py", line 189, in exec_workflow_cr return wf_service.trg_validate(uid, obj, args[0], method, cr) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_service.py", line 124, in trg_validate res2 = instance.validate(cr, id, ident, signal) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/instance.py", line 48, in validate workitem.process(cr, witem, ident, signal, force_running, stack=stack) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 61, in process ok = _split_test(cr, workitem, activity['split_mode'], ident, signal, stack) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 176, in _split_test _join_test(cr, t[0], t[1], ident, stack) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 184, in _join_test create(cr,[activity], inst_id, ident, stack) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 41, in create process(cr, res, ident, stack=stack) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 53, in process result = _execute(cr, workitem, activity, ident, stack) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/workitem.py", line 107, in _execute returned_action = wkf_expr.execute(cr, ident, workitem, activity) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 68, in execute return _eval_expr(cr, ident, workitem, activity['action']) File "/home/quentin/.virtualenvs/nqi/server/openerp/workflow/wkf_expr.py", line 58, in _eval_expr ret = eval(line, env, nocopy=True) File "/home/quentin/.virtualenvs/nqi/server/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 "/home/quentin/.virtualenvs/nqi/server/openerp/osv/orm.py", line 368, in function_proxy return attr(self._cr, self._uid, [self._id], *args, **kwargs) File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account_invoice.py", line 961, in action_move_create move_obj.post(cr, uid, [move_id], context=ctx) File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/account.py", line 1327, in post new_name = obj_sequence.next_by_id(cr, uid, journal.sequence_id.id, c) File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 216, in next_by_id return self._next(cr, uid, ids, context) File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/account/ir_sequence.py", line 57, in _next return super(ir_sequence, self)._next(cr, uid, seq_ids, context) File "/home/quentin/.virtualenvs/openerp-server-6.1/local/lib/python2.7/site-packages/openerp-6.1_20120902_231958-py2.7.egg/openerp/addons/base/ir/ir_sequence.py", line 201, in _next cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id']) File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 152, in wrapper return f(self, *args, **kwargs) File "/home/quentin/.virtualenvs/nqi/server/openerp/sql_db.py", line 212, in execute res = self._obj.execute(query, params) ProgrammingError: relation "ir_sequence_007" does not exist LINE 1: SELECT nextval('ir_sequence_007') Additional information ------------------------------- I've done the migration with a 6.0 database and you can find in attachment my opener-server.conf and logfile of the migration After the pg_restore I had to run these commands: * ALTER TABLE ir_model_fields ADD column serialization_field_id int references ir_model_fields on delete cascade; * UPDATE ir_module_module set certificate=NULL; Regards, To manage notifications about this bug go to: https://bugs.launchpad.net/openupgrade-server/+bug/1045388/+subscriptions -- Mailing list: https://launchpad.net/~credativ Post to : [email protected] Unsubscribe : https://launchpad.net/~credativ More help : https://help.launchpad.net/ListHelp
