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 'hostname' 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 'hostname' 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
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.
SAP Knowledge Base Article - Preview