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

CRM
e-Commerce
Contabilidad
Inventario
PoS
Proyecto
MRP

All apps

Todas las publicaciones Personas Insignias

Etiquetas (Ver todo)

odoo accounting v14 pos v15

Acerca de este foro

Ayuda

Move DB to other Server

views db employees v13

2 Respuestas

4116 Vistas

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 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!

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.

¿Le interesa esta conversación? ¡Participe en ella!

Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.

Inscribirse

Publicaciones relacionadas	Respuestas	Vistas
attributes construct error views employee company_id v13	1 nov 21	6603
Employees without Email Resuelto employees	1 nov 25	2381
Select multiple elements with XPath Resuelto views	5 ago 24	48525
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

Se marcó esta pregunta

¿Le interesa esta conversación? ¡Participe en ella!