SAP Knowledge Base Article - Preview

3120114 - sap_enable_replication or other RMA activities fails due to incorrect users logging in RMA - SAP SRS

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 ONE Support launchpad (Login required).

Search for additional results

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