SAP Knowledge Base Article - Preview

2278361 - Insufficient buffers for 'Sort' error

Symptom

Sessions running load table and select...into statement got aborted with "Insufficient buffers for 'Sort'" error.

[Stacktrace from the Load table session]
_ZN8hs_csort12AddRetrieverEj + 0x9a0 at slib/s_csort.cxx:.......
_ZN8hs_csort12GetRetrieverEj + 0x320 at slib/s_csort.cxx:.......
_ZN20dfo_DMLSortRetriever23AllocateShadowResourcesEv + 0x150 at dflib/dfo_DMLSortRetriever.cxx:.......
_ZN3dfo34RecursivelyAllocateShadowResourcesEv + 0x80 at dflib/dfo.cxx:.......
_ZN27df_CombinerFinalFetchHelper8ExecWorkERij + 0x8c0 at dflib/dfo_Combiner.cxx:.......
_ZN13workAllocator6DoWorkEj + 0x1d0 at oslib/hos_team.cxx:.......
...........
...........   
Exception Thrown from slib/s_csort.cxx:1381, Err# 2, tid 81 origtid 81
   O/S Err#: 0, ErrID: 2062 (hs_csortexception); SQLCode: -1009134, SQLState: 'QSB34', Severity: 14   
[21023]: Insufficient buffers for 'Sort'.
  
 
[Stacktrace from the Select...Insert session]
_ZN8hs_csort20DumpExceptionForSortEv + 0x170 at slib/s_csort.cxx:.......
_ZN8hs_csort17PlanPinnedBuffersEy + 0x2c0 at slib/s_csort.cxx:.......
_ZN8hs_csort19InitializeResourcesEi + 0x3b0 at slib/s_csort.cxx:.......
_ZN8hs_csort15PrepareToInsertEjPPK14hos_datumValueS3_iiij + 0xb10 at slib/s_csort.cxx:.......
_ZN12dfo_cOrderBy15PrefetchAndSortEv + 0x310 at dflib/dfo_cOrderBy.cxx:.......
_ZN12dfo_cOrderBy9FetchOpusEv + 0x2f0 at dflib/dfo_cOrderBy.cxx:.......
_ZN14dfjo_MergeBase10FirstFetchEv + 0x990 at /cm/iqa/include/dfo.h:.......
_ZN26dfjo_MergeRightKeyedOuters9FetchOpusEv + .......
_ZN8dfo_Join9FetchOpusEv + 0x50 at dflib/dfo_Join.cxx:.......
...........
...........   
Exception Thrown from slib/s_csort.cxx:1381, Err# 2, tid 1514 origtid 1514
   O/S Err#: 0, ErrID: 2062 (hs_csortexception); SQLCode: -1009134, SQLState: 'QSB34', Severity: 14
[21023]: Insufficient buffers for 'Sort'.


Read more...

Environment

SAP IQ 16.0 SP10.08
HP-UXi 11.31
Multiplex

Product

SAP IQ 16.0

Keywords

SAP IQ, insufficient buffers for sort, slib/s_csort, hs_csortexception , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.