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 for Me (Login required).

Search for additional results

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