SAP Knowledge Base Article - Preview

3308712 - The DIST thread was not automatically resumed after hostavailable completed - SRS

Symptom

  • A failover succeeded in HADR system

  • The sap_host_available failed due to repserver error:

    [RMA] - [PurgeInOutboundQueue     ] - Executing 'sysadmin sqm_purge_queue, 110, 1' on the Replication Server at <xxxx:4905>.

    [RMA] - [PurgeInOutboundQueue     ] - Result from command:SQL ERROR -- Message: 'Capture for database 'SID_Site2_R1.SID' is alive.' SQLState: 'null'  Remote Code: '74094' Cause: ''.SQL ERROR -- Message: 'Can't purge queue(110:1). Replication Server is NOT in standalone or hibernation mode. Need to suspend 0 EXEC, 1 Capture, 0 DIST, 0 RSI USER, 0 DSI.' SQLState: 'null'  Remote Code: '6233' Cause: ''.

  • Finally successful after executing the command sap_host_available again

  • Data replication cannot occur after failover due to DIST thread down


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 with HADR
  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite with HADR

Product

SAP Adaptive Server Enterprise 16.0 ; SAP Replication Server 16.0

Keywords

sap_host_available, failover, CR 827770, Remote Code: '74094', Remote Code: '6233', DIST thread , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , BC-SYB-REP , Sybase Replication Server (standalone) , Known Error

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.