📄 Upgrade Odoo 19 report

Upgrade Odoo 19 report


The Odoo 17 to 19 upgrade feasibility test on the staging-19 branch encountered a database migration failure specific to the Documents application due to two folders being shared with a group containing over 3,800 users.

raise util.MigrationError(f"""

odoo.upgrade.util.exceptions.UpgradeError:

Many-member groups used on Documents Workspaces:


- [3898 users]: "Shared with Clients" (id=15, company=None) with groups:

    * READ: "Portal" (id=9)

- [3898 users]: "N518LA Brokerage" (id=17, company=None) with groups:

    * READ: "Portal" (id=9)


Upgrading as-is would have two downsides:

    1. The access rights panel could get very hard to manage (adding or removing members among a large list)

    2. The Documents application can become slow to use


Several options are available, possibly in combination:


    1. Adapting your configuration:

      * If restricting is not that important, remove the group configuration on the folder

      * If restricting is important:

        * Use another group with fewer members instead / reduce the number of members of the group

        * Set the group as user-specific (read/write) so users keep access to their own documents only


    2. Ask Odoo Support to enable one of the following settings (this can be done after 1 too) using

      the ODOO_UPG_18_DOCUMENTS_FOLDERS_LARGE_GROUPS_RIGHTS key with the following possible values:

      * SET_USER_SPECIFIC: Set these folders groups configuration as USER_SPECIFIC for READ AND WRITE automatically

      * SET_NOBODY: Set these folders as restricted access, only users with the new Documents group

        "System Administrator" will be able to view and edit these folders (including access rights)

        after the upgrade.

      * ACCEPT_AS_IS: Confirm that the current configuration is what you need and upgrade as-is.