SAP Knowledge Base Article - Preview

2664688 - setuphadr failed with Return Code 30064 & 6233 - SRS 16.0

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 with Always-on Option (HADR)
  • SAP Replication Server (SRS) 16.0 SP03 PL04 

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

Keywords

remove_db, CR814938, CR#814838, 814838 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , Bug Filed

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.