SAP Knowledge Base Article - Preview

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)
    dbcc stacktrace(<SPID>)
    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


SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Adaptive Server Enterprise 16.0 Cluster Edition ; Sybase Adaptive Server Enterprise Cluster Edition 15.7


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

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.