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

• 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'

• SAP IQ (All versions)

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