Skip to Content
Menu
This question has been flagged
1 Reply
2026 Views
Odoo Server Error
Traceback (most recent call last):
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 758, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 663, in _tag_record
    record = model.with_context(rec_context)._load_records([data], self.mode == 'update')
  File "/opt/odoo12/odoo/odoo/models.py", line 3888, in _load_records
    records = self._load_records_create([data['values'] for data in to_create])
  File "/opt/odoo12/odoo/odoo/models.py", line 3802, in _load_records_create
    return self.create(values)
  File "<decorator-gen-277>", line 2, in create
  File "/opt/odoo12/odoo/odoo/api.py", line 443, in _model_create_single
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "/opt/odoo12/odoo/odoo/api.py", line 443, in <genexpr>
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "/opt/odoo12/odoo/addons/point_of_sale/models/pos_config.py", line 359, in create
    pos_config = super(PosConfig, self).create(values)
  File "<decorator-gen-3>", line 2, in create
  File "/opt/odoo12/odoo/odoo/api.py", line 461, in _model_create_multi
    return create(self, [arg])
  File "/opt/odoo12/odoo/odoo/models.py", line 3583, in create
    records = self._create(data_list)
  File "/opt/odoo12/odoo/odoo/models.py", line 3683, in _create
    cr.execute(query, params)
  File "/opt/odoo12/odoo/odoo/sql_db.py", line 148, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/odoo12/odoo/odoo/sql_db.py", line 225, in execute
    res = self._obj.execute(query, params)
psycopg2.IntegrityError: null value in column "pricelist_id" violates not-null constraint
DETAIL:  Failing row contains (1, Shop, 14, 15, 1, 1, f, f, f, f, f, f, f, f, f, t, f, subtotal, null, f, f, f, null, null, null, t, 52c0547d-6c7f-4995-987c-a2a8734d6484, 65, 66, t, null, 1, 1, 77, 76, f, null, null, <div class="pos-customer_facing_display pos-palette_01">
       ..., f, f, f, f, f, f, f, f, f, f, f, f, f, 1, 2020-04-21 06:18:02.935395, 1, 2020-04-21 06:18:02.935395).


