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.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite
Keywords
sap_status path , 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.