Semua Post Orang Lencana-Lencana

Label (Lihat semua)

Mengenai forum ini

Help

Move DB to other Server

views db employees v13

2 Replies

4981 Tampilan

Philip Häderli, Philip Häderli

odoo 13, Ubuntu Server 18.04

the DB was exported via odoo DB Manager and imported to the new server, DB name is dap

The following commands were executed on the new server

- su - postgres

- /usr/bin/odoo -u all -d dap; takes about 30 minutes

when opening an employee in list or kanban I get the following error

Error:

Odoo Server Error

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/api.py", line 745, in get

value = self._data[field][record._ids[0]]

KeyError: 1154

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1037, in __get__

value = env.cache.get(record, self)

File "/usr/lib/python3/dist-packages/odoo/api.py", line 751, in get

raise CacheMiss(record, field)

odoo.exceptions.CacheMiss: ('hr.employee.public(1154,).company_id', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):

File "/usr/lib/python3/dist-packages/odoo/http.py", line 624, in _handle_exception

return super(JsonRequest, self)._handle_exception(exception)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 310, in _handle_exception

raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])

File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 14, in reraise

raise value

File "/usr/lib/python3/dist-packages/odoo/http.py", line 669, in dispatch

result = self._call_function(**self.params)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 350, in _call_function

return checked_call(self.db, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper

return f(dbname, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in checked_call

result = self.endpoint(*a, **kw)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 915, in __call__

return self.method(*args, **kw)

File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap

response = f(*args, **kw)

File "/usr/lib/python3/dist-packages/odoo/addons/hr_org_chart/controllers/hr_org_chart.py", line 55, in get_org_chart

employee = self._check_employee(employee_id, **kw)

File "/usr/lib/python3/dist-packages/odoo/addons/hr_org_chart/controllers/hr_org_chart.py", line 27, in _check_employee

Employee.browse(employee_id).check_access_rule('read')

File "/usr/lib/python3/dist-packages/odoo/models.py", line 3279, in check_access_rule

invalid = self - self._filter_access_rules_python(operation)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 3348, in _filter_access_rules_python

return self.sudo().filtered_domain(dom or [])

File "/usr/lib/python3/dist-packages/odoo/models.py", line 5377, in filtered_domain

data = rec.mapped(key)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 5307, in mapped

recs = recs._mapped_func(operator.itemgetter(name))

File "/usr/lib/python3/dist-packages/odoo/models.py", line 5266, in _mapped_func

vals = [func(rec) for rec in self]

File "/usr/lib/python3/dist-packages/odoo/models.py", line 5266, in <listcomp>

vals = [func(rec) for rec in self]

File "/usr/lib/python3/dist-packages/odoo/models.py", line 5731, in __getitem__

return self._fields[key].__get__(self, type(self))

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 2366, in __get__

return super().__get__(records, owner)

File "/usr/lib/python3/dist-packages/odoo/fields.py", line 1044, in __get__

recs._fetch_field(self)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 2994, in _fetch_field

self._read(fnames)

File "/usr/lib/python3/dist-packages/odoo/models.py", line 3066, in _read

cr.execute(query_str, params)

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 173, in wrapper

return f(self, *args, **kwargs)

File "/usr/lib/python3/dist-packages/odoo/sql_db.py", line 250, in execute

res = self._obj.execute(query, params)

psycopg2.errors.InsufficientPrivilege: permission denied for view hr_employee_public

Philip Häderli, Philip Häderli

Penulis Jawaban Terbai

all DB deleted on the server

Execute the following commands in the ADDONS directory

pwd */odoo/addons

chown -R postgres:postgres *

chmod 755 *

find. -type f -iname__*.py -exec chmod 664 {} \;

then DB exported on the old server and imported to the new server.

had no error message when I edited employee entries!

Ermin Trevisan

When copying Odoo addons to an instance, this is what I do (you may adapt the addons path):

sudo chown -R root:odoo /usr/lib/python3/dist-packages/odoo/custom/addons/
sudo find /usr/lib/python3/dist-packages/odoo/custom/addons/ -type d -exec chmod 755 {} \;
sudo find /usr/lib/python3/dist-packages/odoo/custom/addons/ -type f -exec chmod 644 {} \;

Directories should be 755, files 644.

Philip Häderli, Philip Häderli

Penulis

thanks for specifying the command.

Menikmati diskusi? Jangan hanya membaca, ikuti!

Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!

Daftar

Post Terkait	Replies	Tampilan
attributes construct error views employee company_id v13	1 Nov 21	7645
Employees without Email Diselesaikan employees	1 Nov 25	3391
Select multiple elements with XPath Diselesaikan views	5 Des 25	51382
E-Mail "Branding" in Odoo 13? How to remove Powered by / Sent by Odoo? v13	2 Jun 24	6330
Error login LinkedIn v13 enterprise v13	2 Mar 24	2748

Pertanyaan ini telah diberikan tanda

Menikmati diskusi? Jangan hanya membaca, ikuti!