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 ONE Support launchpad (Login required).

Search for additional results

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