Erro ao criar banco de dados

146 views
Skip to first unread message

Adroaldo Cavalheiro

unread,
Apr 26, 2021, 1:02:52 PM4/26/21
to OdooBrasil
Boa tarde amigos, estou tentando subir um servidor com Ubuntu 18.04.5 LTS, Odoo 12 e localização brasileira Trust-Code, tudo instala normalmente mas quando vou criar a base de dados aparece a mensagem abaixo no navegador.
Após varios testes resolvi criar a base sem a localização da Trust-code, consegui criar normalmente, mas após incluir no conf o caminho da localização brasileira aparece o erro conforme segunda imagem.

Abraços a todos, desde já agradeço a quem possa ajudar

odoo_error.png


odoo_error2.png
Erro:
Odoo Server Error

Traceback (most recent call last):
  File "/opt/odoo/odoo-server/odoo/addons/base/models/res_country.py", line 104, in _check_address_format
    record.address_format % {i: 1 for i in address_fields}
KeyError: 'city_name'

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/odoo/odoo-server/odoo/models.py", line 1128, in _validate_fields
    check(self)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/res_country.py", line 106, in _check_address_format
    raise UserError(_('The layout contains an invalid format key'))
odoo.exceptions.UserError: ('O layout contém um formato de chave inválida', '')

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 758, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 663, in _tag_record
    record = model.with_context(rec_context)._load_records([data], self.mode == 'update')
  File "/opt/odoo/odoo-server/odoo/models.py", line 3881, in _load_records
    data['record']._load_records_write(data['values'])
  File "/opt/odoo/odoo-server/odoo/models.py", line 3819, in _load_records_write
    self.write(values)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/res_country.py", line 91, in write
    return super(Country, self).write(vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 3364, in write
    self._write(store_vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 3500, in _write
    self._validate_fields(vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 1132, in _validate_fields
    raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))
odoo.exceptions.ValidationError: ('Error while validating constraint\n\nO layout contém um formato de chave inválida\n', None)

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/odoo/odoo-server/odoo/tools/safe_eval.py", line 352, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "", line 1, in <module>
  File "<decorator-gen-61>", line 2, in button_immediate_install
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 74, in check_and_log
    return method(self, *args, **kwargs)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 445, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 561, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "/opt/odoo/odoo-server/odoo/modules/registry.py", line 86, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 421, in load_modules
    loaded_modules, update_module, models_to_check)
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 313, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 222, in load_module_graph
    load_data(cr, idref, mode, kind='data', package=package, report=report)
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 68, in load_data
    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 802, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 865, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 764, in parse
    exc_info[2]
  File "/opt/odoo/odoo-server/odoo/tools/pycompat.py", line 86, in reraise
    raise value.with_traceback(tb)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 758, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 663, in _tag_record
    record = model.with_context(rec_context)._load_records([data], self.mode == 'update')
  File "/opt/odoo/odoo-server/odoo/models.py", line 3881, in _load_records
    data['record']._load_records_write(data['values'])
  File "/opt/odoo/odoo-server/odoo/models.py", line 3819, in _load_records_write
    self.write(values)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/res_country.py", line 91, in write
    return super(Country, self).write(vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 3364, in write
    self._write(store_vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 3500, in _write
    self._validate_fields(vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 1132, in _validate_fields
    raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))
odoo.tools.convert.ParseError: "Error while validating constraint

O layout contém um formato de chave inválida

None" while parsing /opt/odoo/odoo-brasil/br_base/views/br_base_view.xml:4, near
<record id="base.br" model="res.country">
        <field name="address_format" eval="'%(street)s, %(number)s - %(street2)s\n%(district)s\n%(zip)s - %(city_name)s - %(state_code)s\n%(country_name)s'"/>
    </record>

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/odoo/odoo-server/odoo/http.py", line 656, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo/odoo-server/odoo/http.py", line 314, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/opt/odoo/odoo-server/odoo/tools/pycompat.py", line 87, in reraise
    raise value
  File "/opt/odoo/odoo-server/odoo/http.py", line 698, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo/odoo-server/odoo/http.py", line 346, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/odoo/odoo-server/odoo/service/model.py", line 98, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/odoo/odoo-server/odoo/http.py", line 339, in checked_call
    result = self.endpoint(*a, **kw)
  File "/opt/odoo/odoo-server/odoo/http.py", line 941, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo/odoo-server/odoo/http.py", line 519, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo/odoo-server/addons/web/controllers/main.py", line 1276, in run
    result = request.env['ir.actions.server'].browse([action_id]).run()
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_actions.py", line 546, in run
    res = func(action, eval_context=eval_context)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_actions.py", line 437, in run_action_code_multi
    safe_eval(action.sudo().code.strip(), eval_context, mode="exec", nocopy=True)  # nocopy allows to return 'action'
  File "/opt/odoo/odoo-server/odoo/tools/safe_eval.py", line 375, in safe_eval
    pycompat.reraise(ValueError, ValueError('%s: "%s" while evaluating\n%r' % (ustr(type(e)), ustr(e), expr)), exc_info[2])
  File "/opt/odoo/odoo-server/odoo/tools/pycompat.py", line 86, in reraise
    raise value.with_traceback(tb)
  File "/opt/odoo/odoo-server/odoo/tools/safe_eval.py", line 352, in safe_eval
    return unsafe_eval(c, globals_dict, locals_dict)
  File "", line 1, in <module>
  File "<decorator-gen-61>", line 2, in button_immediate_install
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 74, in check_and_log
    return method(self, *args, **kwargs)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 445, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 561, in _button_immediate_function
    modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "/opt/odoo/odoo-server/odoo/modules/registry.py", line 86, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 421, in load_modules
    loaded_modules, update_module, models_to_check)
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 313, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 222, in load_module_graph
    load_data(cr, idref, mode, kind='data', package=package, report=report)
  File "/opt/odoo/odoo-server/odoo/modules/loading.py", line 68, in load_data
    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 802, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 865, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 764, in parse
    exc_info[2]
  File "/opt/odoo/odoo-server/odoo/tools/pycompat.py", line 86, in reraise
    raise value.with_traceback(tb)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 758, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/opt/odoo/odoo-server/odoo/tools/convert.py", line 663, in _tag_record
    record = model.with_context(rec_context)._load_records([data], self.mode == 'update')
  File "/opt/odoo/odoo-server/odoo/models.py", line 3881, in _load_records
    data['record']._load_records_write(data['values'])
  File "/opt/odoo/odoo-server/odoo/models.py", line 3819, in _load_records_write
    self.write(values)
  File "/opt/odoo/odoo-server/odoo/addons/base/models/res_country.py", line 91, in write
    return super(Country, self).write(vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 3364, in write
    self._write(store_vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 3500, in _write
    self._validate_fields(vals)
  File "/opt/odoo/odoo-server/odoo/models.py", line 1132, in _validate_fields
    raise ValidationError("%s\n\n%s" % (_("Error while validating constraint"), tools.ustr(e)))
ValueError: <class 'odoo.tools.convert.ParseError'>: "Error while validating constraint

O layout contém um formato de chave inválida

None
<record id="base.br" model="res.country">
        <field name="address_format" eval="'%(street)s, %(number)s - %(street2)s\n%(district)s\n%(zip)s - %(city_name)s - %(state_code)s\n%(country_name)s'"/>
    </record>
/opt/odoo/odoo-brasil/br_base/views/br_base_view.xml
4" while evaluating
'records.button_immediate_install()'

Marcelo Lima

unread,
Apr 27, 2021, 1:06:41 PM4/27/21
to OdooBrasil
Tente acessar esse arquivo XML e comentar ele, e depois tenta instalar novamente

Pode ser que você nao tenha instalado algum componente necessário antes disso, tente comentar e veja se resolve.

Se instalar, vc descomenta o trecho e reeinstalar somente esse pacote br_base.
<--
<record id="base.br" model="res.country">
<field name="address_format" eval="'%(street)s, %(number)s - %(street2)s\n%(district)s\n%(zip)s - %(city_name)s - %(state_code)s\n%(country_name)s'" />
</record>
-->

Marcelo Lima
Fábrica de Programadores.

Adroaldo Cavalheiro

unread,
Apr 27, 2021, 6:47:21 PM4/27/21
to OdooBrasil
Olá Marcelo, gratidão pelo retorno, fiz conforme instruiu, e o erro persiste, para testar acabei de utilizar a localização da OCA (https://github.com/OCA/l10n-brazil) e com essa localização não apresenta erro ao criar a base de dados, mas não estou familiarizado coma  localização da OCA, vou procurar mais e ver onde pode estar o erro, talvez alguma atualização que a Trsutcode lançou recente e acabou dando esse bug :-)

Obrigado mais uma vez 

Reply all
Reply to author
Forward
0 new messages