2472929 - Processes are in sleeping status with stacktrace showing kmrtmsg function and not able to kill -- SAP ASE

• The processes are in sleeping state and has the open transactions.
• On running the below command, we can see the process is the long running process and in sleeping state
• dbcc traceon(3604)
  go
  dbcc stacktrace(<SPID>)
  go
  pc: 0x0000000001895f1e upsleepgeneric+0x5be()
  pc: 0x00000000018847e4 kmrtmsg+0x2d4()
  pc: 0x0000000001884187 smget+0x57()
  [Handler pc: 0x0x0000000001536e08 aud_handle installed by the following function:-]
  [Handler pc: 0x0x0000000001536e08 aud_handle installed by the following function:-]
  pc: 0x000000000153624e audproc+0x1534()
  dbcc stacktrace finished
   
• The sp_who output shows the status as sleeping
   fid          spid             status                           loginame                         blk_spid                         cmd   
  ------------------------------------------------------------------------------------------------------------
     0            XXX             sleeping                         NULL                             NULL         XXXXXXXXXXX
• systransaction shows the SPID entry.
• Even if you kill the process the process may not be killed normally.

• SAP Adaptive Server Enterprise (ASE) 15.7, 16.x
• SAP Adaptive Server Enterprise (ASE) Clustered Edition 15.7, 16.x

Sleeping process, kmrtmsg, "number of messages", kill, SAP ASE , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem