SAP Knowledge Base Article - Preview

2945063 - DUMP TRANSACTION command hangs and server crash during normal processing on AIX - SAP ASE for Business Suite

Symptom

  • In rare cases, ASE command "DUMP TRANSACTION" may get hung on AIX.
  • Subsequent attempts to execute a "DUMP TRANSACTION" command will also get hung.
  • The offending ASE task cannot be killed - a reboot of the ASE server is necessary to clear the situation.

  • The stacktrace of the hung ASE task (spid) is:

Start dbcc stacktrace...
pc: 0x00000004b09db4c0 ()
pc: 0x00000001030f768c kpsuspend.fdpr.chunk.3+0xc()
pc: 0x0000000102488ac4 upsleepgeneric+0x2c8()
pc: 0x00000001024c5e4c uppause+0x154()
pc: 0x0000000102d8b384 dmpx__get_seqnum.fdpr.chunk.1+0x90()
[Handler pc: 0x000000010177eb6c dpdb_handle installed by the following function:-]
pc: 0x00000001025b2c00 dmpx_truncatemain+0x300()
pc: 0x00000001026ad6c8 dmpxact+0x88()

  • In the output of the OS command procstack for the ASE dataserver process you will find a thread in call stack similar to the one below:

_p_sigtimedwait(??, ??, ??) + 0x14c
sigtimedwait(??, ??, ??) + 0x30
kisigwait(??) + 0x34
krtctskRun(??) + 0x68
ktskRun(??) + 0x80
ktRTCThreadMain(??) + 0x1bc
thread_create_handler(0x110cc4f70) + 0xe8
_pthread_body(??) + 0xf0

  • One or more of the below error messages may be found in the ASE error log corresponding to the timestamp when the offending DUMP TRANSACTION was started or soon after:

    enp_rsaDecrypt: CCLDecryptionCtx_decrypt failed with error: 0xa010000d

    Error: 11223, Severity: 16, State: 9 Insufficient memory is available to allocate structures needed to access a remote site.

    Error: 12034, Severity: 17, State: 1 Collection of monitoring data for table 'monCachedObject' failed due to insufficient memory. Retry when there is less load, or fewer users, on the server. 1963 rows were not returned because 47112 bytes of memory could not be allocated.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP03 
  • AIX

Product

SAP ERP 6.0

Keywords

enp_rsaDecrypt, 11223, 12034, "DUMP TRANSACTION", "DUMP TRAN", hangs, hanging, AIX, SIGALRM, heap, CR821905, 821905, CR#821905 , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

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.