SAP Knowledge Base Article - Preview

2788273 - Replication Stopped ERROR #9022 DIST -SRS

Symptom

  • Encountered a replication outage with the following error message along with the threads down as following.  
    Spid Name State Info
    ---- --------------- -------------------- ------------------------------------------------------------
    DIST Down 102 PDS.db 
    SQT Down 102:1 DIST PDS.db
    SQM Down 107:0 RDS.db    
  • Replication stopped DIST down with ERROR 9022 in errorlog:
    ERROR #9022 DIST(102 FIRM_P1.db_firmprod) - /generic/gtr/tdext.c(1168)
    Cannot deliver a command from PDS.db since no transaction is open.
    DIST for 'PDS.db' is waiting for SQM(s) to flush to outbound queue(s).
    The distributor for 'PDS.db' is shutting down  
  • Tried to resume the DIST and SQM but that didn't work.
  • Then turned on trace for dist and then turned it off after 3min.  Somehow, those downed thread were back up-and-running in a few minutes.   Need to know the root cause of the original issue and the reason what eliminated this issue internally afterwards.
    trace 'on', dist, dist_trace_commands
    go
       

Read more...

Environment

  • Replication Server/15.7.1/EBF 25497 SP303 rs1571sp303/Linux AMD64
  • Adaptive Server Enterprise/16.0 SP02 PL02/EBF 25320 SMP/P/x86_64/Enterprise Linux

Product

SAP Sybase Replication Server 15.7, heterogeneous edition

Keywords

resume distributor, , 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.