3756816 - Error 1143 during upgrade — ASE

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

• Running the upgrade tool it will lead to the following error:

From the ./upgrade output:

Starting upgrade to Adaptive Server 16.1.

        Database 'master' is online.
        Database 'tempdb' is online.
        Database 'model' is online.

[...]

Database 'model' is now online.
        The database 'xxxx' cannot be brought online because we are unable to obtain exclusive access. The command has been aborted.
Fatal error: ct_results() returned unexpected return code.
***     Error 10: Command failed: "online database [xxxx]"
***     Upgrade will continue.
***     Database 'xxxx' (ID 4) did not come online successfully.
        The database 'yyyy' cannot be brought online because we are unable to obtain exclusive access. The command has been aborted.
Fatal error: ct_results() returned unexpected return code.
***     Error 10: Command failed: "online database [yyyy]"
***     Upgrade will continue.
***     Database 'yyyy' (ID 5) did not come online successfully.

[...]       

        Adding appid URL attribute to sysattributes
        Adding appid client id attribute to sysattributes
        Updating sysconfigures and creating new file.
        Upgrade to Adaptive Server 16.1 is complete.
***     The upgrade process encountered 2 errors.
***     Evaluate the errors and correct problems as necessary.  After
***     correcting problems, you can run this utility again to retry.

• Checking the ASE log it will contain the following error and stack trace:
  
  00:0006:00000:00015:2026/05/14 12:37:55.55 server  Error: 1143, Severity: 22, State: 3
  00:0006:00000:00015:2026/05/14 12:37:55.55 server  Invalid OAM Page 12801. Expected object=-983042. Found object=-4128778, database=2, pstat=0x8000, indid=0.
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  ************************************
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  SQL causing error :
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  ************************************
  00:0006:00000:00015:2026/05/14 12:37:55.55 server  SQL Text:
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  curdb = 4 tempdb = 2 pstat = 0x10000 p2stat = 0x101002
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  p8stat = 0x4108 p9stat = 0x4000 p10stat = 0x10000
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  lasterror = 1143 preverror = 0 transtate = 1
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  isolation = 1 tranmode = 0 xactcnt = 0 attn = 0 extattn = 0 memusage = 35
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  curcmd = 193 (SELECT) program = xxx
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  extended error information: hostname:  login: <anonimyzed>
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  server is using elf symbols for stack decoding (133260 symbols found)
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000128fbd9 pcstkwalk+0x28()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000128fa6c ucstkgentrace+0x20b()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000128bd65 ucbacktrace+0xc4()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000008e27a2 terminate_process.cold+0x20df()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000102b588 close_network+0xe()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000102b569 hdl_default+0x30()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x0000000000fe3b1c s_handle.cold+0x54()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x0000000001ef53af exc__raise+0x2cf()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x0000000001ef50b9 exc_raise+0x179()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x0000000001c1b7cd pg__objdeall_validate_obj+0x2cd()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x0000000001c1b32b pg_ptndeall+0x56b()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000015122e0 closetable+0x650()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000164881d LeWkTbl::closeWkTbl()+0x2d()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000234d9d9 LeHashContext::release(ExeCtxt&)+0x99()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000234c660 LeHashOp::_LeOpRelease(ExeCtxt&)+0x40()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x000000000162a119 LeEmittOp::_LeOpRelease(ExeCtxt&)+0x69()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000014e75d6 LePlanRelease+0x246()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  [Handler pc: 0x0x0000000001cf5e10 le_execerr installed by the following function:-]
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000015b1856 exec_lava+0x336()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000015ba88f s_execute+0x10cf()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  [Handler pc: 0x0x0000000001ef5cf0 hdl_stack installed by the following function:-]
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  [Handler pc: 0x0x0000000001eb85a0 s_handle installed by the following function:-]
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000015c6b4c sequencer+0x41c()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000016113c9 tdsrecv_language+0x249()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  [Handler pc: 0x0x00000000021dce00 ut_handle installed by the following function:-]
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  pc: 0x00000000014e4b1d conn_hdlr+0xacd()
  00:0006:00000:00015:2026/05/14 12:37:55.55 kernel  end of stack trace, spid 15, kpid 2031632, suid 6

• Adaptive Server Enterprise ASE 16.0

error 1143, invalid oam page, severity 22, cannot obtain exclusive access, upgrade, user database, single user mode, sp_dboption, ct_results unexpected return code, online database failed, sysprocesses , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem