SAP Knowledge Base Article - Preview

2757647 - "All buffer cache pages are in use" error during loads - SAP IQ


Loads to very wide tables work properly, but subsequent loads get the following error:

Exception Thrown from slib/s_blockmap.cxx:5857, Err# 0, tid 3 origtid 718
O/S Err#: 0, ErrID: 2097 (s_nobuffersexception); SQLCode: -1009031, SQLState: 'QSA31', Severity: 14
[20052]: temp Bufman: All buffer cache pages are in use, ask your DBA to increase the size of the buffer cache.
-- (slib/s_blockmap.cxx 5857)



  • SAP IQ 16
  • SAP IQ 16.1


SAP IQ 16.0 ; SAP IQ 16.1


's_blockmap.cxx' , 'Buffer Cache', 818507, , KBA , BC-SYB-IQ , Sybase IQ , 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.