SAP Knowledge Base Article - Preview

2192748 - All IQ large memory has been used while running a load table - SAP IQ

Symptom

  • When loading jobs are running, the following error message maybe reported in iqmsg file: 
    • Exception Thrown from slib/s_llhtable.cxx:256, Err# 13, tid 65 origtid 65
      O/S Err#: 0, ErrID: 517 (hos_memexception); SQLCode: -1013130, SQLState: 'QBC75', Severity: 14
      All IQ large memory has been used, allocation canceled [size: 134217791]
      Exception Thrown from slib/s_llhtable.cxx:295, Err# 13, tid 65 origtid 65
      O/S Err#: 0, ErrID: 517 (hos_memexception); SQLCode: -1013130, SQLState: 'QBC75', Severity: 14
      All IQ large memory has been used, allocation canceled [size: 2323860]
    • Exception Thrown from dflib/dfo_ColumnVector.cxx:242, Err# 1058, tid 14 origtid 14
      O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1001047, SQLState: 'QFA43', Severity: 14
      [20556]: Ran out of IQ large memory (-iqlm) .

    • ********************************************************
      **
      ** Informational stack trace from out of virtual memory condition
      ** at GLOBAL NEW:0 on thread 140688041473792 (TID 14)
      ** with Query_Name: slowtest
      ** Failed allocation request (bytes): 29
      ** Failed allocation request type:
      **
      ** Error from IQ connection: SA connHandle: 280939 SA connID: 19 IQ connID: 0000546598 User: user
      I** Time of error: 2020-10-11 18:42:23
      ** IQ Version: SAP IQ/16.0.110/11876/P/sp11.22
      ** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/shrbdbs011/2.6.32-754.30.2.el6.x86_64/#1 SMP Fri May 29 04:45:43 EDT 2020/x86_64
      dlopen libsymtbl16.so failed: cannot create shared object descriptor

  • Increasing -iqlm may not improve the issue.


Read more...

Environment

  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

 CR 786834,dlopen libsymtbl16.so failed: cannot create shared object descriptor , 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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.