Symptom
- HADR replication suspended after a unplanned failover
- "sap_status path" output:
Site2.Site1.SID Additional Info Additional Info Path has been activated by failover. Replication cannot occur until the standby host 'Site1' is made available.
Site2.Site1.SID Failing Command Error Message Failing Command Error Message The DSI connection in the Replication Server on the Site1 host to 'G9P_Site1.G9P' is suspended.
Site2.Site1.G9P Latency Time Unknown No latency information for database 'G9P'.
Site2.Site1.G9P Latency Unknown No latency information for database 'G9P'.
Site2.Site1.G9P Commit Time Unknown No last commit time for the database 'G9P'.
Site2.Site1.G9P Distribution Path Site1 The path of Replication Server through which transactions travel.
Site2.Site1.G9P Drain Status Unknown The drain status of the transaction logs of the primary database server.
Site2.Site1.master State Incomplete Failover is incomplete.
Site2.Site1.master Additional Info Additional Info Path has been activated by failover. Replication cannot occur until the standby host 'Site1' is made available.
Site2.Site1.master Failing Command Error Message Failing Command Error Message The DSI connection in the Replication Server on the Site1 host to 'G9P_Site1.master' is suspended.
Site2.Site1.master Latency Time 2025-03-29 10:26:55.752 Time latency last calculated
Site2.Site1.master Latency 32590543030 Latency (ms)
Site2.Site1.master Commit Time 2024-03-17 05:31:10.458 Time last commit replicated
- Site 2 Replication server log:
** HADR operation: sap_failover Site1, Site2, 600, unplanned'
** Message: is completed'
...
Message from server: Message: 4022, State 1, Severity 10 -- 'The password has expired, but you are still allowed to log in. You must change your password before you can continue. If a login trigger is set, it will not be executed.'.
Message from server: Message: 5701, State 2, Severity 10 -- 'Changed database context to 'master'.'.
ERROR #1028 DSI(108 SID_Site1_R2.SID) - /generic/useful/cm.c(5369) Message from server: Message: 7742, State 3, Severity 16 -- 'You must change your password using the ALTER LOGIN command before you can continue.'.
ERROR #13045 DSI(108 SID_Site1_R2.SID) - /generic/useful/cm.c(5373) Failed to connect to server 'SID_Site1_R2' as user 'SID_maint'. See CT-Lib and/or server error messages for more information.
The DSI thread for database 'SID_Site1_R2.SID' is shutdown.
Read more...
Environment
- SAP Replication Server (SRS) 16.0
- 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
RepServer, RS, HADR, sap_host_available, Msg 4022, replication, suspended, "Replication cannot occur until the standby host", "unplanned" , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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.