On-premises Database management

Register a database

To register your database, you just need to enter your Subscription Code in the banner in the App Switcher. Make sure you do not add extra spaces before or after your subscription code. If the registration is successful, it will turn green and will provide you with the Expiration Date of your freshly-registered database. You can check this Epiration Date in the About menu (Flectra 9) or in the Settings Dashboard (Flectra 10).

Registration Error Message

If you are unable to register your database, you will likely encounter this message:

Something went wrong while registering your database, you can try again or contact Flectra Help

Solutions

  • Do you have a valid Professional subscription?

    • Check if your subscription details get the tag “In Progress” on your Flectra Account or with your Account Manager

  • Have you already linked a database with your subscription reference?

    • You can link only one database per subscription. (Need a test or a development database? Find a partner)

    • You can unlink the old database yourself on your Flectra Contract with the button “Unlink database”

      ../../_images/unlink_single_db.png

      A confirmation message will appear; make sure this is the correct database as it will be deactivated shortly:

      ../../_images/unlink_confirm_enterprise_edition.png
  • Do you have the updated version of Flectra 9?

    • From July 2016 onward, Flectra 9 now automatically change the uuid of a duplicated database; a manual operation is no longer required.

    • If it’s not the case, you may have multiple databases sharing the same UUID. Please check on your Flectra Contract, a short message will appear specifying which database is problematic:

      ../../_images/unlink_db_name_collision.png

      In this case, you need to change the UUID on your test databases to solve this issue. You will find more information about this in this section.

      For your information, we identify database with UUID. Therefore, each database should have a distinct UUID to ensure that registration and invoicing proceed effortlessly for your and for us.

  • Check your network and firewall settings

    • The Update notification must be able to reach Flectra’s subscription validation servers. In other words, make sure that the Flectra server is able to open outgoing connections towards:

      • services.flectrahq.com on port 443 (or 80)

      • services.openerp.com on port 443 (or 80) for older deployments

    • Once you activated your database, you must keep these ports open, as the Update notification runs once a week.

Error message due to too many users

If you have more users in your local database than provisionned in your Flectra Professional subscription, you may encounter this message:

This database will expire in X days, you have more users than your subscription allows

When the message appears you have 30 days before the expiration. The countdown is updated everyday.

Solutions

  • Add more users on your subscription: follow the link and Validate the upsell quotation and pay for the extra users.

  • Deactivate users as explained in this documentation and Reject the upsell quotation.

Once your database has the correct number of users, the expiration message will disappear automatically after a few days, when the next verification occurs. We understand that it can be a bit frightening to see the countdown, so you can force an Update Notification to make the message disappear right away.

Database expired error message

If your database reaches its expiration date before your renew your subscription, you will encounter this message:

This database has expired.

This blocking message appears after a non-blocking message that lasts 30 days. If you fail to take action before the end of the countdown, the database is expired.

Solutions

  • Renew your subscription: follow the link and renew your subscription - note that

    if you wish to pay by Wire Transfer, your subscription will effectively be renewed only when the payment arrives, which can take a few days. Credit card payments are processed immediately.

  • Contact our Support

None of those solutions worked for you? Please contact our Support

Duplicate a database

You can duplicate your database by accessing the database manager on your server (<flectra-server>/web/database/manager). In this page, you can easily duplicate your database (among other things).

../../_images/db_manager.gif

When you duplicate a local database, it is strongly advised to change the duplicated database’s uuid (Unniversally Unique Identifier), since this uuid is how your database identifies itself with our servers. Having two databases with the same uuid could result in invoicing problems or registration problems down the line.

Note

From July 2016 onward, Flectra 9 now automatically change the uuid of a duplicated database; a manual operation is no longer required.

The database uuid is currently accessible from the menu Settings ‣ Technical ‣ System Parameters, we advise you to use a uuid generator or to use the unix command uuidgen to generate a new uuid. You can then simply replace it like any other record by clicking on it and using the edit button.

../../_images/db_uuid.png