Odoo Support

Welcome!

This community is for professionals and enthusiasts of our products and services.
Share and discuss the best content and new marketing ideas, build your professional profile and become a better marketer together.

0

Error when installing POS App

RPC_ERROR
Odoo Server Error
Traceback (most recent call last):
  File "/odoo/odoo-server/odoo/tools/convert.py", line 695, in _tag_root
    f(rec)
  File "/odoo/odoo-server/odoo/tools/convert.py", line 596, in _tag_record
    record = model._load_records([data], self.mode == 'update')
  File "/odoo/odoo-server/odoo/models.py", line 4346, in _load_records
    records = self._load_records_create([data['values'] for data in to_create])
  File "/odoo/odoo-server/odoo/models.py", line 4268, in _load_records_create
    return self.create(values)
  File "<decorator-gen-304>", line 2, in create
  File "/odoo/odoo-server/odoo/api.py", line 410, in _model_create_multi
    return create(self, arg)
  File "/odoo/odoo-server/addons/point_of_sale/models/pos_config.py", line 365, in create
    pos_configs = super().create(vals_list)
  File "<decorator-gen-65>", line 2, in create
  File "/odoo/odoo-server/odoo/api.py", line 410, in _model_create_multi
    return create(self, arg)
  File "/odoo/odoo-server/odoo/addons/base/models/ir_fields.py", line 665, in create
    recs = super().create(vals_list)
  File "<decorator-gen-13>", line 2, in create
  File "/odoo/odoo-server/odoo/api.py", line 410, in _model_create_multi
    return create(self, arg)
  File "/odoo/odoo-server/odoo/models.py", line 3925, in create
    records = self._create(data_list)
  File "/odoo/odoo-server/odoo/models.py", line 4106, in _create
    cr.execute(
  File "/odoo/odoo-server/odoo/sql_db.py", line 315, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.NotNullViolation: null value in column "pricelist_id" of relation "pos_config" violates not-null constraint
DETAIL:  Failing row contains (1, 71, null, 1, null, 102, 103, null, 1, 92, 91, null, null, null, 1, null, 20000, 100, 1, 1, Shop, total, null, df179951-b6e7-496d-92a6-41649df40f74, direct, null, null, null, null, null, null, null, null, null, f, t, null, f, null, t, null, null, null, f, null, null, null, null, null, null, null, null, null, null, t, null, t, t, t, t, 2022-12-05 13:07:08.545638, 2022-12-05 13:07:08.545638, null).


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

Traceback (most recent call last):
  File "/odoo/odoo-server/odoo/http.py", line 1578, in _serve_db
    return service_model.retrying(self._serve_ir_http, self.env)
  File "/odoo/odoo-server/odoo/service/model.py", line 134, in retrying
    result = func()
  File "/odoo/odoo-server/odoo/http.py", line 1607, in _serve_ir_http
    response = self.dispatcher.dispatch(rule.endpoint, args)
  File "/odoo/odoo-server/odoo/http.py", line 1804, in dispatch
    result = self.request.registry['ir.http']._dispatch(endpoint)
  File "/odoo/odoo-server/odoo/addons/base/models/ir_http.py", line 140, in _dispatch
    result = endpoint(**request.params)
  File "/odoo/odoo-server/odoo/http.py", line 698, in route_wrapper
    result = endpoint(self, *args, **params_ok)
  File "/odoo/odoo-server/addons/web/controllers/dataset.py", line 46, in call_button
    action = self._call_kw(model, method, args, kwargs)
  File "/odoo/odoo-server/addons/web/controllers/dataset.py", line 33, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/odoo/odoo-server/odoo/api.py", line 461, in call_kw
    result = _call_kw_multi(method, model, args, kwargs)
  File "/odoo/odoo-server/odoo/api.py", line 448, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "<decorator-gen-74>", line 2, in button_immediate_install
  File "/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 75, in check_and_log
    return method(self, *args, **kwargs)
  File "/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 487, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/odoo/odoo-server/odoo/addons/base/models/ir_module.py", line 611, in _button_immediate_function
    registry = modules.registry.Registry.new(self._cr.dbname, update_module=True)
  File "<decorator-gen-14>", line 2, in new
  File "/odoo/odoo-server/odoo/tools/func.py", line 87, in locked
    return func(inst, *args, **kwargs)
  File "/odoo/odoo-server/odoo/modules/registry.py", line 91, in new
    odoo.modules.load_modules(registry, force_demo, status, update_module)
  File "/odoo/odoo-server/odoo/modules/loading.py", line 482, in load_modules
    processed_modules += load_marked_modules(cr, graph,
  File "/odoo/odoo-server/odoo/modules/loading.py", line 371, in load_marked_modules
    loaded, processed = load_module_graph(
  File "/odoo/odoo-server/odoo/modules/loading.py", line 230, in load_module_graph
    load_data(cr, idref, mode, kind='data', package=package)
  File "/odoo/odoo-server/odoo/modules/loading.py", line 71, in load_data
    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind)
  File "/odoo/odoo-server/odoo/tools/convert.py", line 760, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate)
  File "/odoo/odoo-server/odoo/tools/convert.py", line 826, in convert_xml_import
    obj.parse(doc.getroot())
  File "/odoo/odoo-server/odoo/tools/convert.py", line 746, in parse
    self._tag_root(de)
  File "/odoo/odoo-server/odoo/tools/convert.py", line 695, in _tag_root
    f(rec)
  File "/odoo/odoo-server/odoo/tools/convert.py", line 708, in _tag_root
    raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /odoo/odoo-server/addons/point_of_sale/data/point_of_sale_data.xml:27, somewhere inside
<record model="pos.config" id="pos_config_main">
            <field name="name">Shop</field>
        </record>
1Comment
Avatar
Discard
Avatar
Ashant Chalasani (PwO)
-

It was missing the pricelist in CHF, EUR.

When you are using multi-company/multi-currency make sure to have pricelist for each currency for each company.