Symptom
- The alter login or dump database is aborting with stack trace due to "sysusers" system table corrupted.
kisignal+0x83b()
dol__index_decompress_row+0x134()
index_decompress_row+0x56()
bt__lfrow_cmp+0x401()
bt__srch_lpage+0x154()
bt__srchpage+0x352()
bt__traverse+0x587()
bt__getstartpg+0x29d()
bt_getnext_no16FTR+0x88e()
dol_bt_getnext_no16FTR+0x1d3()
getnext+0x140()
sdes_scan_error_hdlr
sdes_scan_setup+0x5be()
lookup__sysusers+0xf8()
getuidfromsuid+0x142()
check_db_perm+0x250()
find_uid+0x3c8()
dbcontext_change+0xb9()
usedb+0x3c()
dpdb_handle
dpdb_main+0x480()
s_execute+0xb4f6()
- The dbcc checktable is reporting error "15996", "15997" and "806" in sysusers.
1> dbcc checktable (sysusers)
2> go
Checking table 'sysusers' (object ID 10): Logical page size is 2048 bytes.
Checking partition 'sysusers_10' (partition ID 10) of table 'sysusers'. The logical page size of this table is 2048 bytes.
The total number of data pages in partition 'sysusers_10' (partition ID 10) is 1.
Partition 'sysusers_10' (partition ID 10) has 21 data rows.
The total number of empty pages (with all deleted rows) in partition 'sysusers_10' (partition ID 10) is 0.
The total number of pages in partition 'sysusers_10' (partition ID 10) which could be garbage collected to free up some space is 1.
The total number of deleted rows in partition 'sysusers_10' (partition ID 10) is 1.
The total number of pages in partition 'sysusers_10' (partition ID 10) with more than 50 percent garbage is 0.
The total number of pages in partition 'sysusers_10' (partition ID 10) with more than 50 percent insert free space is 1.
The total number of data pages in this table is 1.
The total number of pages which could be garbage collected to free up some space is 1.
The total number of deleted rows in the table is 1.
The total number of pages with more than 50 percent insert free space is 1.
Table has 21 data rows.
Msg 15996, Level 16, State 1:
Server 'XXXXX_DS', Line 1:
NCFS on leaf page 305 appears to be incorrect. Expected 12716, but got 44.
Msg 15997, Level 16, State 1:
Server 'XXXXX_DS', Line 1:
The number of RIDs not deleted on leaf page 305 appears to be incorrect. Expected 28003, but got 21.
Msg 806, Level 16, State 1:
Server 'XXXXX_DS', Line 1:
Could not find virtual page for logical page 2835793830 in database 'db_name'.
DBCC execution completed. If DBCC printed error messages, contact a user with Administrator role.
Read more...
Environment
SAP ASE 16.0
Keywords
dol__index_decompress_row, index_decompress_row, lookup__sysusers, Msg 15996, Msg 806, sysusers corrupt , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.
SAP Knowledge Base Article - Preview