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 SP11 PL11

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 ONE Support launchpad (Login required).

Search for additional results

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