SAP Knowledge Base Article - Preview

3789501 - error 8201 stack trace during index rebuild-- SAP Adaptive Server Enterprise

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.