SAP Knowledge Base Article - Preview

2081276 - Error: 832, Severity: 20, State: 1 - SAP ASE

Symptom

  • When configuration parameter 'max buffers per lava operator' is set to maximum of 65535 or a value close to the maximum
  • User session terminates unexpectedly with error 832 reported to the client:
     
    Error: 832, Severity: 20, State: 1
    Unable to place buffer <hex#> holding logical page 24 in sdes for object 'temp worktable' - there is no room in sdes aux keep pool.
     
  • ASE errorlog also reports error 832, with (many) additional log messages and followed by a stacktrace which includes ASE functions bufkeep , buf__unhash_and_keep_grabbed_mass , bufreserve , sort_bufreserve. Sample log entries are:

    • server Diagnostics related to error 832 state 1 for spid 47 follow, curcmd=193 (SELECT), xactid=(0,0), plasterror=0, pattention=0, pstat=0x10000, p2stat=0x1000, p3stat=0x800.
       
    • server [0] spid=47, dbid=2, objid=-3080197, indid=0, ptnid=-1, pageno=24, ts=0000 00000000, cacheid=0, buf=0x0x5eec36680, mbuf=0x0x5eec36680, msize=2048 (2K), mstat=80c
       
    • Error: 832, Severity: 20, State: 1
      Unable to place buffer <hex#> holding logical page 24 in sdes for object 'temp worktable' - there is no room in sdes aux keep pool.
  • bufkeep+0x1a8()
    buf__unhash_and_keep_grabbed_mass+0x4d0()
    bufreserve+0xc8()
    sort_bufreserve+0xc9()

    (offsets will vary by platform)


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

"error 832", "message 832", "max buffer", "lava operator", bufkeep , buf__unhash_and_keep_grabbed_mass , bufreserve , sort_bufreserve , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.