Symptom
- A long running process was identified in syslogshold
- A kill <spid> was issued and a rollback status check
- Using kill <spid> with statusonly showed no rollback progression
- Checking the ASE error log shows the following:
server Error: 8203, Severity: 26, State: 20
server Error: 8203, Severity: 26, State: 20
server Expected to find the descriptor for object 1464878786 in database 2 in CREATE state.
server Expected to find the descriptor for object 1416878615 in database 2 in CREATE state.
kernel ************************************
kernel SQL causing error : <SQL ERROR> 136944
kernel Current statement number: 2 Current line number: 5
kernel ************************************
server SQL Text: <SQL TEXT>136944
kernel curdb = 2 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
kernel ************************************
kernel p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
kernel SQL causing error : <SQL ERROR> 151163
<snip>
kernel pc: 0x0000000080b1b57c des_create_inxact+0x2bc
kernel pc: 0x0000000080e07d5c ex_raise+0x270
kernel pc: 0x0000000080b1b57c des_create_inxact+0x2bc
kernel pc: 0x0000000080edf014 crt_main+0x13cc
kernel pc: 0x0000000080454434 _$o1cexmA0.s_execute+0xf34
kernel pc: 0x0000000080edf014 crt_main+0x13cc
<snip>
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7
- Sybase Adaptive Server Enterprise (ASE) 15.0
- Sybase Adaptive Server Enterprise (ASE) 15.5
Product
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
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