Symptom
sap_enable_replicataion fails with below errors in RMA log:
2021-11-16 09:56:21 [INFO ] [Thread-20:53][RMA] - [AuthenticationHandler ] - Attempting to authenticate a session with a 'DATAAPPLIER' connection to a 'RepServer' as user 'DR_admin' on host 'PRIM_host' and port '4905'
2021-11-16 09:56:21 [TRACE] [Thread-20:53][RMA] - [ConnectionManager ] - Registering a connection pool for URL <proxool.jdbc_sybase_Tds_PRIM_host_4905_master_PRIM_host_4905_DR_admin_ea56e6ab5c8e99ec6e3ea84115b1ab65:com.sybase.jdbc4.jdbc.SybDriver:jdbc:sybase:Tds:PRIM_host:4905/master>
2021-11-16 09:56:21 [INFO ] [Thread-20:53][RMA] - [ConnectionManager ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:PRIM_host:4905/master'.
2021-11-16 09:56:21 [TRACE] [Thread-20:53][RMA] - [ConnectionManager ] - Creating connection to pool: jdbc_sybase_Tds_PRIM_host_4905_master_PRIM_host_4905_DR_admin_ea56e6ab5c8e99ec6e3ea84115b1ab65 (s/r/a/w/t/o) (0/0/0/0/0/0)
2021-11-16 09:56:22 [TRACE] [Thread-20:53][RMA] - [ConnectionManager ] - Allocated connection: 369005058(com.sybase.jdbc4.jdbc.SybConnection@19fb1972) pool: jdbc_sybase_Tds_PRIM_host_4905_master_PRIM_host_4905_DR_admin_ea56e6ab5c8e99ec6e3ea84115b1ab65 (s/r/a/w/t/o) (1/0/1/0/1/0)
2021-11-16 09:56:22 [INFO ] [Thread-20:53][RMA] - [AuthenticationHandler ] - The request to authenticate a session with a 'DATAAPPLIER' connection to a 'RepServer' host named 'PRIM_host' on port '4905' as user 'DR_admin' succeeded.
2021-11-16 09:56:22 [TRACE] [Thread-20:53][RMA] - [ConnectionManager ] - Terminate connection <369005058(com.sybase.jdbc4.jdbc.SybConnection@19fb1972)>: jdbc_sybase_Tds_PRIM_host_4905_master_PRIM_host_4905_DR_admin_ea56e6ab5c8e99ec6e3ea84115b1ab65 (s/r/a/w/t/o) (1/0/0/0/0/0)
2021-11-16 09:59:45 [INFO ] [Thread-20:53][RMA] - [RuntimeCommandWrapper ] - TDS LANGUAGE: sap_enable_replication PRIM COMP SID
2021-11-16 09:59:45 [INFO ] [Thread-20:53][RMA] - [TaskExecutorImpl ] - A task executor has been created.
/...omit.../
2021-11-16 10:00:01 [INFO ] [Thread-27:70][RMA] - [AuthenticationHandler ] - Attempting to authenticate a session with a 'DATAAPPLIER' connection to a 'RepServer' as user 'sapsa' on host 'PRIM_host' and port '4905'
2021-11-16 10:00:01 [TRACE] [Thread-27:70][RMA] - [ConnectionManager ] - Registering a connection pool for URL <proxool.jdbc_sybase_Tds_PRIM_host_4905_master_PRIM_host_4905_sapsa_8fad8d81b8d30bc62bdc52555993436:com.sybase.jdbc4.jdbc.SybDriver:jdbc:sybase:Tds:PRIM_host:4905/master>
2021-11-16 10:00:01 [INFO ] [Thread-27:70][RMA] - [ConnectionManager ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:PRIM_host:4905/master'.
2021-11-16 10:00:01 [TRACE] [Thread-27:70][RMA] - [ConnectionManager ] - Creating connection to pool: jdbc_sybase_Tds_PRIM_host_4905_master_PRIM_host_4905_sapsa_8fad8d81b8d30bc62bdc52555993436 (s/r/a/w/t/o) (0/0/0/0/0/0)
2021-11-16 10:00:01 [WARN ] [pool-2-thread-2:58][RMA] - [ConnectionManager ] - JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
2021-11-16 10:00:01 [TRACE] [Thread-27:70][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).
/...omit.../
2021-11-16 10:00:50 [TRACE] [Thread-20:53][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."
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ConnectionManager ] - ConnectionManager: Creating connection with url= 'jdbc:sybase:Tds:ripeccdr.ripl.com:4905/master'.
2021-11-16 10:00:50 [TRACE] [Thread-20:53][RMA] - [ConnectionManager ] - Creating connection to pool: jdbc_sybase_Tds_ripeccdr.ripl.com_4905_master_ripeccdr.ripl.com_4905_sapsa_7c7d1e23ddf246dfc7f5d0c62ed348e8 (s/r/a/w/t/o) (0/8/0/0/0/0)
2021-11-16 10:00:50 [WARN ] [pool-2-thread-1:56][RMA] - [ConnectionManager ] - JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
2021-11-16 10:00:50 [TRACE] [Thread-20:53][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).
/...omit.../
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Task Name - Resume DIST Thread
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Description - Resume the Replication Server distribution thread for a database.
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - State - Initialized
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Hostname - PRIM_host
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - State - Running
2021-11-16 10:00:50 [TRACE] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Pre Execution running.
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Action - Checking if the Replication Server distribution thread to 'SID_PRIM_R2.SID' is already active.
2021-11-16 10:00:50 [INFO ] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - State - Error
2021-11-16 10:00:50 [ERROR] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Failed with error message - An internal Assertion Exception was caught during run task: com.sybase.ua.plugins.dr.exceptions.DRAssertException: The JDBC connection parameter was not set.
2021-11-16 10:00:50 [ERROR] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Failed with Exception - Message: 'The JDBC connection parameter was not set.' Cause: ''.
2021-11-16 10:00:50 [TRACE] [Thread-20:53][RMA] - [ResumeDIST ] - Task Resume DIST Thread - Failed with Stack Trace - The JDBC connection parameter was not set.
com.sybase.ua.plugins.dr.exceptions.DRAssertException: The JDBC connection parameter was not set.
secure storage is verified, and it is set up correctly for users DR_admin, sapsa, etc.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 GA with High Availability Disaster Recovery (HADR) for Business Suite
Keywords
JDBC connection, sapsa, DR_admin, Login failed, sap_disable_replication, connection parameter not set , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Known Error
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.