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.