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