How can I solve Odoo Server Error while Importing .zip Studio File

Question

I am trying to import .zip Studio Customization file to Odoo Version 15. As we are migrating our Odoo System we want transfer our Studio Customizations from the development Database to the Production Database.I am getting the following Error:

1.

Traceback (most recent call last):
  File "/home/secusmart/odoo15-prod/odoo/odoo/tools/cache.py", line 85, in lookup
    r = d[key]
  File "/home/secusmart/odoo15-prod/odoo/odoo/tools/func.py", line 71, in wrapper
    return func(self, *args, **kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/tools/lru.py", line 34, in __getitem__
    a = self.d[obj]
KeyError: ('ir.model.access', <function IrModelAccess.check at 0x7f330bb4f4c0>, 2, False, 'base.import.module', 'write', True, ('en_US',))

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/secusmart/odoo15-prod/odoo/odoo/addons/base/models/ir_http.py", line 237, in _dispatch
    result = request.dispatch()
  File "/home/secusmart/odoo15-prod/odoo/odoo/http.py", line 688, in dispatch
    result = self._call_function(**self.params)
  File "/home/secusmart/odoo15-prod/odoo/odoo/http.py", line 360, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/http.py", line 349, in checked_call
    result = self.endpoint(*a, **kw)
  File "/home/secusmart/odoo15-prod/odoo/odoo/http.py", line 917, in __call__
    return self.method(*args, **kw)
  File "/home/secusmart/odoo15-prod/odoo/odoo/http.py", line 536, in response_wrap
    response = f(*args, **kw)
  File "/home/secusmart/odoo15-prod/odoo/addons/web/controllers/main.py", line 1352, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "/home/secusmart/odoo15-prod/odoo/addons/web/controllers/main.py", line 1340, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/api.py", line 464, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/api.py", line 451, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "/home/secusmart/odoo15-prod/odoo/addons/base_import_module/models/base_import_module.py", line 24, in import_module
    self.write({'state': 'done', 'import_message': res[0]})
  File "/home/secusmart/odoo15-prod/odoo/odoo/models.py", line 3763, in write
    self.check_access_rights('write')
  File "/home/secusmart/odoo15-prod/odoo/odoo/models.py", line 3538, in check_access_rights
    return self.env['ir.model.access'].check(self._name, operation, raise_exception)
  File "<decorator-gen-33>", line 2, in check
  File "/home/secusmart/odoo15-prod/odoo/odoo/tools/cache.py", line 90, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/addons/base/models/ir_model.py", line 1762, in check
    self._cr.execute("""SELECT MAX(CASE WHEN perm_{mode} THEN 1 ELSE 0 END)
  File "<decorator-gen-3>", line 2, in execute
  File "/home/secusmart/odoo15-prod/odoo/odoo/sql_db.py", line 89, in check
    return f(self, *args, **kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/sql_db.py", line 310, in execute
    res = self._obj.execute(query, params)
Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "/home/secusmart/odoo15-prod/odoo/odoo/http.py", line 644, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/home/secusmart/odoo15-prod/odoo/odoo/http.py", line 302, in _handle_exception
    raise exception.with_traceback(None) from new_cause
psycopg2.errors.InFailedSqlTransaction: current transaction is aborted, commands ignored until end of transaction block

I fixed the first error by performing the import as superuser

Now I got the following Error:

2.

Traceback (most recent call last):
  File "/home/secusmart/odoo15-prod/odoo/odoo/tools/cache.py", line 85, in lookup
    r = d[key]
  File "/home/secusmart/odoo15-prod/odoo/odoo/tools/func.py", line 71, in wrapper
    return func(self, *args, **kwargs)
  File "/home/secusmart/odoo15-prod/odoo/odoo/tools/lru.py", line 34, in __getitem__
    a = self.d[obj]
KeyError: ('res.lang', <function Lang.get_installed at 0x7f330ab8b4c0>)

Does your user have all access rights? If I interpret the traceback right, it seems that you don't have the rights to write to some models. If you are not on odoo Saas I would also recommend working with custom modules instead of Studio app, It's much easier for this kind of things and for migrations, debugging and for more advanced customization. — switch87, Nov 15 '22 at 18:02
Hay, I importet as Admin. I tried importing as superuser now and the error doesn't show up ans more, I updatet my question, because now I got another Server Error. — kayalotta, Nov 16 '22 at 08:28
pure guess on this one, but check if both databases have the same languages installed. — switch87, Nov 16 '22 at 23:10

score 0 · Answer 1 · answered Nov 16 '22 at 14:57

You can refer to this answer: Is it possible to import Odoo15 Studio .zip file to Odoo16?

As a small recap, basically you should use the migration tools offered by odoo. You have an enterprise subscription and are using a version of Odoo that is still supported. So migrating your database by Odoo employees should already be possible - and free.

How can I solve Odoo Server Error while Importing .zip Studio File

1 Answers1