Passa al contenuto
Odoo Menu
  • Accedi
  • Provalo gratis
  • App
    Finanze
    • Contabilità
    • Fatturazione
    • Note spese
    • Fogli di calcolo (BI)
    • Documenti
    • Firma
    Vendite
    • CRM
    • Vendite
    • Punto vendita Negozio
    • Punto vendita Ristorante
    • Abbonamenti
    • Noleggi
    Siti web
    • Configuratore sito web
    • E-commerce
    • Blog
    • Forum
    • Live chat
    • E-learning
    Supply chain
    • Magazzino
    • Produzione
    • PLM
    • Acquisti
    • Manutenzione
    • Qualità
    Risorse umane
    • Dipendenti
    • Assunzioni
    • Ferie
    • Valutazioni
    • Referral dipendenti
    • Parco veicoli
    Marketing
    • Social marketing
    • E-mail marketing
    • SMS marketing
    • Eventi
    • Marketing automation
    • Sondaggi
    Servizi
    • Progetti
    • Fogli ore
    • Assistenza sul campo
    • Helpdesk
    • Pianificazione
    • Appuntamenti
    Produttività
    • Comunicazioni
    • Approvazioni
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    App di terze parti Odoo Studio Piattaforma cloud Odoo
  • Settori
    Retail
    • Libreria
    • Negozio di abbigliamento
    • Negozio di arredamento
    • Alimentari
    • Ferramenta
    • Negozio di giocattoli
    Cibo e ospitalità
    • Bar e pub
    • Ristorante
    • Fast food
    • Pensione
    • Grossista di bevande
    • Hotel
    Agenzia immobiliare
    • Agenzia immobiliare
    • Studio di architettura
    • Edilizia
    • Gestione immobiliare
    • Impresa di giardinaggio
    • Associazione di proprietari immobiliari
    Consulenza
    • Società di contabilità
    • Partner Odoo
    • Agenzia di marketing
    • Studio legale
    • Selezione del personale
    • Audit e certificazione
    Produzione
    • Tessile
    • Metallo
    • Arredamenti
    • Alimentare
    • Birrificio
    • Ditta di regalistica aziendale
    Benessere e sport
    • Club sportivo
    • Negozio di ottica
    • Centro fitness
    • Centro benessere
    • Farmacia
    • Parrucchiere
    Commercio
    • Tuttofare
    • Hardware e assistenza IT
    • Ditta di installazione di pannelli solari
    • Calzolaio
    • Servizi di pulizia
    • Servizi di climatizzazione
    Altro
    • Organizzazione non profit
    • Ente per la tutela ambientale
    • Agenzia di cartellonistica pubblicitaria
    • Studio fotografico
    • Punto noleggio di biciclette
    • Rivenditore di software
    Carica tutti i settori
  • Community
    Apprendimento
    • Tutorial
    • Documentazione
    • Certificazioni 
    • Formazione
    • Blog
    • Podcast
    Potenzia la tua formazione
    • Programma educativo
    • Scale Up! Business Game
    • Visita Odoo
    Ottieni il software
    • Scarica
    • Versioni a confronto
    • Note di versione
    Collabora
    • Github
    • Forum
    • Eventi
    • Traduzioni
    • Diventa nostro partner
    • Servizi per partner
    • Registra la tua società di contabilità
    Ottieni servizi
    • Trova un partner
    • Trova un contabile
    • Incontra un esperto
    • Servizi di implementazione
    • Testimonianze dei clienti
    • Supporto
    • Aggiornamenti
    GitHub Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Richiedi una demo
  • Prezzi
  • Aiuto

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

  • CRM
  • e-Commerce
  • Contabilità
  • Magazzino
  • PoS
  • Progetti
  • MRP
All apps
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
È necessario essere registrati per interagire con la community.
Tutti gli articoli Persone Badge
Etichette (Mostra tutto)
odoo accounting v14 pos v15
Sul forum
Assistenza

Missing field string information for the field 'manual_reinvoice_done' from the 'hr.expense' model: since migration from 15.0 to 16.0 (OpenUpgrade)

Iscriviti

Ricevi una notifica quando c'è un'attività per questo post

La domanda è stata contrassegnata
hr_expenseOpenUpgradeodoo15CEodoo16CE
2 Risposte
260 Visualizzazioni
Avatar
Boujraf Youssef

Dear,


After migrating from odoo v15.0 to v16.0 I have this error message :


