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

• 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.

SAP Replication Server (SRS) 16.0

sysadmin, dump_queue, sqm_zap_tran , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Problem