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.