I think it's too late to post this, but I had the same problem and found a workaround.
Note: this is an unofficial workaround, so be careful when you try.
I was checking the log and found the following error message(thank God 10.3.1 provides logging function),
.......
Caused by: com.esri.gw.GWException: Unable to execute query: com.esri.gw.db.PreparedStatementData@56202141[a=SELECT account_id, min_length, min_upper, min_lower, min_letter, min_digit, min_other, expiration, history, created, modified FROM gw_accounts_password_policy WHERE account_id = ?,b=[com.esri.gw.db.PreparedStatementData$PreparedStatementParameter@57675e93[a=STRING,b=0123456789ABCDEF,c=0]]]
at com.esri.gw.db.DBUtil.doQuery(DBUtil.java:72)
at com.esri.gw.db.GWDatabaseImpl.getSecurityPolicy(GWDatabaseImpl.java:8917)
... 55 more
Caused by: org.postgresql.util.PSQLException: ERROR: リレーション"gw_accounts_password_policy"は存在しません
ポジション: 132
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
.....
So I connected to PostgreSQL which is used inside of Portal, found out that table "gw_accounts_password_policy" does not exist in the database. It does exist when you clean install 10.3.1. So, I just created a table and now it works.
I gusse the upgrade process failed to create the table.
Here's what I did.
- find "config-store-connection.json" under C:\Program Files\ArcGIS\Portal\framework\etc
You can find the database connection information. - Connect to PostgreSQL with the connection information above.
Note: you have pgAdmin under C:\arcgisportal\pgsql_9.3.4\bin - Run the following SQL. At the very end of SQL, please enter your Portal Admin user name.
CREATE TABLE gw_accounts_password_policy
(
account_id character varying(100) NOT NULL,
min_length smallint,
min_upper smallint,
min_lower smallint,
min_letter smallint,
min_digit smallint,
min_other smallint,
expiration smallint,
history smallint,
created timestamp without time zone NOT NULL DEFAULT now(),
modified timestamp without time zone,
CONSTRAINT gw_accounts_password_policy_pkey PRIMARY KEY (account_id),
CONSTRAINT gw_accounts_password_policy_ibfk_1 FOREIGN KEY (account_id)
REFERENCES gw_accounts (id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH (
OIDS=FALSE
);
ALTER TABLE gw_accounts_password_policy
OWNER TO <Portal Admin User Name>;
That's all you have to do.
Hope this help.
