SAP Knowledge Base Article - Preview

2799782 - Error: "s_llhtable.cxx:1882 deleting non-existing key" and "NBit Internal Error on a table: a column missing key for token llhtable ..." --SAP IQ16.1 SP2.14,

Symptom

An Update query met Non-Fatal errors 's_llhtable.cxx:1882' & 's_dpNBit.cxx:1542'.  It looks to encounter missing token key llh table during Nbit update.

*iqmsg >>

I. 05/20 07:13:35. 0000278200 Txn 256229808 0 256229808
I. 05/20 07:13:35. 0000278200 slib/s_llhtable.cxx:1882 deleting non-existing key [63725555569665234,228]
I. 05/20 07:13:35. 0000278200 NBit Internal Error table: AudioTranscript column: HTMLTextAudit_Time missing datetime key for token llhtable count= 240 nonzero token: 239
..
.. ********************************************************
.. **
.. ** Non-Fatal IQ Internal Error Detected
.. ** at slib/s_dpNBit.cxx:1542 on thread 140635818424064 (TID 113)
.. **
..
.. ** Error from IQ connection: SA connHandle: 94842 SA connID: 63 IQ connID: 0000278200 User: data_loader
.. ** Time of error: 2019-05-20 07:13:35
.. ** IQ Version: SAP IQ/16.1.020/12305/P/sp02.14
.. ** OS info: IQ built on: Linux/Linux64 - x86_64 - 2.6.18-194, Executed on: Linux/sinvsyd020v1.dinvsyd.local/3.10.0-693.17.1.el7.x86_64/#1 SMP Sun Jan 14 10:36:03 EST 2018/x86_64
.. ** Command status when error occured: CURSOR ACTIVE
.. ** Command text:
update "AudioXXX" set "Status" = 'PROCESSED|LP3_STAGED' where "ItemID" = '20190516085019' and "Status" = 'PROCESSED'
...

===== Thread Number 140635818424064 (IQ connID: 0000278200) =====
..
.. StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x341
.. hs_ThrowIdxException(char const*, ...
.. verifyToken(s_llhtable*, hs_dp*) ..
.. s_dictionary::ConstructFixedKey(s_llhtable*, hs_dp*) ..
.. s_dictionary::ConstructDictionary(s_llhtable*, ..
.. s_dpNBit::UpdateTokenInfo(int)+0xda
.. hs_dpInsert::Complete()+0x1ff
.. hs_dpUpdate::CompletePartialInsert()+0x6a
.. hs_dpUpdate::Complete()+0x144
.. db_UpdateCompleteIterator::CompleteIndex(s_indexUpdate*) ..
.. db_UpdateCompleteIterator::ExecWork( ..
.. workAllocator::DoWork(unsigned int) ..
.. hos_team::StartWork(void (*)+0xd6
.. hos_team::Exec(hos_workIter&)+0x41
.. db_sqlinsert::UpdateComplete()+0x18a
.. db_sqlinsert::UpdateExecute()+0x2cc
.. db_sqlinsert::Execute()+0x1cd
.. st_command::DoCmdThroughResourceGate()+0x90
.. st_iqdml::Update(a_statement*, UIConnection*, UICursor*)+0x128
.. UIQDML_Update+0x1d
.. st_SAIQInterfaceInfo::callFunction()+0x26
...
...
.. ******************* End of STACKTRACE ******************
.. **
.. ** End of stack trace from Non-Fatal IQ Internal Error slib/s_dpNBit.cxx:1542
.. **


Read more...

Environment

SAP IQ16.1 SP02.14

Product

SAP IQ 16.1

Keywords

s_llhtable , "missing key" , "s_dpNBit::UpdateTokenInfo" , UpdateTokenInfo, ConstructFixedKey, verifyToken , , 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.