topic Re: Password Change & Reset Password in 10.3.1- Not Working in ArcGIS Enterprise Portal Questions

Password Change & Reset Password in 10.3.1- Not Working

Drew — Thu, 11 Jun 2015 14:45:55 GMT

Hello,

- We just upgraded our ArcGIS for Portal from 10.3 to 10.3.1

I am trying to use the Change Password function from within the Edit Profile page of Portal and I do not get any dialog to actually change my password. I simply get a dialog saying "Password Changed - Your password has successfully been changed" - i never actually get to enter a new password anywhere.

I have also logged in as an administrator and tried to use the Reset Password function but it throws an error also..

"Unable to reset password for member..." (see attached)

After some digging through the logs and watching the HTTP request I am seeing a common error of : !DB_0000! (see attached)
com.esri.gw.GWException: !DB_0000! at com.esri.gw.db.GWDatabaseImpl.getSecurityPolicy(GWDatabaseImpl.java:8941)

Is this just me or is the change and reset password broken in 10.3.1.. Any ideas on how to fix this?

Thanks,

Drew

Re: Password Change & Reset Password in 10.3.1- Not Working

Albertvan_der_Kamp — Mon, 29 Jun 2015 12:34:52 GMT

Hi Andrew,

Did you find a solution for this problem? ESRI Netherlands could not solve this problem for me and gave me this alternative:

Create a new user (because change password does work for those users).
Use 'Change owner' to make this new user the owner of the old user's data.
Remove the old user.

Thanks,

Albert.

Re: Password Change & Reset Password in 10.3.1- Not Working

Drew — Mon, 29 Jun 2015 14:09:23 GMT

Albert,

ESRI Canada was unable to provide a fix also. I have asked it to see if ESRI Redlands can assist with the issue, but have not had a response yet.

It's good to know others are have experienced similar issues.

I am assuming you did a 10.3 to 10.3.1 upgrade also?

Andrew

Re: Password Change & Reset Password in 10.3.1- Not Working

Albertvan_der_Kamp — Mon, 29 Jun 2015 14:13:46 GMT

Just like you did: a 10.3 to 10.3.1 upgrade of (our ArcGIS software including) Portal.

Re: Password Change & Reset Password in 10.3.1- Not Working

DanielUrbach — Mon, 29 Jun 2015 14:19:02 GMT

Hello Andrew,

Did you try to reindex the Portal configuration store after upgrading?

If not try these steps:

1) Open the ArcGIS Portal Directory and sign in with the initial administrator account. The URL is formattedhttps://portal.domain.com:7443/arcgis/portaladmin.
2) Click System > Indexer > Reindex.
3) Click the Mode drop-down list, and select Full.
4) Click Reindex. This step will complete the upgrade of your portal. Depending on the number of users and volume of content in your portal, it will take some time for the reindex to complete. Do not interrupt the reindex process. You can monitor the indexing status by opening a new browser window (or tab), navigating to System > Indexer > Index Status, and refreshing the page. When the store and index counts are equal, the reindex and upgrade is complete.

Re: Password Change & Reset Password in 10.3.1- Not Working

Albertvan_der_Kamp — Mon, 29 Jun 2015 14:24:23 GMT

Hello Daniel,

I tried that already but it didn't make it work on my system.

Albert.

Re: Password Change & Reset Password in 10.3.1- Not Working

Drew — Mon, 29 Jun 2015 15:35:49 GMT

Hi Daniel,

Thanks for the suggestion - unfortunately it did not solve the issue.

I believe i did that same procedure after the upgrade also.

Andrew

Re: Password Change & Reset Password in 10.3.1- Not Working

JasonPatterson — Tue, 30 Jun 2015 13:43:05 GMT

What type of security is being used? Enterprise logins, Windows (IWA), internal Portal users, etc...?

Re: Password Change & Reset Password in 10.3.1- Not Working

Albertvan_der_Kamp — Tue, 30 Jun 2015 13:56:24 GMT

I use internal portal users.

Re: Password Change & Reset Password in 10.3.1- Not Working

JasonPatterson — Tue, 30 Jun 2015 14:07:44 GMT

When attempting to change passwords are connections being made through the web adapter or :7443?

Re: Password Change & Reset Password in 10.3.1- Not Working

Drew — Tue, 30 Jun 2015 14:13:52 GMT

I am also using Portal User accounts

Re: Password Change & Reset Password in 10.3.1- Not Working

Drew — Tue, 30 Jun 2015 14:14:38 GMT

They are going through the web adapter on my end.

Re: Password Change & Reset Password in 10.3.1- Not Working

Albertvan_der_Kamp — Tue, 30 Jun 2015 14:16:24 GMT

I use //mydomain/arcgisportal to access my portal. So it must be through the web adapter.

Re: Password Change & Reset Password in 10.3.1- Not Working

Anonymous User — Thu, 02 Jul 2015 17:31:01 GMT

A BUG has been submitted for this and is currently being looked at by Dev. Thank you for bringing this to our attention.

Re: Password Change & Reset Password in 10.3.1- Not Working

VassiloWalluschnig1 — Mon, 03 Aug 2015 08:58:32 GMT

Hi Donald,

Thanks for submitting the bug. Has there been any news on when it will be fixed? Could we also please get the bug number so that we can track it.

Regards,

Vassilo.

Re: Password Change & Reset Password in 10.3.1- Not Working

Anonymous User — Tue, 04 Aug 2015 19:55:46 GMT

If you contact Customer Support and ask the analyst to look up the following key phrase they can give you the bug number and add you to the bug. You will then be able to follow the progress of the bug. "Passwords for built-in portal accounts in Portal for ArcGIS cannot be changed by the user."

Re: Password Change & Reset Password in 10.3.1- Not Working

MasaakiABE — Thu, 08 Oct 2015 04:47:04 GMT

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.

Re: Password Change & Reset Password in 10.3.1- Not Working

BerneJackson — Mon, 09 Nov 2015 20:13:03 GMT

Thank you for the solution; it worked like a charm!

Re: Password Change & Reset Password in 10.3.1- Not Working

CallumSmith — Thu, 26 Nov 2015 17:52:21 GMT

Thanks It worked for me as well!

Re: Password Change & Reset Password in 10.3.1- Not Working

HemantKadve — Sat, 12 Dec 2015 05:40:04 GMT

Issue is fixed in 10.4

BUG-000088826 - Passwords for built-in portal accounts in Portal f.