SAP Knowledge Base Article - Preview

2196100 - Outbound DSI queue not draining - SRS

Symptom

  • Outbound DSI queue is not moving.
  • Outbound DSI queue appears stuck. 
  • The "First Trans" column in the "admin who,sqt" output shows status 'C' or 'R', and high "cmd" count: 

 Spid State   Info                 ... First Trans ...  
 ---- ------- -----------------    ------------------------------
 130 Active   103 dsname.dbname ... st:C,cmds:nnnnnnn,qid:988:57:0   ...

  • The number "nnnnnnn" is larger than the number reported by "sp_configure locks" executed in the target dataserver ("dsname").


Read more...

Environment

  • SAP Replication Server
  • SAP Replication Server Real Time Loading
  • SAP Replication Server Heterogeneous Edition
  • Sybase  Replication Server
  • Sybase Replication Server Real Time Loading
  • Sybase Replication Server Heterogeneous Edition

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Replication Server all versions ; SAP Replication Server, heterogeneous edition all versions ; SAP Replication Server, real-time loading edition all versions ; Sybase Replication Server software all versions ; Sybase Replication Server, heterogeneous edition all versions ; Sybase Replication Server, real-time loading edition all versions

Keywords

Repserver hung hangs frozen sp_configure locks , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-HET , Replication Server Heterogeneous Edition (RSHE) , BC-SYB-REP-RTL , Rep Server Real-Time Loading Edition (RTLE) , BC-SYB-REP-ME , Replication Server Messaging Edition (RSME) , Problem

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.