SAP Knowledge Base Article - Preview

2664688 - HADR: setuphadr failed with Return Code 30064 & 6233 - SRS

Symptom

  • When setting up HADR system using SRS 16.0 SP03 PL04, setuphadr failed at Add Database to Replication  
     
  • RMA issues sap_update_replication, add_db to add the specified database to the HADR replication system.
     
  • setuphadr output shows the following msgs:
    • PurgeInOutboundQueue Failing Command sysadmin sqm_purge_queue, 106, 1
      PurgeInOutboundQueue Failing Command Return Code 30064
      PurgeInOutboundQueue Failing Command Error MessageFailed to purge 'inbound' queue data for server named 'PDS_R1' and database 'master'.
      PurgeInOutboundQueue Failing Exception Message: 'Distributor for database 'PDS_R1.master' is alive.' Cause: ''.
       
  • RMA log reports the following msgs:
    • [Setup replication:349][RMA] - [PurgeInOutboundQueue ] - Result from command:SQL ERROR -- Message: 'Distributor for database 'PDS_R1.master' is alive.' SQLState: 'null' Remote Code: '30064' Cause: ''.SQL ERROR -- Message: 'Can't purge queue(106:1). Replication Server is NOT in standalone or hibernation mode. Need to suspend 0 EXEC, 0 Capture, 1 DIST, 0 RSI USER, 0 DSI.' SQLState: 'null' Remote Code: '6233' Cause: ''
      [ERROR] [Setup replication:349][RMA] - [PurgeInOutboundQueue ] - Task Purge Inbound or Outbound Queue - Failed performing command - sysadmin sqm_purge_queue, 106, 1


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL04
     
  • SAP Replication Server (SRS) 16.0 SP03 PL04

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

Keywords

add database; sap_update_replication; add_db; remove_db; CR 814938; 814838 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.