2572913 - ASE dump transaction failing when triggered from threshold procedure - SAP ASE on BS | SAP Knowledge Base Article

SAP Knowledge Base Articles - preview

2572913 - ASE dump transaction failing when triggered from threshold procedure - SAP ASE on BS


  • You have implemented log free threshold procedure suggested by SAP Note 1801984 free up space in the transaction log that has been filled due to a long running transaction (sp_thresholdaction_logfreespace)
  • ASE SP version is >= ASE 16 SP02 PL01, which support full database encryption.
  • SID database is encrypted.
  • ASE error log is reporting signal 11 and stacktrace for sp_thresholdaction_logfreespace procedure when trying to dump transaction, involving those modules:

    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel Current process (0x72701a5) infected with signal 11 (SIGSEGV)
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel Address 0x0x0000000001a3d73d (dmpx__find_dmpxact_type+0x7d), siginfo (code, address) = (1, 0x0x000000000000003a)
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel Current statement number: 17 Current line number: 4
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel ************************************
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx server SQL Text: saptools..sp_thresholdaction_logfreespace <SID>, logsegment, xx
    00:0008:00000:00212:2017/02/24 22:57:00.16 server SQL Text:

                     dump transaction @dbname using config = '<SID>LOG'
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a3d73d dmpx__find_dmpxact_type+0x7d()
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a3a4d1 dmpx__setup+0x101()
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel [Handler pc: 0x0x0000000000b0fb3a dpdb_handle installed by the following function:-]
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a394ce dmpx_truncatemain+0x1ce()
    00:0006:00000:00xxx:20xx/xx/xx xx:xx:xx.xx kernel pc: 0x0000000001a391f3 dmpxact+0x63()

  • As per ASE and Backup Server logs, this doesn't happens on each dumps but at least the third time the dump is triggered thru the threshold procedure.



  • SAP Adaptive Server Enterprise (ASE) 16.0 for Business Suite
  • SAP NetWeaver (NW) - All versions 


SAP Adaptive Server Enterprise 16.0 ; SAP NetWeaver all versions


transaction, dump, signal 11, dmpx__find_dmpxact_type, sp_thresholdaction_logfreespace, 806252 , KBA , BC-DB-SYB , SAP Business Suite on Sybase ASE Database Platform , 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.