SAP Knowledge Base Article - Preview

2909347 - Outbound queue has a stale Open tran. Queue size is growing. - SRS

Symptom

  • One outbound queue does not drain.
  • In "admin who, sqm", First Seg.Block is not moving while Last Seg.Block is increasing:        

 Spid State                Info                                                         Duplicates                Writes                    Reads                     Bytes                     B Writes                  B Filled                  B Reads                   B Cache                   Save_Int:Seg                    First Seg.Block                 Last Seg.Block                  Next Read                       Readers     Truncs      Loss Status
 ---- -------------------- ------------------------------------------------------------ ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------- ------------------------------- ------------------------------- ------------------------------- ------------------------------- ----------- ----------- -------------------------------
   16 Awaiting Message     440:0 RDS.rdb                                                                        0                       705                  10156464                    211570                       235                         0                   1276085                       235 0:37427                         37427.28                        47398.16                        47398.17.0                                2           1 No Loss

  • "admin who, sqt" shows the same Open transaction for a very long time:

1> admin who,sqt
2> go
 Spid State                Info                                                         Closed      Read        Open        Trunc       Removed     Full        SQM Blocked First Trans                                   Parsed      SQM Reader  Change Oqids Detect Orphans
 ---- -------------------- ------------------------------------------------------------ ----------- ----------- ----------- ----------- ----------- ----------- ----------- --------------------------------------------- ----------- ----------- ------------ --------------
   74 Awaiting Message     440 RDS.rdb                                                         0           0           2           2           0           0           0 st:O,cmds:2,qid:37427:29:0                              0           0            0              0

  • A queue dump shows a transaction with BEGIN TRAN and UPDATE in Segment 37427 Block 29 Row 0-1, and there is no COMMIT for this transaction.
  • Rebooting RepServer has no effect.
  • Data is successfuly replicating to the replicate database with no errors.


Read more...

Environment

SAP Replication Server (SRS) 16.0

Product

SAP Replication Server 16.0

Keywords

sysadmin, dump_queue, sqm_zap_tran , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , 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.