SAP Knowledge Base Article - Preview

3747073 - Internal system error. Could not find key in hashtable - SAP IQ

Symptom

  • The IQ instance stops due to a stack trace during a table load.
  • Error messages observed: ErrID 2059 (s_hashtb_exception); SQLCode: -1009069; SQLState: 'QSA69'; message: "Internal system error. Could not find key in hashtable".
  • Assertion failed: 109801 followed by EngineTerminated.
  • Non-Fatal IQ Internal Error detected messages appear in the logs.
  • Stack trace shows memory/cleanup paths including hos_largememAllocator::ReleaseInflexMem, dfo_ColumnVectorBase, dfo_NonCopyColumnVector, db_dmlcommand::Shutdown.
  • Occurs while running a LOAD TABLE using QUOTES OFF, ESCAPES OFF, FORMAT BINARY, ROW DELIMITED BY '\x0A', with pipe ('|') column mappings.

  • I. 04/18 21:37:19. 0005881123    O/S Err#: 0, ErrID: 2059 (s_hashtb_exception); SQLCode: -1009069, SQLState: 'QSA69', Severity: 14

    I. 04/18 21:37:19. 0005881123 [20090]: Internal system error. Could not find key in hashtable

    I. 04/18 21:37:19. 0005881123  I. 04/18 21:37:19. Exception Thrown from slib/s_hashtb.cxx:405, Err# 1, tid 140514656007936 origtid 140514447574784

    I. 04/18 21:37:19. 0005881123    O/S Err#: 0, ErrID: 2059 (s_hashtb_exception); SQLCode: -1009069, SQLState: 'QSA69', Severity: 14

    I. 04/18 21:37:19. 0005881123 [20090]: Internal system error. Could not find key in hashtable

    I. 04/18 21:37:19. 0005881123  I. 04/18 21:37:19. Exception Thrown from slib/s_hashtb.cxx:405, Err# 1, tid 140514656007936 origtid 140514656007936

    I. 04/18 21:37:19. 0005881123    O/S Err#: 0, ErrID: 2059 (s_hashtb_exception); SQLCode: -1009069, SQLState: 'QSA69', Severity: 14

    I. 04/18 21:37:19. 0005881123 [20090]: Internal system error. Could not find key in hashtable

    I. 04/18 21:37:19. 0005881123   MemID= 2 Status=LM_ALLOC Priority=LM_LOW MemSize= 2608 Counter=0 MemAddr=0x7fcc28000000 Large Memory Inflexible slib/s_dpidx.cxx:6136

    I. 04/18 21:37:19. 0005881123

    I. 04/18 21:37:19. 0005881123     ********************************************************

    I. 04/18 21:37:19. 0005881123     **

    I. 04/18 21:37:19. 0005881123     **       Non-Fatal IQ Internal Error Detected

    I. 04/18 21:37:19. 0005881123     **       at oslib/hos_mem.cxx:2731 on thread 140514656007936 (TIX 12)

    I. 04/18 21:37:19. 0005881123     **

    I. 04/18 21:37:19. 0005881123     **       Please report this to SAP IQ support

    I. 04/18 21:37:19. 0005881123     **       with the following diagnostic information,

    I. 04/18 21:37:19. 0005881123     **       and, if possible, with the user's command.

    I. 04/18 21:37:19. 0005881123     **

    I. 04/18 21:37:19. 0005881123     **  Error from IQ connection:  SA connHandle: 30013  SA connID: 32  IQ connID: 0005881123  User: log_src_1

    I. 04/18 21:37:19. 0005881123     **  Time of error:  2026-04-18 21:37:19

    I. 04/18 21:37:19. 0005881123     **  IQ Version:  SAP IQ/16.1.050/13565/P/SP05.10

    I. 04/18 21:37:19. 0005881123     **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/sybase-iq-logsrc-b-dr1.050516350830.ew1.aws.prod.r53/3.10.0-1160.15.2.el7.x86_64/#1 SMP Thu Jan 21 16:15:07 EST 2021/x86_64

    I. 04/18 21:37:19. 0005881123     **  Command status when error occurred:  CURSOR ACTIVE

    I. 04/18 21:37:19. 0005881123     **  Command text:

    I. 04/18 21:37:19. 0005881123 load into table "log_src_1"."alt_raw_feed_table"( "subject" '|',"timestamp" '|',"packet" '|',"site" '|',"ctf_trade_price" '|',"ctf_current_price" '|',"ctf_official_current_price" '|',"ctf_trade_close" '|',"ctf_trade_official_close" '|',"ctf_official_mid_close" '|',"ctf_settle_price" '|' ) using file '/opt/logsrc2/logsrc-sybase-iq-logsrc-b-dr1.050516350830.ew1.aws.prod.r53/altrawfeed/2026/04/18/21/37/17.done' quotes off escapes off format binary row delimited by '\

    I. 04/18 21:37:19. 0005881123 x0A'

    I. 04/18 21:37:19. 0005881123 ***************** This is the STACKTRACE ***************

    I. 04/18 21:37:19. 0005881123 ===== Thread Number 140514656007936 (IQ connID: 0005881123) =====

    I. 04/18 21:37:19. 0005881123 pc: 0x400e81 backtrace+21

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc193d40d4 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc193d4800 ucstkgentrace(int, int)+190

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc193d5726 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+2c6

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc1935e33a hos_largememAllocator::ReleaseInflexMem(unsigned long long, unsigned long, void*)+4ca

    I. 04/18 21:37:19. 0005881125 [20896]: Insert for 'alert_table' completed in 0 seconds.  51 rows inserted.

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc1964a2df s_ColumnVector::FreeArrays()+bf

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc18fbc606 dfo_ColumnVectorBase::CleanUp()+36

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc18fbcfe5 dfo_ColumnVectorBase::CompleteOpus()+65

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc18e7ae86 dfo::Complete()+176

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc18ef5a5b dfo_Root::CompleteAllDFOsBelowRoot()+9b

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc18f02293 dfo_Root::Complete()+73

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc1a1e9c3e db_dmlcommand::ExecuteDFOTree()+63e

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc1a18825b db_LoadTable::Execute()+ab

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc19f6b3f7 st_command::DoCmdThroughResourceGate()+67

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc19fb4281 st_iqdml::Load(a_statement*, UIConnection*, unsigned int)+61

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc18cb4dfc UIQDML_Load+1c

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc19fbbebb st_SAIQInterfaceInfo::callFunction()+1b

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc1a02269e st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+ce

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc19fbc37b st_SAIQInterface::Execute(int, void*, unsigned int (*)(void*, void*), void*, unsigned int)+36b

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcc193e6c57 saint_iqthresholddml::Load(a_statement*, IConnection*, unsigned int)+57

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcdd68eddf5 dbi_load_table(a_statement*, unsigned int)+625

    I. 04/18 21:37:19. 0005881123 pc: 0x7fcdd69e8826 DoExecuteBodyLocal(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, bool, unsigned int, unsigned short)+eb6


Read more...

Environment

  • 16.1.050.2435/13565/P/SP05.10

Product

SAP IQ all versions

Keywords

stacktrace, could not find key in hashtable, s_hashtb_exception, -1009069, QSA69, assertion 109801, engine terminated, load table, format binary, quotes off, escapes off, row delimited by \x0A, releaseinflexmem, dfo_ColumnVectorBase , 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.