During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/opt/odoo12/odoo/odoo/http.py", line 656, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/opt/odoo12/odoo/odoo/http.py", line 314, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/opt/odoo12/odoo/odoo/tools/pycompat.py", line 87, in reraise
    raise value
  File "/opt/odoo12/odoo/odoo/http.py", line 698, in dispatch
    result = self._call_function(**self.params)
  File "/opt/odoo12/odoo/odoo/http.py", line 346, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/opt/odoo12/odoo/odoo/service/model.py", line 98, in wrapper
    return f(dbname, *args, **kwargs)
  File "/opt/odoo12/odoo/odoo/http.py", line 339, in checked_call
    result = self.endpoint(*a, **kw)
  File "/opt/odoo12/odoo/odoo/http.py", line 941, in __call__
    return self.method(*args, **kw)
  File "/opt/odoo12/odoo/odoo/http.py", line 519, in response_wrap
    response = f(*args, **kw)
  File "/opt/odoo12/odoo/addons/web/controllers/main.py", line 966, in call_button
    action = self._call_kw(model, method, args, {})
  File "/opt/odoo12/odoo/addons/web/controllers/main.py", line 954, in _call_kw
    return call_kw(request.env[model], method, args, kwargs)
  File "/opt/odoo12/odoo/odoo/api.py", line 759, in call_kw
    return _call_kw_multi(method, model, args, kwargs)
  File "/opt/odoo12/odoo/odoo/api.py", line 746, in _call_kw_multi
    result = method(recs, *args, **kwargs)
  File "<decorator-gen-61>", line 2, in button_immediate_install
  File "/opt/odoo12/odoo/odoo/addons/base/models/ir_module.py", line 74, in check_and_log
    return method(self, *args, **kwargs)
  File "/opt/odoo12/odoo/odoo/addons/base/models/ir_module.py", line 445, in button_immediate_install
    return self._button_immediate_function(type(self).button_install)
  File "/opt/odoo12/odoo/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/odoo12/odoo/odoo/modules/registry.py", line 86, in new
    odoo.modules.load_modules(registry._db, force_demo, status, update_module)
  File "/opt/odoo12/odoo/odoo/modules/loading.py", line 421, in load_modules
    loaded_modules, update_module, models_to_check)
  File "/opt/odoo12/odoo/odoo/modules/loading.py", line 313, in load_marked_modules
    perform_checks=perform_checks, models_to_check=models_to_check
  File "/opt/odoo12/odoo/odoo/modules/loading.py", line 222, in load_module_graph
    load_data(cr, idref, mode, kind='data', package=package, report=report)
  File "/opt/odoo12/odoo/odoo/modules/loading.py", line 68, in load_data
    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 802, in convert_file
    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 865, in convert_xml_import
    obj.parse(doc.getroot(), mode=mode)
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 755, in parse
    self.parse(rec, mode)
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 764, in parse
    exc_info[2]
  File "/opt/odoo12/odoo/odoo/tools/pycompat.py", line 86, in reraise
    raise value.with_traceback(tb)
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 758, in parse
    self._tags[rec.tag](rec, de, mode=mode)
  File "/opt/odoo12/odoo/odoo/tools/convert.py", line 663, in _tag_record
    record = model.with_context(rec_context)._load_records([data], self.mode == 'update')
  File "/opt/odoo12/odoo/odoo/models.py", line 3888, in _load_records
    records = self._load_records_create([data['values'] for data in to_create])
  File "/opt/odoo12/odoo/odoo/models.py", line 3802, in _load_records_create
    return self.create(values)
  File "<decorator-gen-277>", line 2, in create
  File "/opt/odoo12/odoo/odoo/api.py", line 443, in _model_create_single
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "/opt/odoo12/odoo/odoo/api.py", line 443, in <genexpr>
    return self.browse().concat(*(create(self, vals) for vals in arg))
  File "/opt/odoo12/odoo/addons/point_of_sale/models/pos_config.py", line 359, in create
    pos_config = super(PosConfig, self).create(values)
  File "<decorator-gen-3>", line 2, in create
  File "/opt/odoo12/odoo/odoo/api.py", line 461, in _model_create_multi
    return create(self, [arg])
  File "/opt/odoo12/odoo/odoo/models.py", line 3583, in create
    records = self._create(data_list)
  File "/opt/odoo12/odoo/odoo/models.py", line 3683, in _create
    cr.execute(query, params)
  File "/opt/odoo12/odoo/odoo/sql_db.py", line 148, in wrapper
    return f(self, *args, **kwargs)
  File "/opt/odoo12/odoo/odoo/sql_db.py", line 225, in execute
    res = self._obj.execute(query, params)
odoo.tools.convert.ParseError: "null value in column "pricelist_id" violates not-null constraint
DETAIL:  Failing row contains (1, Shop, 14, 15, 1, 1, f, f, f, f, f, f, f, f, f, t, f, subtotal, null, f, f, f, null, null, null, t, 52c0547d-6c7f-4995-987c-a2a8734d6484, 65, 66, t, null, 1, 1, 77, 76, f, null, null, <div class="pos-customer_facing_display pos-palette_01">
       ..., f, f, f, f, f, f, f, f, f, f, f, f, f, 1, 2020-04-21 06:18:02.935395, 1, 2020-04-21 06:18:02.935395).
" while parsing /opt/odoo12/odoo/addons/point_of_sale/data/point_of_sale_data.xml:41, near
<record model="pos.config" id="pos_config_main">
            <field name="name">Shop</field>
            <field name="picking_type_id" ref="picking_type_posout"/>
            <field name="barcode_nomenclature_id" ref="barcodes.default_barcode_nomenclature"/>
        </record>
Avatar
Discard
Best Answer

Hi,

The issue might be with the data in the database, if it is a test instance try in a new database and see whether you have got same error there or not.

Also if you are using any custom modules make sure that they are not making any trouble.


Thanks

Avatar
Discard