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
