Hello,

I got the following error while upgrading the database. How can I fix it? Thank you.

Unfortunately, the upgrade process didn't end successfully and requires a manual intervention. Specific upgrade scripts or corrections in the current database might be required so the database can be upgraded. This mostly happens after an important change in the original database. If you need help to solve the issue, please open a ticket at www.odoo.com/help.

The upgrade failed after 39 seconds of processing.

The upgrade failed on the below error:

Traceback (most recent call last):
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/convert.py", line 556, in _tag_root
    f(rec)
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/convert.py", line 456, in _tag_record
    record = model._load_records([data], self.mode == 'update')
  File "/home/odoo/src/odoo/saas-17.1/odoo/models.py", line 5176, in _load_records
    records = self._load_records_create([data['values'] for data in to_create])
  File "/home/odoo/src/odoo/saas-17.1/odoo/models.py", line 5087, in _load_records_create
    return self.create(values)
  File "", line 2, in create
  File "/home/odoo/src/odoo/saas-17.1/odoo/api.py", line 421, in _model_create_multi
    return create(self, arg)
  File "/tmp/tmpw4m_nvcq/migrations/util/orm.py", line 212, in wrapper
    return f(*args, **kwargs)
  File "/tmp/tmpw4m_nvcq/migrations/base/0.0.0/pre-models-match_uniq.py", line 25, in create
    return super().create(vals_list)
  File "", line 2, in create
  File "/home/odoo/src/odoo/saas-17.1/odoo/api.py", line 421, in _model_create_multi
    return create(self, arg)
  File "/home/odoo/src/odoo/saas-17.1/odoo/models.py", line 4716, in create
    records = self._create(data_list)
  File "/home/odoo/src/odoo/saas-17.1/odoo/models.py", line 4904, in _create
    cr.execute(SQL(
  File "/home/odoo/src/odoo/saas-17.1/odoo/sql_db.py", line 346, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "res_users_settings_unique_user_id"
DETAIL:  Key (user_id)=(2) already exists.


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

Traceback (most recent call last):
  File "/home/odoo/src/odoo/saas-17.1/odoo/service/server.py", line 1286, in preload_registries
    registry = Registry.new(dbname, update_module=update_module)
  File "", line 2, in new
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/func.py", line 87, in locked
    return func(inst, *args, **kwargs)
  File "/home/odoo/src/odoo/saas-17.1/odoo/modules/registry.py", line 119, in new
    odoo.modules.load_modules(registry, force_demo, status, update_module)
  File "/home/odoo/src/odoo/saas-17.1/odoo/modules/loading.py", line 422, in load_modules
    loaded_modules, processed_modules = load_module_graph(
  File "/home/odoo/src/odoo/saas-17.1/odoo/modules/loading.py", line 227, in load_module_graph
    load_data(env, idref, mode, kind='data', package=package)
  File "/home/odoo/src/odoo/saas-17.1/odoo/modules/loading.py", line 71, in load_data
    tools.convert_file(env, package.name, filename, idref, mode, noupdate, kind)
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/convert.py", line 627, in convert_file
    convert_xml_import(env, module, fp, idref, mode, noupdate)
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/convert.py", line 693, in convert_xml_import
    obj.parse(doc.getroot())
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/convert.py", line 613, in parse
    self._tag_root(de)
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/convert.py", line 556, in _tag_root
    f(rec)
  File "/home/odoo/src/odoo/saas-17.1/odoo/tools/convert.py", line 569, in _tag_root
    raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /home/odoo/src/odoo/saas-17.1/odoo/addons/base/data/res_users_data.xml:26, somewhere inside

            
        

If you want to have a deeper look, you can examine the logs.

Please accept our apologies for any inconvenience caused.