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

Search for additional results

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