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

CRM
e-Commerce
Accounting
Inventory
PoS
Project
MRP

All apps

All Posts People Badges

Tags (View all)

odoo accounting v14 pos v15

About this forum

Help

Move DB to other Server

views db employees v13

2 Replies

4115 Views

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

Author 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

Author

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!

Related Posts	Replies	Views
attributes construct error views employee company_id v13	1 Nov 21	6601
Employees without Email Solved employees	1 Nov 25	2381
Select multiple elements with XPath Solved views	5 Aug 24	48523
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	1882

This question has been flagged

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