SAP Knowledge Base Article - Preview

2762484 - SAP IQ - Insufficient buffers for 'Sort'. -- (slib/s_csort.cxx 2810)

Symptom

Insufficient buffers for 'Sort' error occured frequently during running a user procedure.

After setting "Core_Options13 = 8388608", following informational stacktrace could be found.

--.iqmsg

...
 [21023]: Insufficient buffers for 'Sort'.
...
 s_bufferAlloc @ 0x7f9cf8559878 :
 Bufman: temp Bufman
 Max Buffers: 392437
 Available Buffers: 384221
 Avl. Prefetch Buffers: 154958
 Max Wash Buffers: 78488
 Slot allocations: 14439181
 First available slot: 727
 Total info slots 5000
 Num Pin Users: 2363
 Num Prefetch Users: 304
 Posted User Target: 627
 UnPosted Users: 2305
 Pin User Quota: 133
 Post Estimate Calls: 174709
 UnPost Estimate Calls: 174704
...
 ** Informational stack trace from SORT
 ** at slib/s_csort.cxx:2810 on thread 140302961714944 (TID 1404)
...
 ** IQ Version: SAP IQ/16.0.110/10554/P/sp11.11
...
***************** This is the STACKTRACE ***************
pcstkwalk
ucstkgentrace
StackTraceForThisThread
hs_csort::DumpExceptionForSort
hs_csort::PlanPinnedBuffers
hs_csort::InitializeResources
hs_csort::PrepareToInsert
dfo_GroupByUnordered::PrepareCommon
dfo_GroupByUnordered::PrepareForNextWorkUnit
dfo_cOrderByParaIn::ExecWork
...
 ** End of informational stack trace from SORT


Read more...

Environment

SAP IQ 16.0

SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

"Insufficient buffers"; "CR 814821"; "814821"; "CR#814821"; "CR 795647"; "795647"; "CR#795647"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.