SAP Knowledge Base Article - Preview

3075027 - 'dbcc gettrunc' displays negative STP page number - SAP ASE

Symptom

  • In the "dbcc gettrunc" output, the secondary truncation point (STP) shows a negative number:
    secondary trunc page secondary trunc state dbrepstat generation id database id database name ltl version
    -------------------- --------------------- --------- ------------- ----------- ------------------------------ -----------
    -900094504                                 1             239            8                  13           <db_name>       760

  • "sp_help_rep_agent <db_name>" displays that rep agent markers are current:
    Replication Agent Scan Status
    dbname   pathname scanner_spid start_marker   end_marker      current_marker  log_recs_scanned oldest_transaction
    -------- -------- ------------ --------------- --------------- --------------- ---------------- --------------------------------------
     <db_name> n/a                 31   (3395406988,21) (3395407007,15) (3395407007,15)    46306379 (3394872792,15)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • SAP Replication Server (SRS) 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

CR766119, 766119, CR#766119, CR780037, 780037, CR#780037 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.