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
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.
SAP Knowledge Base Article - Preview