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...
^
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Accounting
- Inventory
- PoS
- Project management
- MRP
This question has been flagged
It seems "Payroll Accounting" module is not updated.
can you update/install Payroll Accounting (hr_payroll_account) module and try again
do you using restored database or create new database.?
usually sequence error is because the diferent version of postgresql
@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 ?
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;
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 🙏
Enjoying the discussion? Don't just read, join in!
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign upRelated Posts | Replies | Views | Activity | |
---|---|---|---|---|
|
1
Dec 24
|
389 | ||
|
0
Nov 24
|
107 | ||
|
1
Jul 24
|
4034 | ||
|
2
Jun 24
|
3466 | ||
|
1
Dec 23
|
448 |
Please use a meaningful title and proper formatting.