Getting error when trying to change password for the MASTERADMIN

Products

• DX Operational Intelligence

Issue/Introduction

We are trying to update the password for DX OI for the user masteradmin via UI. We are getting below error while updating the password.

In the postgres log and we see the following error message:

2021-12-22 15:39:13.524 UTC [1361] ERROR:  duplicate key value violates unique constraint "pk_basic_pwd_hist"
2021-12-22 15:39:13.524 UTC [1361] DETAIL:  Key (userid, orgname, password)=(MASTERADMIN, MASTERADMIN, 1:ntR6wYamw5OD7lE2MAZjrjACgx09qYcCaiesrounqouconq3qcdRfxaltqAXtGnssj748TMPW+g=) already exists.
2021-12-22 15:39:13.524 UTC [1361] STATEMENT:  INSERT INTO
ARADMINBASICAUTHPWDHISTORY ( USERID, ORGNAME, PASSWORD)
VALUES
( $1, $2, $3)

Environment

Release : 21.3

Component : CA DOI Foundations - DEFAULT

Resolution

It looks like we are trying to reset the password which was already used earlier hence this issue is happening.  

The workaround for this issue is to delete the old history.

Please follow the below steps from postgres pod terminal
psql
\c aoplatform
delete from aradminbasicauthpwdhistory where orgname = 'MASTERADMIN';

Logout from the UI, relogin and try to reset the password again.