Symptom
- The issue arises when attempting to add back the 3rd DR node in existing HADR after a DR drill test activity.
- While adding the DR node back using sap_update_replication add, site3 command, below error shows up:
[TRACE] [Update Replication:286][RMA] - [com.sybase.ua.plugins.dr.] - Executing 'sp_hadr_admin config_bs, NULL, 'DR_node_hostname'' on the ASE at HA_node_hostname:4905.
[TRACE] [Update Replication:286][RMA] - [com.sybase.ua.plugins.dr.] - SQL ERROR -- Message: 'Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.' SQLState: 'ZZZZZ' Remote Code: '7205' Cause: ''.SQL ERROR -- Message: 'Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.' SQLState: 'ZZZZZ' Remote Code: '7205' Cause: ''.SQL ERROR -- Message: 'Could not establish communication with Backup Server 'SYB_BACKUP'. Please make sure that there is an entry in Sysservers for this server, and that the correct server is running.' SQLState: 'ZZZZZ' Remote Code: '3220' Cause: ''.
[TRACE] [Update Replication:286][RMA] - [ConnectionManager ] - Terminate connection <2110161194(com.sybase.jdbc4.jdbc.SybConnection@742ccab)>: jdbc_sybase_Tds_HA_node_hostname_4905_master_HA_node_hostname_4905_DR_admin_213c9541cd6b4534d2dc759576ee323f (s/r/a/w/t/o) (164/0/0/0/0/0)
[ERROR] [Update Replication:286][RMA] - [ConfigureLocalRSInstance ] - Task Configure a local Replication Server - Failed with error message - Failed attempting to record an entry for dump and load support between host 'HA_node_hostname' and host 'DR_node_hostname' or its alias.
[ERROR] [Update Replication:286][RMA] - [ConfigureLocalRSInstance ] - Task Configure a local Replication Server - Failed with Exception - Message: 'Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.' Cause: ''.
[TRACE] [Update Replication:286][RMA] - [ConfigureLocalRSInstance ] - Task Configure a local Replication Server - Failed with Stack Trace - Can't open a connection to site 'SYB_BACKUP'. See the error log file in the ASE boot directory.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
- SAP Replication Server (SRS) 16.0 for Business Suite
- SAP Adaptive Server Enterprise (ASE) 16.0 with High Availability Disaster Recovery (HADR) for Business Suite
Keywords
sap_update_replication, site3, 3rd node, add, remove, teardown, sp_hadr_admin config_bs, SYB_BACKUP , 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.
SAP Knowledge Base Article - Preview