Skip to Content
0
May 29, 2018 at 12:16 PM

Replication Server - Outbound queue is not moving

1316 Views Last edit May 29, 2018 at 12:44 PM 2 rev

Hello ,

Using Oracle source to Oracle destination by using SAP Replication Server 15.7 .

Source is transaction intense system. Most of the time getting memory warnings saying resource not available for clearing largest transaction.

OUTBOUND QUEUE in REP SERVER :

1>admin who,sqt,104

2>go

Spid State Info Closed Read Open Trunc Removed Full SQM Blocked First Trans Parsed SQM Reader Change Oqids Detect Orphans -------- ---------------------------------------- ------------------------------------------------------------------------------------------------------------------------ -------

229 Awaiting Message 104 odsdb.ODSDB 0 0 1 1 1 0 0 st:O,cmds:50807,qid:186261:2:0 1 0 0 0

Outbound queue size is 170 GB & not getting drained. When I do trace ON , SQL's are flowing.

Thanks,

Yuvaraj Subramani