SAP Knowledge Base Article - Preview

3053709 - Error: 11068 with stack trace when create proc - SAP ASE

Symptom

  • create procedure statement was 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

SAP Adaptive Server Enterprise 16.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.