Ir al contenido
Se marcó esta pregunta
viewsdbemployeesv13
2 Respuestas
4117 Vistas
Avatar
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

Avatar
Descartar
Avatar
Philip Häderli
Autor Mejor respuesta

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!

Avatar
Descartar
Avatar
Ermin Trevisan
Mejor respuesta

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.

Avatar
Descartar
Philip Häderli
Autor

thanks for specifying the command.

Publicaciones relacionadas Respuestas Vistas Actividad
attributes construct error
views employee company_id v13
Avatar
Avatar
1
nov 21
6603
Employees without Email Resuelto
employees
Avatar
Avatar
1
nov 25
2381
Select multiple elements with XPath Resuelto
views
Avatar
Avatar
Avatar
Avatar
Avatar
5
ago 24
48525
E-Mail "Branding" in Odoo 13? How to remove Powered by / Sent by Odoo?
v13
Avatar
Avatar
Avatar
2
jun 24
6330
Error login LinkedIn v13 enterprise
v13
Avatar
Avatar
2
mar 24
1882