SAP Knowledge Base Article - Preview

3277447 - Error 820 state 6 with stack trace in saptempdb or tempdb database - SAP ASE

Symptom

  • Error 820 state 6 in saptempdb database (or tempdb database) is raised in ASE log file:

    Error: 820, Severity: 21, State: 6
    Attempt to dirty non-log buffer BUF=0x0x00000002ba1296d8, MASS=0x0x00000002ba1296d8, Buf#=0, page=0x0x000000025a36c000, dbid=6, Mass vdevno=12, vpage=1472, Buf lpage=184, Mass stat=0x5111008, Buf stat=0x1, size=16384, cid=0 ('default data cache'), Pinned xdes=0x0x000000019e6b5580, spid=xx which is in I/O.
    WARNING: 1 buffer was found in a predirty state during the termination of spid 251 (Pss: 0x0x00000001d136a658).
    kernel  ************************************
    kernel  SQL causing error : insert into saptempdb..DUMP_MONITORCONFIG(Name, Config_val, System_val, Total_val, Num_free, Num_active, Pct_act, Max_Used, Reuse_cnt, Date, Instance_
    kernel  Current Procedure: sp_monitorconfig
    kernel  Current statement number: 180 Current line number: 1011
    kernel  ************************************
    server  SQL Text: insert into saptempdb..DUMP_MONITORCONFIG(Name, Config_val, System_val, Total_val, Num_free, Num_active, Pct_act, Max_Used, Reuse_cnt, Date, Instance_Name) values('compression info pool size',32768,0,32768,25924,6844, ' 20.89',7009, 0, 'Oct 26 2022 10:00PM' ,'')
    pcstkwalk
    ucstkgentrace
    ucbacktrace
    terminate_process
    hdl_default
    exc__raise
    exc_raise
    bufpindirty
    xls_bufpindirty_single
    bufdirty
    dol_deldrow
    dol_row_delete
    dol_delete
    row_delete
    ... ...

  • The full database dump of saptempdb (or tempdb) is being taken at same time.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite

Product

SAP Adaptive Server Enterprise all versions

Keywords

sp_monitorconfig, Error 820, CR 821937 , CR821927, saptempdb, tempdb , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.