1932587 - Long running CIS transaction has a status of "terminating" and cannot be killed - ASE

• A kill <spid> does not end or terminate the spid
• spid can only be removed by a restart of the dataserver
• sp_who shows the following status for the problem spid with an open CIS connection.

sp_who '104'
go

fid spid status      loginame origname hostname      blk_spid dbname
         tempdbname cmd    block_xloid
--- ---- ----------- -------- -------- ------------- -------- ------
         ---------- ------ -----------
   0  104 terminating sa       sa       <hostname>       0 master
         tempdb     UPDATE        

• The DBCC Stacktrace collected from the terminating spid shows the following:

pc: 0x00000000014ffb56 upsleepgeneric+0x466()
pc: 0x00000000015306cf ksctsuspend+0x37a()
pc: 0x000000000152fadd usctconnect+0x103()
pc: 0x00000000015fb0ed omni_ct_connect+0x6d()
pc: 0x00000000015f2376 omni_connect+0x326()
pc: 0x0000000001614380 omni_opentable+0x440()
pc: 0x0000000001100274 s__setup_tabsdes+0xb24()
pc: 0x00000000010ff6dc s_setuptables+0x5c()
pc: 0x00000000010f5e10 s_execute+0x14c0()
pc: 0x0000000001134f45 sequencer+0x875()
pc: 0x00000000013349a7 internal_sql+0x4b7()
pc: 0x00000000010f825f s_execute+0x390f()
pc: 0x0000000001134f45 sequencer+0x875()
pc: 0x0000000001103e08 execproc+0x718()
pc: 0x00000000010f7b16 s_execute+0x31c6()
pc: 0x0000000001134f45 sequencer+0x875()
pc: 0x0000000001103e08 execproc+0x718()
pc: 0x00000000010f7b16 s_execute+0x31c6()
pc: 0x0000000001134f45 sequencer+0x875()
pc: 0x00000000007bae1c tdsrecv_language+0x1ec()
pc: 0x00000000007db030 conn_hdlr+0x1080()

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

component integration services , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed