2395461 - Msg 17157, Level 16, State 1 command is not allowed in current server state (UNKNOWN : INACTIVE) - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2395461 - Msg 17157, Level 16, State 1 command is not allowed in current server state (UNKNOWN : INACTIVE) - SRS

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.