Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Comptabilitat
Inventari
PoS
Projectes
MRP

All apps

All Posts People Badges

Etiquetes (View all)

odoo accounting v14 pos v15

About this forum

Ajuda

Move DB to other Server

views db employees v13

2 Respostes

4121 Vistes

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

Autor Best Answer

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

Autor

thanks for specifying the command.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Registrar-se

Related Posts	Respostes	Vistes
attributes construct error views employee company_id v13	1 de nov. 21	6609
Employees without Email Solved employees	1 de nov. 25	2381
Select multiple elements with XPath Solved views	5 d’ag. 24	48538
E-Mail "Branding" in Odoo 13? How to remove Powered by / Sent by Odoo? v13	2 de juny 24	6330
Error login LinkedIn v13 enterprise v13	2 de març 24	1884

This question has been flagged

Enjoying the discussion? Don't just read, join in!