Hi.
I'm upgrading ArcGIS Enterprise for one of my clients from ArcGIS Enterprise 10.7.1 to 10.9.1. I've installed ArcGIS Portal and that works fine, but when I try to continue the upgrade process after choosing the license file, the upgrade fails after 30-45 minutes.
When I look at the Portal log file, the message is
Failed to execute SQL file '...ArcGIS\Portal\framework\template\sql\data.sql'
and that there are a duplicate key value which violates the unique constraint "gw_groups_pkey" and the key is listed. I've looked into data.sql and found the object on the same line as the logfile mentions. The object which might have a duplicate ID is the "Navigator Maps"-group. And there are lots of other errors (~30000) following the first error (current transaction is aborted, commands ignored until end of transaction block).
Does anyone know what might be wrong here? I've tried running the upgrade in both Internet Explorer and Firefox, and I've tried restarting the ArcGIS Portal service, with no luck.