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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.