SAP Knowledge Base Article - Preview

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

Symptom

  • 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()


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

component integration services , 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.