Wiki Mint System

Odoo Upgrade from 13.0 to 14.0

Run Upgrade

TIP

The main challenge of the upgrade process is having the filestore at the right location.

Test

Steps to upgrade a databse.

  • Set env vars
export PGHOST=localhost
export PGUSER=odoo
export PGPASSWORD=odoo
export DATABASE=erp
alias odoo-upgrade="python <(curl -s https://upgrade.odoo.com/upgrade)"
  • Start local development environment
task start db,native
  • Clear the local filestore and database
task drop-db erp
task clear-filestore erp
  • Export remote database to local folder and restore it
odoo-backup -d $DATABASE ...
odoo-restore -f ...
  • Run the upgrade script, options are test and production
odoo-upgrade production -d $DATABASE -t 14.0

It should automatically restore the database.

  • Switch local development environment to targeted version
task checkout 14.0
task start db,native

export DATABASE=erp_backup_2021_11_10_18_16
task remove-module $DATABASE web_diagram
task remove-module $DATABASE auth_oauth_multi_token
  • Check custom modules
task odoo-cloc $DATABASE
  • Export database
odoo-backup -d $DATABASE -o tmp/.../erp-14.0.zip
  • Upload database to test environment
odoo-restore -d erp-dev -f tmp/.../erp-14.0.zip -r -h https://erp-dev...

Production

Execute the same steps as for Tests except for these changes:

odoo-upgrade production -d $DATABASE -t 14.0

  • Upload database to production environment

In addition you must:

Test after upgrade

Check the following Odoo features:

  • Accounting QR-Code
  • Dashboards
  • Accounting Reconciliation
  • Project Invoicing

If necessary update all modules: docker-odoo-update -c odooN -d $DATABASE

Make at least sure to upgrade localization apps such as l10n_ch.

Troubleshooting

Assets not loaded

After the upgrade the filestore assets are not available.

FileNotFoundError: [Errno 2] No such file or directory: '/var/lib/odoo/filestore/erp/93/93132f7c7b7174981e27eeea893a1b5f860df9de'

Resolution

Check filestore root@server:/mnt/server-disk2/docker/volumes/odooN/_data/filestore

Modules missing

Remove specific modules that are not supported.

task remove-module erp_test_14.0_2021_04_27_09_02 auth_oauth_multi_token
task remove-module erp_test_14.0_2021_04_27_09_02 web_company_color

Connection lost

If the connection is lost during the upgrade process, the database won't be restored.

Resolution

export TOKEN=PcLKAKFELD15Eel56EbhbSwEHa9DCKTjLsoTCDZeBxgrzVb1DfW8of_Jcw
odoo-upgrade status -t $TOKEN
odoo-upgrade restore -d erp -r erp-14.0 -t $TOKEN
odoo-upgrade log -t $TOKEN

Studio customizations missing

After the restore the console show this error:

Some dependencies may be missing: ['studio_customization']

Resolution

Manually export the customizations.

Prognostizierter Bestand ist nicht aktualisiert

Der Bericht Prognostizierter Bestand ist nicht aktuell.

Resolution

Install stock_enterprise.

Filters are missing

After an upgrade Odoo-Filters are missing.

Resolution

Check Dev Tool > Manage Filters and remove the My filters filter. See if the filter still exists. If yes, create a new filter and copy the Domain value.

Project overview error

The profability overivew of a project cannot be opened as the following error occurs:

KeyError: 'expense_amount_untaxed_to_invoice'

Error to render compiling AST
KeyError: 'expense_amount_untaxed_to_invoice'
Template: unknown
Path: /qweb/div/div/div/div/div[1]/div[3]/div[2]/div/table/tbody/tr[7]
Node: <tr t-if="display_cost &amp; (dashboard['profit']['expense_amount_untaxed_to_invoice'] != 0)">
                                                    <td class="o_timesheet_plan_dashboard_cell">
                                                        <t t-esc="dashboard['profit']['expense_amount_untaxed_to_invoice']" t-options="{&quot;widget&quot;: &quot;monetary&quot;, &quot;display_currency&quot;: currency}"/>
                                                    </td>
                                                    <td title="Costs from expenses that still need to be reinvoiced to your customer (provided that the Analytic Account of the Project was set on the Expense).">
                                                        To re-invoice costs
                                                    </td>
                                                </tr>

Resolution

Update the sale_timesheet module.