Symptom
create procedure statement failed with 11068 error and stack trace
Full stack trace is below:
server Error: 11068, Severity: 20, State: 1
server Transaction was found in the incorrect state of 'Command-attached'. The expected state was 'Done command-attached'.
kernel ************************************
kernel SQL causing error : create table [##Request] like [dbo].[Request]
kernel ************************************
kernel curdb = 21 tempdb = 2 pstat = 0x10000 p2stat = 0x84101000
kernel p3stat = 0x10800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x810000
kernel lasterror = 11068 preverror = 0 transtate = 0
kernel curcmd = 198 program = isql
kernel extended error information: hostname: ****** login: sa
kernel pc: 0x00000000819e9968 pcstkwalk+0x18(0x001ffffd20caa070, 0x001ffffd20ca78a8, 0x000000000000270f, 0x0000000000000002, 0x0000000000000016)
kernel pc: 0x00000000819e97b0 ucstkgentrace+0x23c(0x0000000056130384, 0x0000000000000002, 0x000000000000270f, 0x0000000000000000, 0x0000000000000000)
kernel pc: 0x00000000819e50dc ucbacktrace+0xe4(0x0000000056130384, 0x0000000000000001, 0x0000000083a94000, 0x0000000000000008, 0x001ffffd41c29fe0)
kernel pc: 0x0000000080987f74 terminate_process+0x1c24(0x000000000000ee18, 0xffffffffffffffff, 0x0000000000000000, 0x0000000000011800, 0x0000000000002000)
kernel pc: 0x000000008154abc8 hdl_default+0x50(0x000000000000006e, 0x0000000000002b3c, 0x00000000000001b8, 0x0000000000000001, 0x000000000000014a)
kernel pc: 0x00000000815491ac exc__raise+0x334(0x001ffffd6ceee458, 0x001ffffd6cf005e0, 0x000000000000006e, 0x0000000000000044, 0x001ffffd6cf005e0)
kernel pc: 0x0000000081548d60 exc_raise+0x144(0x0000000000000001, 0x00000000000000c6, 0x00000000000000c6, 0x001ffffd89891bb0, 0x0000000000000001)
kernel pc: 0x00000000805dead8 _$o1cexoQ0.s_estmt_loopend+0x378(0x0000000000000000, 0x001ffffd89891850, 0x0000000000000001, 0x0000000000000000, 0x001ffffd6ceee458)
kernel pc: 0x00000000804e5d90 s_execute+0x27d0(0x0000000000000000, 0x0000000000000000, 0x0000000000000001, 0x0000000000000000, 0x001ffffd6ceee458)
kernel [Handler pc: 0x000000008154a164 hdl_stack installed by the following function:-]
kernel [Handler pc: 0x00000000814c9c9c s_handle installed by the following function:-]
kernel pc: 0x0000000080731184 sequencer+0x484(0x0000000000000000, 0x0000000000000002, 0x0000000000011e00, 0x0000000000011c00, 0x001ffffd6ceee458)
kernel [Handler pc: 0x0000000081800aa0 intsql__handle installed by the following function:-]
kernel pc: 0x0000000081800278 internal_sql+0x57c(0x0000000000000000, 0x0000000000000000, 0x000000000000ec00, 0x000000000000e678, 0x000000000000e800)
kernel pc: 0x000000008145fa08 create_internal_globaltt+0xce0(0x001ffffd20cac3f4, 0x001ffffd9c631d52, 0x001ffffd20cac4f8, 0x0000000000800000, 0x000000000000000b)
kernel pc: 0x0000000080d40a30 open__tempbyname+0x7b8(0x001ffffd021b8720, 0x001ffffd20cacff8, 0x0000000000000000, 0x001ffffd20cacfe4, 0x001ffffd9c631d50)
kernel pc: 0x000000008080d3a4 _$o1cezaN0.sequencer+0x3e44(0x0000000000000000, 0x0000000000001042, 0xfffffffffffffffe, 0x0000000000000000, 0x000000000000e880)
kernel [Handler pc: 0x000000008154a1a0 hdl_backout_msg installed by the following function:-]
kernel pc: 0x000000008072ee20 open_user_table+0x1a0(0x0000000000000000, 0x00000000fffffffe, 0x0000000000000015, 0x001ffffd6ceee458, 0x0000000000000001)
kernel pc: 0x00000000815564a8 getid+0x3c(0x0000000000000015, 0x001ffffd9c631d50, 0x0000000000000009, 0x001ffffd20cad914, 0x001ffffd20cad912)
kernel [Handler pc: 0x0000000080ff6e44 jcsExHandler installed by the following function:-]
kernel [Handler pc: 0x000000008154a1a0 hdl_backout_msg installed by the following function:-]
kernel [Handler pc: 0x000000008154a1a0 hdl_backout_msg installed by the following function:-]
kernel pc: 0x0000000080795644 _$o1ceywG0.fill_sysdepends+0xc4(0x0000000000150001, 0x0000000000000015, 0x001ffffd6ceee458, 0x001ffffd6ceefd58, 0x001ffffd9c631d00)
kernel [Handler pc: 0x00000000819427cc ut_handle installed by the following function:-]
kernel pc: 0x0000000081848708 proccreate+0xbc8(0x0000000000001000, 0xfffffffffffffff8, 0x000000000000e400, 0x000000004f88885c, 0x001ffffd6ceee458)
kernel pc: 0x0000000080793a90 s_crtproc+0x250(0x0000000000000000, 0x000000000000f000, 0x0000000000000001, 0x0000000000000000, 0x0000000082903aa8)
kernel [Handler pc: 0x000000008154a164 hdl_stack installed by the following function:-]
kernel [Handler pc: 0x00000000814c9c9c s_handle installed by the following function:-]
kernel pc: 0x000000008080a018 _$o1cezaN0.sequencer+0xab8(0x0000000083aafc00, 0x0000000000000002, 0x0000000000011e00, 0x0000000000011c00, 0x001ffffd6ceee458)
kernel pc: 0x00000000809d6a1c tdsrecv_language+0x32c(0x001ffffd6ceee458, 0x0000000000000000, 0x0000000000000000, 0x000000000000e400, 0x0000000000000000)
kernel [Handler pc: 0x00000000819427cc ut_handle installed by the following function:-]
kernel pc: 0x0000000080803874 _$o1cezaK0.conn_hdlr+0x314(0x001ffffd021b8720, 0x0000000000000021, 0x0000000000012038, 0x001ffffd6ceee458, 0x001ffffd6ceee458)
kernel pc: 0x0000000081a1b1e0 _coldstart(0x0000000000000209, 0x00000000808038a4, 0x0000000000000000, 0x0000000000000000, 0x0000000000000000)
kernel end of stack trace, spid 1102, kpid 1444086660, suid 1
Read more...
Environment
SAP Adaptive Server Enterprise 16.0 SP02 or later
Product
Keywords
11068, command-detached , 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