Symptom
- Attempting to force standby ASE server of HADR returns the following error:
1> sp_hadr_admin standby, force
2> go
Msg 17157 , Level 16, State 1: Server 'REPSITEB', Procedure 'sp_hadrvrfyargs', Line 174: 'sp_hadr_admin standby' command is not allowed in current server state (UNKNOWN : INACTIVE).
(return status = 1)
1> select hadr_state = hadr_state(), hadr_mode = hadr_mode()
2> go
hadr_state hadr_mode
------------------------------ ------------------------------
Inactive Starting
(1 row affected) - The Primary ASE is in active state.
Read more...
Environment
SAP Adaptive Server Enterprise 16.0 SP02 PL04 HF1
SAP Replication Server 15.7.1 SP304
Product
SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 15.7
Keywords
sp_hadr_admin standby, HADR, hadr_state(), hadr_mode(), Msg 17157 , 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.