Recently upgraded a client from Sage CRM 2019 to 2020 R1. After the upgrade installation, 'Admin' user is lockout frequently. If I set the user_AccountLockedOut = NULL in user table I'm able to login and after some time, it will automatically locks out. Currently only the 'Admin' user is facing this issue. No idea what went wrong.
The issue stems from the “dynamic hash” being enabled.
When dynamic hash is switched on it does not retroactively check all the passwords and hash them afterwards. It will only hash new passwords. So what happened here was that the admin password in the CRM db was not dynamically hashed, and needed to be entered again to activate the hash, I noticed this when I looked at the hash being ^ and not ^^. The EM uses the old hashing system but this was fixed by updating the user password in users to the new hash and then just giving the EM the password. Comparing the EM hash (after conversion) with the new hash was successful and it logged it fine.