Updating to 11.1 for an ArcGIS Enterprise on Kubernetes organization fails with email notifications configured

Description

An ArcGIS Enterprise 11.0 on Kubernetes organization fails to upgrade to 11.1 when email notifications are configured. When this failure occurs, the following logs are returned in ArcGIS Enterprise Manager:

• Failed to upgrade the postgres from 12.4 to 14.5

• The postgres upgrade result: {"database":{"status":"succeeded"},"configStore":{"status":"succeeded"},"gwdb":{"error":"Updating Geowarehouse schema failed.. Extended error message: com.esri.arcgis.endeavour.datastores.common.DataStoreException: org.postgresql.util.PSQLException: ERROR: could not create unique index \"gw_accounts_email_send_status_pkey\"\n  Detail: Key (account_id)=(0123456789ABCDEF) is duplicated.","status":"failed"},"status":"failed"}

Cause

When email notifications are configured with an 11.0 organization, the account email send status information is created as a duplicate entry and leads to a failure in the 11.0 to 11.1 upgrade process.

Solution or Workaround

To resolve this issue, delete the duplicated entry for account email send status. Follow these steps in 11.0 before initiating an upgrade to 11.1:

1. Sign in to the ArcGIS Portal Directory API as an administrator.
2. Navigate to Portals > Self > <organizationID> > emailsendstatus > Delete, as shown in the following example:

https://<machine.domain.com>/<webadaptor>/sharing/rest/portals/0123456789ABCDEF/emailSendStatus/delete

3. Click Delete, as shown in the next image.

4. Use ArcGIS Enterprise Manager to upgrade the organization from 11.0 to 11.1.