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/hostname001/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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.