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
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.