Skip to Content
Menu
This question has been flagged

I am a beginner using odoo version 11. The module I use is Payroll. When I create data and save it, this error appears with the following code. 

how can I solved this ? Thankyou 

Traceback (most recent call last):
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 651, in _handle_exception
return super(JsonRequest, self)._handle_exception(exception)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 310, in _handle_exception
raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\tools\pycompat.py", line 87, in reraise
raise value
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 693, in dispatch
result = self._call_function(**self.params)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 342, in _call_function
return checked_call(self.db, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\service\model.py", line 97, in wrapper
return f(dbname, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 335, in checked_call
result = self.endpoint(*a, **kw)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 937, in __call__
return self.method(*args, **kw)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\http.py", line 515, in response_wrap
response = f(*args, **kw)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\web\controllers\main.py", line 934, in call_kw
return self._call_kw(model, method, args, kwargs)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\web\controllers\main.py", line 926, in _call_kw
return call_kw(request.env[model], method, args, kwargs)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\api.py", line 687, in call_kw
return call_kw_model(method, model, args, kwargs)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\api.py", line 672, in call_kw_model
result = method(recs, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\addons\hr_payroll_account\models\hr_payroll_account.py", line 40, in create
return super(HrPayslip, self).create(vals)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\models.py", line 3372, in create
record = self.browse(self._create(old_vals))
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\models.py", line 3465, in _create
cr.execute(query, tuple(u[2] for u in updates if len(u) > 2))
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 155, in wrapper
return f(self, *args, **kwargs)
File "C:\Program Files (x86)\Odoo 11.0\server\odoo\sql_db.py", line 232, in execute
res = self._obj.execute(query, params)
psycopg2.ProgrammingError: relasi « hr_payslip_id_seq » tidak ada
LINE 1: ...uid", "create_date", "write_date") VALUES(nextval('hr_paysli...
^


Avatar
Discard

Please use a meaningful title and proper formatting.

Best Answer

It seems "Payroll Accounting" module is not updated.
can you update/install Payroll Accounting (hr_payroll_account) module and try again

Avatar
Discard
Best Answer

do you using restored database or create new database.?

usually sequence error is because the diferent version of postgresql

Avatar
Discard
Author Best Answer

@alvinadjiei Saya menggunakan restore database. Kemudian, saya mengembalikan ke pc lain dan saya menemukan eror ini. 


@Ravi .. Yes i want to do this. But the situasion is i have some data entry in payroll.. So, if it update then everything is lost ? 

Avatar
Discard

as i though you are restoring it from another pc. kemungkinan postgresnya beda versi jadi muncil error ini

kalo kamu pake pgadmin bisa execute query ini atau kalo ga pake pg admin bisa execute query lewat terminal. tau caranya kan?:

CREATE SEQUENCE public.hr_payslip_id_seq

INCREMENT 1

MINVALUE 1

MAXVALUE 9223372036854775807

START 1

CACHE 1;

ALTER TABLE public.hr_payslip_id_seq

OWNER TO nama_owner_odoo;

Author

Iya, pak. Hehe

Baik pak untuk executenya ini, setelah dB-nya di restore - buka pg admin - connect ke db yg diinstal - lalu run kodenya ya ?

Kalau lewat cmd sya kurang tau pnggunaanya pak

Sebelumnya terimakasih pak, saya akan mencobannya 🙏

Related Posts Replies Views Activity
1
Dec 24
389
0
Nov 24
107
1
Jul 24
4034
2
Jun 24
3466
1
Dec 23
448