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
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.
SAP Knowledge Base Article - Preview