Symptom
- Stack trace error 8201 occurs during creating index
- Error message: “Error: 8201, Severity: 26, State: . Keep count of descriptor (objid=%d, dbid=%d) was expected to be %d. Instead %d was found.”
- Observed during CREATE INDEX (INDCREATE); stack traces often reference descriptor keep/unkeep routines.
server Error: 8201, Severity: 26, State: 6
server Keep count of descriptor (objid=xxxxx, dbid=x) was expected to be 1. Instead 0 was found.
kernel ************************************
server SQL Text: CREATE INDEX
kernel curdb = x tempdb = 12 pstat = 0x10000 p2stat = 0x80901000
kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x1 p7stat = 0x10000
kernel p8stat = 0x8004100 p9stat = 0x4000 p10stat = 0x10
kernel lasterror = 8201 preverror = 0 transtate = 0
kernel isolation = 1 tranmode = 0 xactcnt = 1 attn = 0 extattn = 0 memusage = 57
kernel curcmd = 294 (INDCREATE) program = isql
kernel extended error information: hostname: syb_run_proc.sp__mnt.0725.1803 login: ucc_dba
kernel pc: 0x000000000113e38f pcstkwalk+0x28()
kernel pc: 0x000000000113e024 ucstkgentrace+0x3b0()
kernel pc: 0x000000000113aae7 ucbacktrace+0xba()
kernel pc: 0x0000000001659ab5 terminate_process+0x1c75()
kernel pc: 0x0000000000e81d7e hdl_default+0x30()
kernel pc: 0x0000000001ca81b2 exc__raise+0x2e2()
kernel pc: 0x0000000001ca7e2b exc_raise+0x11b()
kernel pc: 0x0000000001ac1c3d des__unkeep+0xbd()
kernel pc: 0x00000000015364a6 des_unkeep+0x66()
kernel pc: 0x0000000001b85a23 ptn_endxact_processing+0xa3()
kernel pc: 0x000000000192884f abort__all+0x1af()
kernel pc: 0x0000000001ba3ce3 xact__rollbackxact+0x353()
kernel pc: 0x0000000001ba37eb xact__rollback_local+0x3b()
kernel pc: 0x0000000001ba331a xact_rollback+0x1fa()
kernel [Handler pc: 0x0x0000000001e7dae0 ut_handle installed by the following function:-]
kernel pc: 0x0000000001db1c26 cri_main+0x3636()
kernel pc: 0x00000000015fdac4 s_execute+0x5114()
Read more...
Environment
- SAP Adaptive Server Enterprise
Product
SAP Adaptive Server Enterprise 16.0
Keywords
ASE, error 8201, keep count of descriptor, deskeepcnt, des__unkeep, des_rekeep, INDCREATE, create index, index rebuild, weekend maintenance, monOpenObjectActivity, monCachedProcedures, ignore outdated plans, csmd, sp_shmdumpconfig, timeslice reported , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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