Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

ProgrammingError: relation "ir_sequence_001" does not exist ?

By
Ivan Bernikov
on 10/25/13, 6:25 AM 1,253 views

Dear friends, I have just installed Timesheets [hr_timesheet_sheet 7.0.1.0] featured module from OpenERP and when I try to create Analytic Account in my current Timesheet I have the following problem. Please help.

OpenERP Server Error Client Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/http.py", line 204, in dispatch response["result"] = method(self, *self.params) File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1128, in call_kw return self._call_kw(req, model, method, args, kwargs) File "/usr/lib/pymodules/python2.7/openerp/addons/web/controllers/main.py", line 1120, in _call_kw return getattr(req.session.model(model), method)(args, **kwargs) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 42, in proxy result = self.proxy.execute_kw(self.session._db, self.session._uid, self.session._password, self.model, method, args, kw) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 30, in proxy_method result = self.session.send(self.service_name, method, *args) File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 103, in send raise xmlrpclib.Fault(openerp.tools.ustr(e), formatted_info)

Server Traceback (most recent call last): File "/usr/lib/pymodules/python2.7/openerp/addons/web/session.py", line 89, in send return openerp.netsvc.dispatch_rpc(service_name, method, args) File "/usr/lib/pymodules/python2.7/openerp/netsvc.py", line 292, in dispatch_rpc result = ExportService.getService(service_name).dispatch(method, params) File "/usr/lib/pymodules/python2.7/openerp/service/web_services.py", line 626, in dispatch res = fn(db, uid, params) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 188, in execute_kw return self.execute(db, uid, obj, method, *args, *kw or {}) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 131, in wrapper return f(self, dbname, args, *kwargs) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 197, in execute res = self.execute_cr(cr, uid, obj, method, args, *kw) File "/usr/lib/pymodules/python2.7/openerp/osv/osv.py", line 185, in execute_cr return getattr(object, method)(cr, uid, args, *kw) File "/usr/lib/pymodules/python2.7/openerp/osv/orm.py", line 1585, in default_get defaults[f] = self._defaultsf File "/usr/lib/pymodules/python2.7/openerp/addons/analytic/analytic.py", line 245, in <lambda> 'code' : lambda obj, cr, uid, context: obj.pool.get('ir.sequence').get(cr, uid, 'account.analytic.account'), File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_sequence.py", line 307, in get return self.get_id(cr, uid, code, 'code', context) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_sequence.py", line 299, in get_id return self.next_by_code(cr, uid, sequence_code_or_id, context) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_sequence.py", line 284, in next_by_code return self._next(cr, uid, ids, context) File "/usr/lib/pymodules/python2.7/openerp/addons/account/ir_sequence.py", line 57, in _next return super(ir_sequence, self)._next(cr, uid, seq_ids, context) File "/usr/lib/pymodules/python2.7/openerp/addons/base/ir/ir_sequence.py", line 249, in _next cr.execute("SELECT nextval('ir_sequence_%03d')" % seq['id']) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 161, in wrapper return f(self, args, *kwargs) File "/usr/lib/pymodules/python2.7/openerp/sql_db.py", line 226, in execute res = self._obj.execute(query, params) ProgrammingError: relation "ir_sequence_001" does not exist LINE 1: SELECT nextval('ir_sequence_001') ^

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 10/25/13, 6:25 AM
Seen: 1253 times
Last updated: 7/29/16, 3:46 AM