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.