Hi,
While upgrading Portal for ArcGIS 10.9.1 to 11.1, the step where it updates the database, fails. Has anyone had that before?
Below is the text that extracted from the log:
psql:C:/Program Files/ArcGIS/Portal/framework/template/sql/10.9.1_to_11.0.0/alter_table.sql:17: NOTICE: constraint "gw_accounts_email_send_status_ibfk_1" of relation "gw_accounts_email_send_status" does not exist, skipping ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE ALTER TABLE
psql:C:/Program Files/ArcGIS/Portal/framework/template/sql/10.9.1_to_11.0.0/alter_table.sql:61: NOTICE: table "gw_users_security_keys" does not exist, skipping DROP TABLE CREATE TABLE Clean and upgrade database schema failed.
Review the logs for more information.
Failed to update the database schema with C:\Program Files\ArcGIS\Portal\framework\template\sql\10.9.1_to_11.0.0\alter_table.sql file during the upgrade.