SAP Knowledge Base Article - Preview

3095639 - HADR materialization fails with error "Processing failed to determine the HADR member servers" - SRS

Symptom

  • DB materialization fails and reports below error in RMA log:
    [INFO ] [Materialize:80367][RMA] - [ASESetupHADR ] - Task Setup HADR - Is performing step - 13
    [INFO ] [Materialize:80367][RMA] - [ASESetupHADR ] - Task Setup HADR - Action - Set the HADR login to 'DR_admin'.
    [INFO ] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Task Name - Set HADR login
    [INFO ] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Description - Sets the login for HADR to use for operations.
    [INFO ] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - State - Initialized
    [INFO ] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Hostname - host1.test.sap.corp
    [INFO ] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - State - Running
    [TRACE] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Pre Execution running.
    [TRACE] [Materialize:80367][RMA] - [ASEUserCheck ] - Executing 'sp_displaylogin '%'' on the ASE at host2.test.sap.corp:4901.
    [TRACE] [Materialize:80367][RMA] - [ASEUserCheck ] - Executing '{call sp_displayroles(DR_admin,expand_down)}' on the ASE at host2.test.sap.corp:4901.
    [TRACE] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Executing 'sp_hadr_admin 'listserver'' on the ASE at host2.test.sap.corp:4901.
    [ERROR] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Failed performing command - sp_hadr_admin 'listserver'
    [ERROR] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Failed with error message - Processing failed to determine the HADR member servers.
    [ERROR] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Failed with Exception - Message: 'Cannot run this command as HADR is not configured. A user with System Administrator (SA) role must reconfigure the system to enable HADR.' Cause: ''.
    [TRACE] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Failed with Stack Trace - Cannot run this command as HADR is not configured. A user with System Administrator (SA) role must reconfigure the system to enable HADR.
    com.sybase.jdbc4.jdbc.SybSQLException: Cannot run this command as HADR is not configured. A user with System Administrator (SA) role must reconfigure the system to enable HADR.
    ...ommitted
    [ERROR] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - Failing Command returned code - 17158
    [ERROR] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Cannot run this command as HADR is not configured. A user with System Administrator (SA) role must reconfigure the system to enable HADR.
    [INFO ] [Materialize:80367][RMA] - [ASESetHADRLogin ] - Task Set HADR login - State - Error
    [TRACE] [Materialize:80367][RMA] - [ConnectionManager ] - Terminate connection <464096315(out of scope)>: jdbc_sybase_Tds_host2.test.sap.corp_4901_master_host2.test.sap.corp_4901_DR_admin_0f45df87ebc44785688bec59728c8f (s/r/a/w/t/o) (2425/0/1/1/2/0)
    [INFO ] [Materialize:80367][RMA] - [ASESetupHADR ] - Task Setup HADR - State - Error
    [ERROR] [Materialize:80367][RMA] - [Materialize ] - Task Materialize - Failed with error message - Setup of HADR on the ASE servers failed.
    [INFO ] [Materialize:80367][RMA] - [Materialize ] - Task Materialize - Provided corrective suggestion - Retry HADR setup by issuing the command: 'sap_materialize finish, force, site1, site2, SID'.
  • sap_status path shows companion status as
    site2 HADR Status Disabled : Unknown
    .....ommitted
    site1.site2.SID State Suspended Path is suspended (DSI). Transactions are not being replicated.
    site1.site2.SID Failing Command Error Message Failing Command Error Message The DSI connection in the Replication Server on the site2 host to 'SID_site2.SID' is suspended.
  • admin who_is_down from companion replication server shows DSI suspended due to DumpMarker:
    1> admin who_is_down
    2> go
    Spid Name State Info
    ---- --------------- -------------------- ------------------------------------------------------------
    ...ommitted
    DSI EXEC Suspended DumpMarker 107(1) SID_site2.SID
    DSI EXEC Suspended DumpMarker 107(2) SID_site2.SID
    DSI EXEC Suspended DumpMarker 107(3) SID_site2.SID
    DSI EXEC Suspended DumpMarker 107(4) SID_site2.SID
    DSI EXEC Suspended DumpMarker 107(5) SID_site2.SID
    DSI Suspended DumpMarker 107 SID_site2.SID


Read more...

Environment

  • 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

listserver, Setup HADR, HADR mode,  HADR state, DumpMarker, rematerialization , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.