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

客戶關係
e-Commerce
會計
庫存
PoS
專案管理
MRP

All apps

所有帖文人獎章

標籤（查看所有）

odoo accounting v14 pos v15

關於此討論區

支援

Good moring. I appreciate your help with this. I recently reinstalled Odoo (enterprise 13) and get this error when restoring database

web loginpage

3 回覆

5276 瀏覽次數

Gaston Sanchez

Qweb

Mensaje de Error:

load could not load template
InFailedSqlTransaction: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción

Template: web.login_layout
Path: /t/t

Error ocurrido durante el dibujado de la plantilla web.login_layout

Trace

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\cache.py", line 85, in lookup
    r = d[key]
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\func.py", line 69, in wrapper
    return func(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\lru.py", line 44, in __getitem__
    a = self.d[obj].me
KeyError: ('ir.qweb', <function IrQWeb._get_asset_nodes at 0x04CF71E0>, 'web.assets_common', 'es_EC', True, False, '', False, False, False, (1,))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 332, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_web_frontend_layout_1510
  File "<decorator-gen-54>", line 2, in _get_asset_nodes
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\cache.py", line 90, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_qweb.py", line 299, in _get_asset_nodes
    return remains + asset.to_node(css=css, js=js, debug=debug, async_load=async_load, defer_load=defer_load, lazy_load=lazy_load)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\assetsbundle.py", line 151, in to_node
    css_attachments = self.css() or []
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\assetsbundle.py", line 332, in css
    self.save_attachment("css", css)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\assetsbundle.py", line 289, in save_attachment
    attachment = ira.with_user(SUPERUSER_ID).create(values)
  File "<decorator-gen-175>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 314, in _model_create_single
    return create(self, arg)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website\models\ir_attachment.py", line 25, in create
    return super(Attachment, self).create(vals)
  File "<decorator-gen-39>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 335, in _model_create_multi
    return create(self, [arg])
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_attachment.py", line 526, in create
    return super(IrAttachment, self).create(vals_list)
  File "<decorator-gen-3>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 336, in _model_create_multi
    return create(self, arg)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 3773, in create
    records = self._create(data_list)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 3879, in _create
    cr.execute(query, params)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 173, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 250, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UndefinedTable: no existe la relación «ir_attachment_id_seq»
LINE 1: ...ore_fname", "type", "website_id") VALUES (nextval('ir_attach...
                                                             ^


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 745, in get
    value = self._data[field][record._ids[0]]
KeyError: 4

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\fields.py", line 1000, in __get__
    value = env.cache.get(record, self)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 751, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.users(4,).company_id', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 358, in get_template
    document = options.get('load', self.load)(template, options)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_qweb.py", line 116, in load
    lang = options.get('lang', get_lang(self.env).code)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\misc.py", line 1178, in get_lang
    for code in [lang_code, env.context.get('lang'), env.user.company_id.partner_id.lang, langs[0]]:
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\fields.py", line 2329, in __get__
    return super().__get__(records, owner)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\fields.py", line 1007, in __get__
    recs._fetch_field(self)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 2974, in _fetch_field
    self._read(fnames)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\res_users.py", line 378, in _read
    super(Users, self)._read(fields)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 3046, in _read
    cr.execute(query_str, params)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 173, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 250, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.InFailedSqlTransaction: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_http.py", line 234, in _dispatch
    result = request.dispatch()
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 809, in dispatch
    r = self._call_function(**self.params)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 350, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\service\model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 342, in checked_call
    result.flatten()
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 1236, in flatten
    self.response.append(self.render())
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\http.py", line 1229, in render
    return env["ir.ui.view"].render_template(self.template, self.qcontext)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_ui_view.py", line 1177, in render_template
    return self.browse(self.get_view_id(template)).render(values, engine)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website\models\ir_ui_view.py", line 336, in render
    return super(View, self).render(values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\web_editor\models\ir_ui_view.py", line 27, in render
    return super(IrUiView, self).render(values=values, engine=engine, minimal_qcontext=minimal_qcontext)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_ui_view.py", line 1185, in render
    return self.env[engine].render(self.id, qcontext)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\web_studio\models\ir_qweb.py", line 43, in render
    return super(IrQWeb, self).render(template, values=values, **options)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_qweb.py", line 58, in render
    result = super(IrQWeb, self).render(id_or_xml_id, values=values, **context)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 260, in render
    self.compile(template, options)(self, body.append, values or {})
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 334, in _compiled_fn
    raise e
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 332, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_web_login_1452
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 334, in _compiled_fn
    raise e
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 332, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_web_login_layout_1458
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 337, in _compiled_fn
    element, document = self.get_template(template, options)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\web_studio\models\ir_qweb.py", line 21, in get_template
    element, document = super(IrQWeb, self).get_template(template, options)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 364, in get_template
    raise QWebException("load could not load template", e, path, name=template)
odoo.addons.base.models.qweb.QWebException: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\cache.py", line 85, in lookup
    r = d[key]
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\func.py", line 69, in wrapper
    return func(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\lru.py", line 44, in __getitem__
    a = self.d[obj].me
KeyError: ('ir.qweb', <function IrQWeb._get_asset_nodes at 0x04CF71E0>, 'web.assets_common', 'es_EC', True, False, '', False, False, False, (1,))

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 332, in _compiled_fn
    return compiled(self, append, new, options, log)
  File "<template>", line 1, in template_web_frontend_layout_1510
  File "<decorator-gen-54>", line 2, in _get_asset_nodes
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\cache.py", line 90, in lookup
    value = d[key] = self.method(*args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_qweb.py", line 299, in _get_asset_nodes
    return remains + asset.to_node(css=css, js=js, debug=debug, async_load=async_load, defer_load=defer_load, lazy_load=lazy_load)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\assetsbundle.py", line 151, in to_node
    css_attachments = self.css() or []
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\assetsbundle.py", line 332, in css
    self.save_attachment("css", css)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\assetsbundle.py", line 289, in save_attachment
    attachment = ira.with_user(SUPERUSER_ID).create(values)
  File "<decorator-gen-175>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 314, in _model_create_single
    return create(self, arg)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\website\models\ir_attachment.py", line 25, in create
    return super(Attachment, self).create(vals)
  File "<decorator-gen-39>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 335, in _model_create_multi
    return create(self, [arg])
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_attachment.py", line 526, in create
    return super(IrAttachment, self).create(vals_list)
  File "<decorator-gen-3>", line 2, in create
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 336, in _model_create_multi
    return create(self, arg)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 3773, in create
    records = self._create(data_list)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 3879, in _create
    cr.execute(query, params)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 173, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 250, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UndefinedTable: no existe la relación «ir_attachment_id_seq»
LINE 1: ...ore_fname", "type", "website_id") VALUES (nextval('ir_attach...
                                                             ^


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 745, in get
    value = self._data[field][record._ids[0]]
KeyError: 4

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\fields.py", line 1000, in __get__
    value = env.cache.get(record, self)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\api.py", line 751, in get
    raise CacheMiss(record, field)
odoo.exceptions.CacheMiss: ('res.users(4,).company_id', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\qweb.py", line 358, in get_template
    document = options.get('load', self.load)(template, options)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\ir_qweb.py", line 116, in load
    lang = options.get('lang', get_lang(self.env).code)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\tools\misc.py", line 1178, in get_lang
    for code in [lang_code, env.context.get('lang'), env.user.company_id.partner_id.lang, langs[0]]:
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\fields.py", line 2329, in __get__
    return super().__get__(records, owner)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\fields.py", line 1007, in __get__
    recs._fetch_field(self)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 2974, in _fetch_field
    self._read(fnames)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\addons\base\models\res_users.py", line 378, in _read
    super(Users, self)._read(fields)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\models.py", line 3046, in _read
    cr.execute(query_str, params)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 173, in wrapper
    return f(self, *args, **kwargs)
  File "C:\Program Files (x86)\Odoo 13.0e\server\odoo\sql_db.py", line 250, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.InFailedSqlTransaction: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción


load could not load template
InFailedSqlTransaction: transacción abortada, las órdenes serán ignoradas hasta el fin de bloque de transacción

Template: web.login_layout
Path: /t/t

Jainesh Shah(Aktiv Software)

Hello,

try by upgrading python packages, as you are using older version of python packages.

Ermin Trevisan

Please use a meaningful question title and english language.

Savya Sachin

Hi,

Hope you are trying with python version 3.6+

Thanks

喜歡這則討論？不要只閱讀，加入發表意見吧！

今天就建立帳戶，享受獨家功能，與我們精彩的社群互動！

註冊

相關帖文	回覆	瀏覽次數
how to change language of login page web loginpage odooV8	1 9月 15	7184
How to use dynamic snippet for local Seo web	2 7月 25	2204
European Accessibility Act compliance web	1 5月 25	1598
How to import owl CharField? web	2 5月 25	2224
Problems migrating from Odoo14 to Odoo17 due to web.assets_backend problem web	1 7月 24	4583

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！