1960890 - Errors 940 and 6103 reported when parallel query uses a shared worktable - ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

1960890 - Errors 940 and 6103 reported when parallel query uses a shared worktable - ASE

Symptom

  • A Parallel query that uses a shared worktable does result in Error: 940, Severity: 26, State 11 "Dbtable in wrong state for Operation" followed by a stacktrace and the process being terminated.

server  Error: 940, Severity: 26, State: 11
server  Dbtable in wrong state for operation: DBTABLE pointer = 0x0x19ecfa280, dbid = 10, state = 0x2, status= 0xc, keep = 0, system task keep = 0, name = 'tempdb_2'.
kernel  ************************************
kernel  SQL causing error : 
kernel  Current Procedure: XXXXXXXXX
kernel  Current statement number: 6 Current line number: 32
kernel  ************************************
server  SQL Text:
server  SQL Text: SELECT @id_source = id_source

  FROM...

kernel  curdb = 10 tempdb = 10 pstat = 0x10000 p2stat = 0x101000
kernel  p3stat = 0x800 p4stat = 0x0 p5stat = 0x8 p6stat = 0x11 p7stat = 0x10000
kernel  lasterror = 940 preverror = 0 transtate = 1
kernel  curcmd = 193 program = isql                         
kernel  extended error information: hostname: XXX login: XXX
kernel  pc: 0x00000000014ccabb pcstkwalk+0x3a3()
kernel  pc: 0x00000000014cc593 ucstkgentrace+0x263()
kernel  pc: 0x00000000014c850e ucbacktrace+0x50()
kernel  pc: 0x000000000077a5ac terminate_process+0x130c()
kernel  pc: 0x0000000001196fd6 hdl_default+0x3b()
kernel  pc: 0x00000000011337e7 s_handle+0x3c7()
kernel  pc: 0x00000000011960bf ex_raise+0x23f()
kernel  pc: 0x0000000000d500de dbt_unkeep+0x52e()
kernel  pc: 0x0000000000d38dc8 closedb+0xa8()
kernel  pc: 0x0000000000aadca3 sdes_hookup+0x573()
kernel  pc: 0x0000000000fb4bd1 run_crtable+0x1f1()
kernel  pc: 0x0000000000842b7a LeWkTbl::crtWkTbl(int, short, int)+0x14a()
kernel  pc: 0x0000000001748491 LeStoreOp::_LeOpAcquire(ExeCtxt&)+0x26f()
kernel  pc: 0x00000000007ff4a9 LeEmitXchgOp::LeOpFinishCG(CgPhase2*, LeBufferNeeded)+0x279()
kernel  pc: 0x00000000017432fa LeSequencerOp::_LeOpAcquire(ExeCtxt&)+0x8a()
kernel  pc: 0x00000000007f571a LeEmittOp::_LeOpAcquire(ExeCtxt&)+0x5a()
kernel  pc: 0x00000000007eb4ab LePlanAcquire+0x5bb()
kernel  pc: 0x0000000000f74b11 exec_lava+0x221()
kernel  pc: 0x00000000010f6c1e s_execute+0x129e()
kernel  pc: 0x0000000001136fcb sequencer+0x17cb()
kernel  pc: 0x0000000001104f29 execproc+0x709()
kernel  pc: 0x00000000010f8b56 s_execute+0x31d6()
kernel  pc: 0x0000000001136fcb sequencer+0x17cb()
kernel  pc: 0x0000000001104f29 execproc+0x709()
kernel  pc: 0x00000000010f8b56 s_execute+0x31d6()
kernel  pc: 0x0000000001136fcb sequencer+0x17cb()
kernel  pc: 0x00000000007bae1c tdsrecv_language+0x1ec()
kernel  pc: 0x00000000007db028 conn_hdlr+0x1078()
kernel  end of stack trace, spid 216, kpid 270468020, suid 3

  • Subsequent 6103 error is also reported:

Error: 6103, Severity: 17, State: 1
server  Unable to do cleanup for the killed process


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

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

Search for additional results

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