Upgrade from 10.9.1 to Enterprise 11.1

SFA · ‎05-26-2023

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.

C_M_F · ‎05-29-2023

I am getting the same error, did you find a way to resolve this?

SFA · ‎05-30-2023

Hi,

Nope. Not yet...

C_M_F · ‎05-30-2023

I restarted the server and re-tried the upgrade and it seems to have upgraded fine now. Not sure if you've tried that but maybe do and see if it works for you.

GISFunctionalGroup · ‎05-30-2023

Hi ,

WE found the same error while upgrading from 10.8.1 to 11.0 . we have restarted the machine & it progressed wihtout any error message. Hope it helps.

Regards

GIS Functional Group

SFA · ‎05-31-2023

Hi,
Lucky you 🙂

SFA · ‎05-31-2023

Hi,
I tried that, didn't work. Will try again, but, this time I will turn off Anti-virus and firewall. Lets see what happens.

DCWade · ‎06-07-2023

I'm running into the same error today upgrading from 10.8.1 to 11.1. Upgrade progressed after a machine restart for me as well

SFA · ‎07-28-2023

Encountered the same issue again, after the second try and following the suggestions stated above.

BobNoyes · ‎07-30-2023

Same problem and what others suggest worked for me, reboot the server.

Initial try:

And after the reboot: