SAP Knowledge Base Article - Preview

3559632 - DR_admin Account locked by ASE due to failed login attempts reaching max failed logins - SAP RS

Symptom

  • HADR path is unknown.

     Site1.Site2.<sid>    State                     Unknown                 Path state cannot be determined.
  • DR_admin is getting locked.

    sp_displaylogin DR_admin
    go
    Suid: 28
    Loginame: DR_admin
    Fullname:
    Default Database: master
    Default Language:
    Auto Login Script:
    Configured Authorization:
            sa_role (default ON)
            sso_role (default ON)
            sybase_ts_role (default ON)
            replication_role (default ON)
            hadr_admin_role_gp (default ON)
    Locked: YES
            Date when locked: Dec 29 2024  6:39AM
            Reason: Account locked by ASE due to failed login attempts reaching max failed logins
            Locking suid: DR_admin
    Date of Last Password Change: Jun 15 2024  7:18AM
    Password expiration interval: 0
    Password expired: NO
    Minimum password length: 15
    Maximum failed logins: 7
    Current failed login attempts: 7
    Authenticate with: AUTH_DEFAULT
    Login Password Encryption: SHA-256
    Last login date: Dec 29 2024  6:35AM
    Exempt inactive lock: 0
    (return status = 0) 

  • Followed the step in KBA 2134321 to set DR_admin unexpired, but issue persists
  • /usr/sap/hostctrl/exe/saphostctrl -function LiveDatabaseUpdate -dbname <sid> -dbtype syb -updateoption TASK=VALIDATE_SEC_STORES

    GLOBAL_DR_ADMIN=invalid
    LOCAL_DR_ADMIN=not found 


Read more...

Environment

  • SAP Replication Server (SRS) 16.0
  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)

Product

SAP NetWeaver Application Server for ABAP 7.52 ; SAP Replication Server 16.0 ; SAP Replication Server 16.0.4

Keywords

KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.