SAP Knowledge Base Article - Preview

2003554 - Error during load table or update: Insufficient Buffers for Sort - SAP IQ

Symptom

  • Table Load job fails and error messages similar to the following are seen in the Sybase iqmsg log:

I.. 0000702177 Txn 263805757 0 263805757
I.. 0000702177 Connect: SA connHandle: 178637 SA connID: 19 IQ connID: 0000702177 User: CRR
I.. 0000702177 Exception Thrown from s_csort.cxx:971, Err# 2, tid 4 origtid 4
I.. 0000702177 O/S Err#: 0, ErrID: 2062 (hs_csortexception); SQLCode: -1009134, SQLState: 'QSB34', Severity: 14
I.. 0000702177 [21023]: Insufficient buffers for 'Sort'.
I.. 0000702177 Rbck
I.. 0000702177 PostRbck
I.. 0000702177 Disconnect: SA connHandle: 178637 SA connID: 19 IQ connID: 0000702177 User: username

  • SQL statements or procedure calls doing updates may also run into this error
  • Other buffers may also be insufficient such as:
    • Insufficient buffers for 'update'
    • Insufficient buffers for 'Run'


Read more...

Environment

  • SAP IQ (All versions)

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

memory, "temp cache", "sort buffers", sybase, temporary, abort, failure, IQ16, IQ15, 15.4, crash , KBA , BC-SYB-IQ , Sybase IQ , How To

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.