SAP Knowledge Base Article - Preview

3214582 - WARNING #24070 A timeout has occurred while a large transaction was waiting for the next message to be read.

Symptom

  • Same error can be seen in the Replication Server file:
    WARNING #24070 dALARM( ) - generic/sqt/sqtint.c(9705)
    SQT(107:0 RDS.rdb): A timeout has occurred while a large transaction ( '000a000bffeb119800' % xxx '000000' l '00000000') was waiting for the next message to be read.

  • The SQT thread in "Awaiting DSI/E rollback" status from "admin who,sqt"
    Like this:
    Spid State                          Info                                                         Closed      Read        Open        Trunc       Removed     Full        SQM Blocked First Trans                                   Parsed      SQM Reader  Change Oqids Detect Orphans  
    ---- ------------------------------ ------------------------------------------------------------ ----------- ----------- ----------- ----------- ----------- ----------- ----------- --------------------------------------------- ----------- ----------- ------------ --------------  
    473 Awaiting DSI/E rollback        107 <RDS>.<rdb>                                                   1           0           6           7           5           0           0 st:O,cmds:958000,qid:16262:42:0                    239003           0            0              0    


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Replication Server 16.0

Keywords

WARNING #24070, 24070, dsi_large_xact_timeout , "Awaiting DSI/E rollback", timeout , KBA , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.