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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

Move DB to other Server

views db employees v13

2 Antwoorden

4125 Weergaven

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

Auteur Beste antwoord

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

Auteur

thanks for specifying the command.

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
attributes construct error views employee company_id v13	1 nov. 21	6613
Employees without Email Opgelost employees	1 nov. 25	2383
Select multiple elements with XPath Opgelost views	5 aug. 24	48559
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 mrt. 24	1886

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!