On-Premise Odoo 16.0 Documentation: Installation, Management, and Troubleshooting

Database Management in Odoo 16.0 On-Premise

Registering an Odoo Database

To successfully register your Odoo database, simply input your unique subscription code into the designated banner located within the application dashboard. Upon successful registration, this banner will visually confirm by turning green and prominently displaying your database's expiration date.

Tip: The database expiration date is also conveniently accessible and displayed at the bottom of the Settings page.

Duplicating an Odoo Database

Duplicating an Odoo database is typically performed by accessing the database manager directly on your server, usually via the address <odoo-server>/web/database/manager. It is a common practice to duplicate your production database to create a neutralized testing environment. This process is initiated by checking the 'neutralize' box when prompted, which then executes all neutralize.sql scripts for every installed module, ensuring sensitive data is appropriately anonymized for testing purposes.

Resolving Common On-Premise Odoo 16.0 Errors

Managing an on-premise Odoo installation can occasionally present challenges. Below, we detail common error messages you might encounter, along with practical solutions to ensure the smooth operation of your Odoo 16.0 environment.

Subscription Registration Errors

Should an issue arise during the registration process, an error message similar to the one depicted below will typically be displayed.

To effectively resolve this issue and ensure smooth operation, consider the following comprehensive steps:

• Verify Odoo Enterprise Subscription Validity: Confirm the validity of your Odoo Enterprise subscription by checking if your subscription details are marked with the "In Progress" tag on your Odoo Account. If not, or if you require assistance, contact your Account Manager.
• Ensure Unique Database Linkage: Verify that no other database is currently linked to your subscription code. It is critical to note that only one database can be actively linked per subscription.

  Tip: If a test or development database is required, you can easily duplicate an existing database rather than attempting to link a new one to the same subscription.

• Check for UUID Duplicates: Confirm that no databases share the same UUID (Universally Unique Identifier) by opening your Odoo Contract. If two or more databases are found to share the same UUID, their respective names will be clearly displayed.

  Should this occur, you have the option to manually adjust the database(s) UUID or, alternatively, submit a support ticket to Odoo for expert assistance.

  
• Review Network and Firewall Settings: For continuous validation and update notifications, it is imperative that your Odoo server can establish outgoing connections to Odoo’s subscription validation servers. Therefore, you must ensure that your network and firewall settings are configured to allow traffic towards:
  • Odoo 18.0 and above: services.odoo.com on port 80
  • Odoo 17.0 and below: services.openerp.com on port 80

  It is crucial that these specified ports remain open even after the initial database registration, as the system performs weekly update notifications and validation checks.

Too Many Users Error Resolution

If the number of active users within your local Odoo database exceeds the allocation specified in your Odoo Enterprise subscription, a prominent message similar to the one below will be displayed.

Upon the appearance of this message, a critical 30-day period commences during which you must take corrective action before your database reaches its expiration date. The remaining time in this countdown is updated daily for your convenience.

To effectively resolve this user count discrepancy and restore full functionality, you have two primary courses of action:

• Add More Users: Click the "Upgrade your subscription" link displayed within the message. This will allow you to validate the upsell quotation and facilitate payment for the additional users required.
• Deactivate Users: Alternatively, you can deactivate users to bring your total count within your subscription limits and then reject the upsell quotation.

Once your Odoo database successfully aligns with the licensed user count, the expiration message will automatically be removed. This typically occurs within a few days, following the system's next scheduled verification cycle.

Database Expired Error

Should your Odoo database subscription lapse prior to renewal, a critical message indicating database expiration, as shown below, will be displayed.

This warning message is triggered specifically if you fail to address the underlying issue within the preceding 30-day countdown period, leading to the database's expiration.

To regain access and restore the full operational status of your Odoo database, you can pursue one of the following resolution paths:

• Renew Your Subscription: Click on the "Renew your subscription" link prominently displayed within the message and diligently complete the renewal process. Please note that payments made via wire transfer may take several days to process and activate your renewal, whereas credit card payments are typically processed and applied immediately.
• Contact Support: If you encounter any difficulties or require assistance, you can send a support ticket to the Odoo team.