If you are getting trouble while trying to log on a SAP system with the message “Password was not used for a long period and therefore deactivated” on a HANA database system, then you can solve it easily with the following SQL statement.

If you did not logon a SAP system with your initial password  longer that the value which assigned to parameter “login/password_max_idle_initial”, then you cannot logon the system with message “Password was not used for a long period and therefore deactivated” like shown in the below picture ;

In this case, logon the HANA database via HANA studio and execute the following SQL statement ;

update SAPSR3.USR02 set PWDCHGDATE=’<CURRENT_DATE>‘, PWDLGNDATE=’<CURRENT_DATE>‘, TRDAT=’<CURRENT_DATE>‘, UFLAG=’0‘ where BNAME = ‘<USERNAME>‘ and MANDT = ‘<CLIENT>‘

Now you can logon your SAP system with the initial password.