SAP Knowledge Base Article - Preview

2452208 - Frequent Insufficient buffers for 'Sort' after upgrade from 15.4: IQ

Symptom

Since upgrade the system from IQ 15.4 to IQ 16.0 SP 10 PL 10

IQ full cmd line: -n gmfeprod -cl 9600m -ch 10200m -gc 20 -gd all -gl all -gm 30 -gn 50 -ti 28800 -tl 28800 -iqmc 160000 -iqtc 160000 -iqlm 160000 -sb 0 -iqmsgsz 150 -iqmsgnum 20 -iqtss 2500 -iqgovern 84 -iqmt 3072 -x tcpip{port=2640} -p 4096 -zr SQL -zs 150M -zo /prod_server/db/iq/gmfeprodsql.log -ze gmfeprod.db -gp 4096 -o /prod_server/iq/iq_16_11_05/IQ-16_0/logfiles/gmfeprod.0017.srvlog -hn 5

********************************************************
***************** This is the STACKTRACE ***************

pcstkwalk(stk_trace*, int, db_log*, hos_fd*)
ucstkgentrace(int, int)
StackTraceForThisThread(char const*, int, char const*, char const*, char const*)
hc_dmfrun::CheckException()
hc_dmfrun::SelectInputRun_WithTryCatch()
hc_dmfrun::AdvanceBuffer()
dfo_Combiner::FetchOpus()
dfo_Sequencer::FetchOpus()
dfo_Root::FetchOpus()
dfo::Fetch()
db_dmlcommand::ExecuteDFOTree()
db_InsertRoot::Execute()
st_command::DoCmdThroughResourceGate()
st_iqdml::Insert(a_statement*, UIConnection*, UICursor*, unsigned int*)+0xcaUIQDML_Insert
st_SAIQInterfaceInfo::callFunction()
st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)
st_SAIQInterface::Execute(int, void*, unsigned int (*)
saint_iqthresholddml::Insert(a_statement*, IConnection*, ICursor*, unsigned int*)
dbi_insert(Connection*, a_statement*, a_stmt*, a_stmt_identifier*, unsigned int, unsigned int, TableDef*)
DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int)
exec_procedure_stmt(Connection*, a_context_ref*, a_statement*, unsigned int, unsigned int)
run_procedure(a_context_ref*, dfm_CallInfo*, unsigned int, Connection*, unsigned int)
call_procedure(Connection*, a_proc_def*, a_trigger_def*, a_base_expr*, a_procedure_arg*, unsigned int, a_db_cursor*, bool)
dbi_callprocedure(Connection*, a_call*, bool, unsigned int)
DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int)
db__execute(Connection*, an_sqlpres_receive*)
RequestProcedure::call()
Context::call(Procedure*, Context**)
Worker::call_on_stack(Procedure*)
TopProcedure::call()
Worker::spawn(Procedure*)
EngStream::handle_ind(unsigned char, unsigned int)
EngStream::execute()
RQBaseItem::do_work(Worker*)
RequestQueue::worker_body()
request_task(void*)
run_task_body
UnixTask::pre_body(void*)
******************* End of STACKTRACE ******************
********************************************************

Exception Thrown from slib/s_csort.cxx:2810, Err# 2, tid 13 origtid 1737
O/S Err#: 0, ErrID: 2062 (hs_csortexception); SQLCode: -1009134, SQLState: 'QSB34', Severity: 14
Insufficient buffers for 'Sort'.
-- (slib/s_csort.cxx 2810)


Read more...

Environment

SAP IQ 16.0 SP11

Product

SAP IQ 16.0

Keywords

s_csort, Insufficient buffers for 'Sort', hs_csortexception, SQLCode: -1009134 , 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.