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  ERROR: duplicate key value violates unique constraint "pk_basic_pwd_hist"
2021-12-22 15:39:13.524 UTC  DETAIL: Key (userid, orgname, password)=(MASTERADMIN, MASTERADMIN, 1:ntR6wYamw5OD7lE2MAZjrjACgx09qYcCaiesrounqouconq3qcdRfxaltqAXtGnssj748TMPW+g=) already exists.
2021-12-22 15:39:13.524 UTC  STATEMENT: INSERT INTO
ARADMINBASICAUTHPWDHISTORY ( USERID, ORGNAME, PASSWORD)
( $1, $2, $3)
Release : 21.3
Component : CA DOI Foundations - DEFAULT
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
delete from aradminbasicauthpwdhistory where orgname = 'MASTERADMIN';
Logout from the UI, relogin and try to reset the password again.