3316086 - sap_status displays HADR status of primary is Unknown - SAP SRS

Symptom

sap_status displays HADR status of primary and active replication path state are Unknown.
1> sap_status path
2> go
PATH NAME VALUE INFO
---------------- ------------------------- ----------------------- ------------------------------------------------------------------------------------
Start Time 2023-03-22 17:10:05.783 Time command started executing.
Elapsed Time 00:00:00 Command execution time.
PRIM Hostname USEPRLDB1<CID> Logical host name.
PRIM HADR Status Unknown Identify the primary and standby sites.
PRIM Synchronization Mode Synchronous The configured Synchronization Mode value.
PRIM Synchronization State Synchronous Synchronization Mode in which replication is currently operating.
PRIM Distribution Mode Remote Configured value for the distribution_mode replication model property.
PRIM Replication Server Status Active The status of Replication Server.
COMP Hostname USEPRLDB2<CID> Logical host name.
COMP HADR Status Standby : Inactive Identify the primary and standby sites.
COMP Synchronization Mode Synchronous The configured Synchronization Mode value.
COMP Synchronization State Inactive Synchronization Mode in which replication is currently operating.
COMP Distribution Mode Remote Configured value for the distribution_mode replication model property.
COMP Replication Server Status Active The status of Replication Server.
COMP.PRIM.<CID> State Unknown Path state cannot be determined.
COMP.PRIM.<CID> Additional Info Additional Info Path is suspended (Replication Agent Thread). Transactions are not being replicated.
COMP.PRIM.<CID> Latency Time Unknown No latency information for database '<CID>'.
COMP.PRIM.<CID> Latency Unknown No latency information for database '<CID>'.
COMP.PRIM.<CID> Commit Time Unknown No last commit time for the database '<CID>'.
COMP.PRIM.<CID> Distribution Path PRIM The path of Replication Server through which transactions travel.
COMP.PRIM.<CID> Drain Status Unknown The drain status of the transaction logs of the primary database server.
COMP.PRIM.master State Unknown Path state cannot be determined.
COMP.PRIM.master Additional Info Additional Info Path is suspended (Replication Agent Thread). Transactions are not being replicated.
COMP.PRIM.master Latency Time Unknown No latency information for database 'master'.
COMP.PRIM.master Latency Unknown No latency information for database 'master'.
COMP.PRIM.master Commit Time Unknown No last commit time for the database 'master'.
COMP.PRIM.master Distribution Path PRIM The path of Replication Server through which transactions travel.
COMP.PRIM.master Drain Status Unknown The drain status of the transaction logs of the primary database server.
PRIM.COMP.<CID> State Unknown Path state cannot be determined.
PRIM.COMP.<CID> Additional Info Additional Info Path is suspended (Replication Agent Thread). Transactions are not being replicated.
PRIM.COMP.<CID> Latency Time Unknown No latency information for database '<CID>'.
PRIM.COMP.<CID> Latency Unknown No latency information for database '<CID>'.
PRIM.COMP.<CID> Commit Time 2023-03-22 17:10:01.400 Time last commit replicated
PRIM.COMP.<CID> Distribution Path COMP The path of Replication Server through which transactions travel.
PRIM.COMP.<CID> Drain Status Not Applicable The drain status of the transaction logs of the primary database server.
PRIM.COMP.master State Unknown Path state cannot be determined.
PRIM.COMP.master Additional Info Additional Info Path is suspended (Replication Agent Thread). Transactions are not being replicated.
PRIM.COMP.master Latency Time Unknown No latency information for database 'master'.
PRIM.COMP.master Latency Unknown No latency information for database 'master'.
PRIM.COMP.master Commit Time 2023-03-22 16:47:56.892 Time last commit replicated
PRIM.COMP.master Distribution Path COMP The path of Replication Server through which transactions travel.
PRIM.COMP.master Drain Status Not Applicable The drain status of the transaction logs of the primary database server.
Primary RMA log shows below errors:
[INFO ] [Thread-1251:1549][RMA] - [RuntimeCommandWrapper ] - TDS LANGUAGE: sap_status path
[WARN ] [pool-2-thread-1:115][RMA] - [ConnectionManager ] - getConnection: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
[ERROR] [Thread-1251:1549][RMA] - [GetPathStatus ] - The DR Agent cannot connect to the database server on the Site1 host due to a login error.
[ERROR] [Thread-1251:1549][RMA] - [GetPathStatus ] - SQL ERROR -- Message: 'Create connection failed. User or Password may be invalid. java.sql.SQLException: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).' SQLState: 'JZ00L' Remote Code: '0' Cause: ''.
[WARN ] [pool-2-thread-3:119][RMA] - [ConnectionManager ] - getConnection: JZ00L: Login failed. Examine the SQLWarnings chained to this exception for the reason(s).
[ERROR] [Thread-1251:1549][RMA] - [HADRStatus ] - Failed to connect to the ASE host 'Primary_Hostname:4901' as user 'DR_admin'.

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite

Keywords

sap_status path, sp_locklogin, unlock, Login failed, SQLWarnings, User or Password may be invalid, invalid , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Problem

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.