SAP Knowledge Base Article - Preview

3023347 - setuphadr failing with DR_admin login getting locked - SRS

Symptom

Materialization failing with following in RMA log:

[TRACE] [Thread-79:358][RMA] - [ConnectionManager        ] - Replacing message "010HA: The server denied your request to use the high-availability feature" with "Create connection failed. User or password may be invalid."
[WARN ] [Thread-79:358][RMA] - [AuthenticationHandler    ] - The request to authenticate a session with a 'DBSERVER' connection to a 'ASE' host named 'vhrsdpopdb01.redsalud.cl' on port '4901' as user 'DR_admin' failed with server side message: 'DR_admin'.
[INFO ] [Thread-79:358][RMA] - [AuthenticationHandler    ] - Attempting to authenticate a session with a 'DATAAPPLIER' connection to a 'RepServer' as user 'DR_admin' on host 'vhrsdpopdb01.redsalud.cl' and port '4905'
[TRACE] [Thread-79:358][RMA] - [ConnectionManager        ] - Registering a connection pool for URL <proxool.jdbc_sybase_Tds_xxxxxx.xxxxxx_4905_master_xxxxxxx.xxxxxx.cl_4905_DR_admin_abd283326cb1064b4492a70206bd4a9:com.sybase.jdbc4.jdbc.SybDriver:jdbc:sybase:Tds:xxxxxx.xxxxxx.cl:4905/master>
[INFO ] [Thread-79:358][RMA] - [ConnectionManager        ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:xxxxxx.xxxxxx.cl:4905/master'.
[TRACE] [Thread-79:358][RMA] - [ConnectionManager        ] - Creating connection to pool: jdbc_sybase_Tds_xxxxxx.xxxxxx.cl_4905_master_xxxxxx.redsalud.cl_4905_DR_admin_abd283326cb1064b4492a70206bd4a9 (s/r/a/w/t/o) (0/0/0/0/0/0)
[WARN ] [pool-2-thread-2:60][RMA] - [ConnectionManager        ] - JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
[TRACE] [Thread-79:358][RMA] - [ConnectionManager        ] - Failed to get connection. Exception: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).
java.util.concurrent.ExecutionException: java.sql.SQLException: JZ00L: Login failed.  Examine the SQLWarnings chained to this exception for the reason(s).

DR_admin gets locked:

sp_displaylogin DR_admin
go

Suid: 12
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: Jan  8 20XX  7:50AM
        Reason: Account locked by ASE due to failed login attempts reaching max failed logins
        Locking suid: DR_admin
        Date of Last Password Change: Jan  8 20XX  6:43AM 


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 with Always-on Option (HADR)
  • SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite

Product

SAP NetWeaver 7.5 ; SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Sybase Replication Server 15.7, heterogeneous edition ; SAP Sybase Replication Server 15.7, option for IBM DB2 ; SAP Sybase Replication Server 15.7, option for Microsoft SQL Server ; SAP Sybase Replication Server 15.7, option for Oracle ; SAP Sybase Replication Server 15.7, real-time loading edition

Keywords

HADR, setuphadr, sap_materialize, teardown, sap_teardown , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-RSO , Rep Server Options (RSO) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , How To

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.