SAP Knowledge Base Article - Preview

3592620 - HADR replication suspended after unplanned failover - SAP SRS

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

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

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.