UncaughtPromiseError
Uncaught Promise > Missing field string information for the field 'manual_reinvoice_done' from the 'hr.expense' model
Error: Missing field string information for the field 'manual_reinvoice_done' from the 'hr.expense' model

    at https://xxx.be/web/assets/7295-7b30a93/web.assets_backend.min.js:6805:258

    at traverse (https://xxx.be/web/assets/7295-7b30a93/web.assets_backend.min.js:6800:200)

    at https://xxx.be/web/assets/7295-7b30a93/web.assets_backend.min.js:6800:242

    at _$1.each (https://xxx.be/web/assets/7294-517589e/web.assets_common.min.js:173:149)
    at traverse (https://xxx.be/web/assets/7295-7b30a93/web.assets_backend.min.js:6800:211)
    at processArch (https://xxx.be/web/assets/7295-7b30a93/web.assets_backend.min.js:6804:180)
    at generateLegacyLoadViewsResult (https://xxx.be/web/assets/7295-7b30a93/web.assets_backend.min.js:6802:106)

    at https://xxx.be/web/assets/7295-7b30a93/web.assets_backend.min.js:5797:447

0
Avatar
Abbandona
Kunjan Patel

The field manual_reinvoice_done is NOT in standard Odoo 15.0 or 16.0.

It comes from the OCA community module https://github.com/OCA/hr expense/tree/15.0/sale_expense_manual_reinvoice, which exists in 15.0 only and was NOT in 16.0.

Your error: OpenUpgrade migrated your database but left orphaned field references because the OCA module doesn't exist for v16.0.

Solution: Either:
1. Remove the field from views using the SQL query (check it executed with UPDATE X response)
2. Or port the OCA module to 16.0 if you need the functionality

Kunjan Patel

Fix Error: Duplicate act_window_view records in account_bank_statement_advanced module.

Solution - Run in PostgreSQL:
DELETE FROM ir_act_window_view WHERE act_window_id = 239 AND view_mode = 'form'
AND id > (SELECT MIN(id) FROM ir_act_window_view WHERE act_window_id = 239 AND view_mode = 'form');

Boujraf Youssef
Autore

Dear

We progress, again another duplicate keys on noviat module when migration.

Nov 23 16:48:13 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.modules.loading:Loading module l10n_be_partner_bank (142/171)
Nov 23 16:48:13 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.modules.migration:module l10n_be_partner_bank: Running migration [>16.0.1] pre-migration
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:OpenUpgrade:l10n_be_partner_bank: pre-migration script called with version 15.0.1.0.0
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.001536 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_BPOTBEB1','l10n_be_partner_bank','res.bank',2)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.001248 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_GEBABEBB','l10n_be_partner_bank','res.bank',3)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.001094 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_GKCCBEBB','l10n_be_partner_bank','res.bank',65)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.001143 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_BBRUBEBB','l10n_be_partner_bank','res.bank',254)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.001129 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_KREDBEBB','l10n_be_partner_bank','res.bank',349)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.001079 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_PCHQBEBB','l10n_be_partner_bank','res.bank',553)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.000743 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_AXABBE22','l10n_be_partner_bank','res.bank',565)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.001114 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_RABOBE22','l10n_be_partner_bank','res.bank',690)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:DEBUG:OpenUpgrade:1 rows affected after 0:00:00.000854 running INSERT INTO ir_model_data (create_uid,create_date,write_uid,write_date,noupdate,name,module,model,res_id) VALUES (1,(now() at time zone 'UTC'),1,(now() at time zone 'UTC'),true,'res_bank_HSBCBEBB','l10n_be_partner_bank','res.bank',761)
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.modules.registry:module l10n_be_partner_bank: creating or updating database tables
Nov 23 16:48:14 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.models:Prepare computation of res.bank.bban_code_list
Nov 23 16:48:15 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.modules.loading:loading l10n_be_partner_bank/data/res_bank_data.xml
Nov 23 16:48:15 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.models.unlink:User #1 deleted ir.model.data records with IDs: [564373]
Nov 23 16:48:15 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.models.unlink:User #1 deleted ir.model.data records with IDs: [564374]
Nov 23 16:48:15 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.models.unlink:User #1 deleted ir.model.data records with IDs: [564375]
Nov 23 16:48:16 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.models.unlink:User #1 deleted ir.model.data records with IDs: [564376]
Nov 23 16:48:16 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:ERROR:odoo.sql_db:bad query: INSERT INTO "res_bank" ("active", "bban_codes", "bic", "country", "create_date", "create_uid", "name", "write_date", "write_uid") VALUES (true, '700-709,750-774,800-816,963,975', 'AXABBE22', 20, '2025-11-23 16:48:13.311303', 1, 'AXA', '2025-11-23 16:48:13.311303', 1) RETURNING "id"
ERROR: duplicate key value violates unique constraint "res_bank_unique_bic"
DETAIL: Key (bic)=(AXABBE22) already exists.
Nov 23 16:48:16 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:WARNING:odoo.modules.loading:Transient module states were reset
Nov 23 16:48:16 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:ERROR:odoo.modules.registry:Failed to load registry
Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 706, in _tag_root
f(rec)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 607, in _tag_record
record = model._load_records([data], self.mode == 'update')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4452, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4363, in _load_records_create
return self.create(values)
^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-300>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo-addons/noviat/l10n_be_partner_bank/models/res_bank.py", line 91, in create
return super().create(vals_list)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-68>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/addons/base/models/ir_fields.py", line 670, in create
recs = super().create(vals_list)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-15>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4019, in create
records = self._create(data_list)
^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4200, in _create
cr.execute(
File "/opt/odoo/16.0/odoo/odoo/sql_db.py", line 324, in execute
res = self._obj.execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "res_bank_unique_bic"
DETAIL: Key (bic)=(AXABBE22) already exists.

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

Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 489, in load_modules
processed_modules += load_marked_modules(cr, graph,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 374, in load_marked_modules
loaded, processed = load_module_graph(
^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 233, in load_module_graph
load_data(cr, idref, mode, kind='data', package=package)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 73, in load_data
tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 771, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 837, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 757, in parse
self._tag_root(de)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 719, in _tag_root
raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /opt/odoo/16.0/odoo-addons/noviat/l10n_be_partner_bank/data/res_bank_data.xml:430, somewhere inside
<record id="res_bank_700" model="res.bank">
<field name="bban_codes">700-709,750-774,800-816,963,975</field>
<field name="bic">AXABBE22</field>
<field name="name">AXA</field>
<field name="country" ref="base.be"/>
</record>
Nov 23 16:48:16 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:CRITICAL:odoo.service.server:Failed to initialize database `www.xxx.be`.
Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 706, in _tag_root
f(rec)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 607, in _tag_record
record = model._load_records([data], self.mode == 'update')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4452, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4363, in _load_records_create
return self.create(values)
^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-300>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo-addons/noviat/l10n_be_partner_bank/models/res_bank.py", line 91, in create
return super().create(vals_list)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-68>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/addons/base/models/ir_fields.py", line 670, in create
recs = super().create(vals_list)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-15>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4019, in create
records = self._create(data_list)
^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4200, in _create
cr.execute(
File "/opt/odoo/16.0/odoo/odoo/sql_db.py", line 324, in execute
res = self._obj.execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "res_bank_unique_bic"
DETAIL: Key (bic)=(AXABBE22) already exists.

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

Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/service/server.py", line 1333, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-16>", line 2, in new
File "/opt/odoo/16.0/odoo/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 489, in load_modules
processed_modules += load_marked_modules(cr, graph,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 374, in load_marked_modules
loaded, processed = load_module_graph(
^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 233, in load_module_graph
load_data(cr, idref, mode, kind='data', package=package)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 73, in load_data
tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 771, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 837, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 757, in parse
self._tag_root(de)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 719, in _tag_root
raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /opt/odoo/16.0/odoo-addons/noviat/l10n_be_partner_bank/data/res_bank_data.xml:430, somewhere inside
<record id="res_bank_700" model="res.bank">
<field name="bban_codes">700-709,750-774,800-816,963,975</field>
<field name="bic">AXABBE22</field>
<field name="name">AXA</field>
<field name="country" ref="base.be"/>
</record>
Nov 23 16:48:16 odoo-16 python3[17140]: Odoo Server 16.0:www.xxx.be:INFO:odoo.service.server:Stopping gracefully

Best Regards,

Kunjan Patel

Dear Try this:

Fix Error: duplicate key value violates unique constraint "res_bank_unique_bic" - Bank AXABBE22 already exists.

Solution - Run in PostgreSQL:
-- Find duplicate banks
SELECT id, name, bic FROM res_bank WHERE bic = 'AXABBE22';

-- Keep the first one, delete duplicates
DELETE FROM res_bank WHERE bic = 'AXABBE22'
AND id NOT IN (SELECT MIN(id) FROM res_bank WHERE bic = 'AXABBE22');

Boujraf Youssef
Autore

Dear

Touch down ;-)
Migration done.
I am checking if everything is ok now.
Do you have any email to reach you in pm ?
Best Regards,

Kunjan Patel

Hi,
Great to hear the migration has been completed.
Regarding contacting me privately, I don't have a personal email address I can share, but you can always reach me here anytime or connect with me on LinkedIn.

Best regards,

Avatar
Kunjan Patel
Risposta migliore
Hello Boujraf Youssef
I hope you are doing well

Quick Fix for OpenUpgrade Migration Error
Problem:
The field manual_reinvoice_done was removed from hr.expense in Odoo v16, but still exists in your database views.

Solution: Run this SQL query in PostgreSQL:
  UPDATE ir_ui_view
  SET arch_db = REGEXP_REPLACE(arch_db, '<field[^>]*name=["\']manual_reinvoice_done["\'][^>]*/>', '', 'g')
  WHERE arch_db LIKE '%manual_reinvoice_done%' AND model = 'hr.expense';

Then restart Odoo: sudo systemctl restart odoo

I hope this information helps you 

Thanks & Regards
Kunjan Patel
0
Avatar
Abbandona
Boujraf Youssef
Autore

Dear,
You have right.
We don't need this module and not used in v15.0.
I uninstalled from v15.0 and try to migrate again the db.
We still have an error :

Nov 23 16:13:02 odoo-16 python3[16794]: Odoo Server 16.0:www.xxx.be:ERROR:odoo.modules.registry:Failed to load registry
Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 706, in _tag_root
f(rec)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 607, in _tag_record
record = model._load_records([data], self.mode == 'update')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4452, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4363, in _load_records_create
return self.create(values)
^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-68>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/addons/base/models/ir_fields.py", line 670, in create
recs = super().create(vals_list)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-15>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4019, in create
records = self._create(data_list)
^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4200, in _create
cr.execute(
File "/opt/odoo/16.0/odoo/odoo/sql_db.py", line 324, in execute
res = self._obj.execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "act_window_view_unique_mode_per_action"
DETAIL: Key (act_window_id, view_mode)=(239, form) already exists.

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

Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 489, in load_modules
processed_modules += load_marked_modules(cr, graph,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 374, in load_marked_modules
loaded, processed = load_module_graph(
^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 233, in load_module_graph
load_data(cr, idref, mode, kind='data', package=package)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 73, in load_data
tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 771, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 837, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 757, in parse
self._tag_root(de)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 719, in _tag_root
raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /opt/odoo/16.0/odoo-addons/noviat/account_bank_statement_advanced/views/account_bank_statement_views.xml:335, somewhere inside
<record model="ir.actions.act_window.view" id="action_bank_statement_tree_form">
<field name="sequence" eval="2"/>
<field name="view_mode">form</field>
<field name="view_id" ref="account_bank_statement_advanced.account_bank_statement_view_form"/>
<field name="act_window_id" ref="account.action_bank_statement_tree"/>
</record>
Nov 23 16:13:02 odoo-16 python3[16794]: Odoo Server 16.0:www.x.be:CRITICAL:odoo.service.server:Failed to initialize database `www.xxx.be`.
Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 706, in _tag_root
f(rec)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 607, in _tag_record
record = model._load_records([data], self.mode == 'update')
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4452, in _load_records
records = self._load_records_create([data['values'] for data in to_create])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4363, in _load_records_create
return self.create(values)
^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-68>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/addons/base/models/ir_fields.py", line 670, in create
recs = super().create(vals_list)
^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-15>", line 2, in create
File "/opt/odoo/16.0/odoo/odoo/api.py", line 431, in _model_create_multi
return create(self, arg)
^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4019, in create
records = self._create(data_list)
^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/models.py", line 4200, in _create
cr.execute(
File "/opt/odoo/16.0/odoo/odoo/sql_db.py", line 324, in execute
res = self._obj.execute(query, params)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
psycopg2.errors.UniqueViolation: duplicate key value violates unique constraint "act_window_view_unique_mode_per_action"
DETAIL: Key (act_window_id, view_mode)=(239, form) already exists.

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

Traceback (most recent call last):
File "/opt/odoo/16.0/odoo/odoo/service/server.py", line 1333, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "<decorator-gen-16>", line 2, in new
File "/opt/odoo/16.0/odoo/odoo/tools/func.py", line 87, in locked
return func(inst, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 489, in load_modules
processed_modules += load_marked_modules(cr, graph,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 374, in load_marked_modules
loaded, processed = load_module_graph(
^^^^^^^^^^^^^^^^^^
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 233, in load_module_graph
load_data(cr, idref, mode, kind='data', package=package)
File "/opt/odoo/16.0/odoo/odoo/modules/loading.py", line 73, in load_data
tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 771, in convert_file
convert_xml_import(cr, module, fp, idref, mode, noupdate)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 837, in convert_xml_import
obj.parse(doc.getroot())
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 757, in parse
self._tag_root(de)
File "/opt/odoo/16.0/odoo/odoo/tools/convert.py", line 719, in _tag_root
raise ParseError('while parsing %s:%s, somewhere inside\n%s' % (
odoo.tools.convert.ParseError: while parsing /opt/odoo/16.0/odoo-addons/noviat/account_bank_statement_advanced/views/account_bank_statement_views.xml:335, somewhere inside
<record model="ir.actions.act_window.view" id="action_bank_statement_tree_form">
<field name="sequence" eval="2"/>
<field name="view_mode">form</field>
<field name="view_id" ref="account_bank_statement_advanced.account_bank_statement_view_form"/>
<field name="act_window_id" ref="account.action_bank_statement_tree"/>
</record>

we forced from DB :

UPDATE ir_module_module set state='uninstalled' where name = 'account_bank_statement_advanced';

select id, module, name, model, res_id from ir_model_data where module='l10n_be_coa_multilang' and model='account.report';

id | module | name | model | res_id
-------+-----------------------+---------------+----------------+--------
25719 | l10n_be_coa_multilang | be_vat_report | account.report | 4
(1 row)

select id, name from account_report_line where report_id=4;

delete from account_report_line where report_id=4;
DELETE 67

and restart and force again openupgrade but here we stick with this error now.

Best Regards,
it was a request from the owner of the repo github/noviat/noviat-apps and delete a table and then redo

Avatar
Boujraf Youssef
Autore Risposta migliore

Dear


Thanks for your help.

I did it but after restart still the same.

When applied the script, I can't see if any result:


(env) root@odoo-16:/opt/odoo/16.0# psql -h localhost -U odoo -d www.xxx.be -p 5432
Password for user odoo:
psql (14.20 (Ubuntu 14.20-1.pgdg24.04+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

www.xxx.be=#   UPDATE ir_ui_view
  SET arch_db = REGEXP_REPLACE(arch_db, '<field[^>]*name=["\']manual_reinvoice_done["\'][^>]*/>', '', 'g')
  WHERE arch_db LIKE '%manual_reinvoice_done%' AND model = 'hr.expense';
www.xxx.be"#


odoo : 

Same error message.

Best Regards,


0
Avatar
Abbandona
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!

Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!

Registrati
Post correlati Risposte Visualizzazioni Attività
openupgrade 16.0 : error - psycopg2.errors.InvalidDatetimeFormat: invalid input syntax for type timestamp: ""
database OpenUpgrade odoo15CE odoo16CE
Avatar
1
giu 25
1946
Migration Community Edition to Enterprse Edition ?
database migration OpenUpgrade odoo16CE odoo16EE
Avatar
Avatar
1
mag 25
1309
Problem with invoices in migrated database with OopenUpgrade
OpenUpgrade
Avatar
Avatar
Avatar
Avatar
3
nov 25
114
Hide Sale Order Create Button
odoo15CE
Avatar
Avatar
Avatar
Avatar
Avatar
5
lug 25
1274
OpenUpgrade from 15.0 to 16.0 : filestore missing files Risolto
filestore OpenUpgrade
Avatar
Avatar
Avatar
2
nov 25
524
Community
  • Tutorial
  • Documentazione
  • Forum
Open source
  • Scarica
  • Github
  • Runbot
  • Traduzioni
Servizi
  • Hosting Odoo.sh
  • Supporto
  • Aggiornamenti
  • Sviluppi personalizzati
  • Formazione
  • Trova un contabile
  • Trova un partner
  • Diventa nostro partner
Chi siamo
  • La nostra azienda
  • Branding
  • Contattaci
  • Lavora con noi
  • Eventi
  • Podcast
  • Blog
  • Clienti
  • Note legali • Privacy
  • Sicurezza
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo è un gestionale di applicazioni aziendali open source pensato per coprire tutte le esigenze della tua azienda: CRM, Vendite, E-commerce, Magazzino, Produzione, Fatturazione elettronica, Project Management e molto altro.

Il punto di forza di Odoo è quello di offrire un ecosistema unico di app facili da usare, intuitive e completamente integrate tra loro.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now