3792595 - During an Insert (or update) process customer index get FP corrupted - SAP IQ

• During an Insert (or update) process customer index get FP corrupted.
• Following stacktrace ir observed:

I. 08/11 23:19:23. 0000039253 t140440899499776 *** CDR.FCT_FIN_TOD_DTLS.ASIQ_IDX_T255193_C18_FP CURRENT_FLAG (varchar): token count mismatch between column EBM (4300378148) and count table (5410852).

I. 08/11 23:19:23. 0000039253 s_Dictionary Dump Token varchar Keys, keySize=8, maxToken=0

I. 08/11 23:19:23. 0000039253 t140440899499776:  token=0 Len= 1 Key=N

I. 08/11 23:19:23. 0000039253 s_Dictionary offset tab maxtoken= 0

I. 08/11 23:19:23. 0000039253 t140440899499776:   token=0 offset=0

I. 08/11 23:19:23. 0000039253 s_TokenTable Dump Token Counter, maxToken=0

I. 08/11 23:19:23. 0000039253 t140440899499776:   token=0 count=5410852

I. 08/11 23:19:23. 0000039253 _hashTab->_gToken,_numUnusedTokens,_scale,MemId=1,0,0,0

I. 08/11 23:19:23. 0000039253 slib/s_llhtable.cxx:3450 datatype varchar not supported yet.

I. 08/11 23:19:23. 0000039253    

I. 08/11 23:19:23. 0000039253     ********************************************************

I. 08/11 23:19:23. 0000039253     **

I. 08/11 23:19:23. 0000039253     **       Non-Fatal IQ Internal Error Detected

I. 08/11 23:19:23. 0000039253     **       at slib/s_dpidx.cxx:7767 on thread 140440899499776 (TIX 3)

I. 08/11 23:19:23. 0000039253     **

I. 08/11 23:19:23. 0000039253     **       Please report this to SAP IQ support

I. 08/11 23:19:23. 0000039253     **       with the following diagnostic information,

I. 08/11 23:19:23. 0000039253     **       and, if possible, with the user's command.

I. 08/11 23:19:23. 0000039253     **

I. 08/11 23:19:23. 0000039253     **  Error from IQ connection:  SA connHandle: 2522  SA connID: 12  IQ connID: 0000039253  User: DBA

I. 08/11 23:19:23. 0000039253     **  Time of error:  2026-08-11 23:19:23

I. 08/11 23:19:23. 0000039253     **  IQ Version:  SAP IQ/16.1.050/13565/P/SP05.10

I. 08/11 23:19:23. 0000039253     **  OS info:  IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327,  Executed on: Linux/kbprphld00414/4.18.0-553.150.1.el8_10.x86_64/#1 SMP Wed Jul 29 03:01:18 EDT 2026/x86_64

I. 08/11 23:19:23. 0000039253     **  Command status when error occurred:  CURSOR ACTIVE

I. 08/11 23:19:23. 0000039253     **  Command text: 

I. 08/11 23:19:23. 0000039253 call "CDR"."SP_DIM_LASONE_KEY_LOAD"('2026-08-10')

I. 08/11 23:19:23. 0000039253 ***************** This is the STACKTRACE ***************

I. 08/11 23:19:23. 0000039253 ===== Thread Number 140440899499776 (IQ connID: 0000039253) =====

I. 08/11 23:19:23. 0000039253 pc: 0x400e81 backtrace+21

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54b140d4 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54b14800 ucstkgentrace(int, int)+190

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54b15726 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+2c6

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54d97433 hs_dp::CheckIndexConsistency(int)+2d23

I. 08/11 23:19:23. 0000039253 pc: 0x7fba552c4f1b hs_dpUpdate::Complete()+14b

I. 08/11 23:19:23. 0000039253 pc: 0x7fba55924b9c db_UpdateCompleteIterator::CompleteIndex(s_indexUpdate*)+1c

I. 08/11 23:19:23. 0000039253 pc: 0x7fba558dcb9e db_UpdateCompleteIterator::ExecWork(int&, unsigned int)+de

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54ae9b14 workAllocator::DoWork(unsigned int)+c4

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54b08653 hos_team::StartWork(void (*)(void*, void*), void*)+83

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54ae9551 hos_team::Exec(hos_workIter&)+41

I. 08/11 23:19:23. 0000039253 pc: 0x7fba558dd66b db_sqlinsert::UpdateComplete()+22b

I. 08/11 23:19:23. 0000039253 pc: 0x7fba558debfb db_sqlinsert::UpdateExecute()+36b

I. 08/11 23:19:23. 0000039253 pc: 0x7fba558d2fd6 db_sqlinsert::Execute()+86

I. 08/11 23:19:23. 0000039253 pc: 0x7fba556ab3f7 st_command::DoCmdThroughResourceGate()+67

I. 08/11 23:19:23. 0000039253 pc: 0x7fba556f3b56 st_iqdml::Update(a_statement*, UIConnection*, UICursor*)+96

I. 08/11 23:19:23. 0000039253 pc: 0x7fba543f4e8d UIQDML_Update+1d

I. 08/11 23:19:23. 0000039253 pc: 0x7fba556fbebb st_SAIQInterfaceInfo::callFunction()+1b

I. 08/11 23:19:23. 0000039253 pc: 0x7fba5576269e st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+ce

I. 08/11 23:19:23. 0000039253 pc: 0x7fba556fc37b st_SAIQInterface::Execute(int, void*, unsigned int (*)(void*, void*), void*, unsigned int)+36b

I. 08/11 23:19:23. 0000039253 pc: 0x7fba54b26d18 saint_iqthresholddml::Update(a_statement*, IConnection*, ICursor*)+58

I. 08/11 23:19:23. 0000039253 pc: 0x7fc454681fb8 dbi_update(Connection*, a_statement*, a_stmt*, a_stmt_identifier*, unsigned int)+78

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547c85b0 DoExecuteBodyLocal(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, bool, unsigned int, unsigned short)+1c40

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547c92a5 DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int, unsigned int)+c75

I. 08/11 23:19:23. 0000039253 pc: 0x7fc454709603 exec_procedure_stmt(Connection*, a_context_ref*, a_statement*, unsigned int, unsigned int)+1b03

I. 08/11 23:19:23. 0000039253 pc: 0x7fc45470bb80 run_procedure(a_context_ref*, dfm_CallInfo*, unsigned int, Connection*, unsigned int)+310

I. 08/11 23:19:23. 0000039253 pc: 0x7fc45470d077 call_procedure(Connection*, a_proc_def*, a_trigger_def*, a_base_expr*, a_procedure_arg*, unsigned int, a_db_cursor*, bool, a_statement*, a_call*)+117

I. 08/11 23:19:23. 0000039253 pc: 0x7fc45470ee05 dbi_callprocedure(Connection*, a_call*, bool, unsigned int)+1b5

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547c7c05 DoExecuteBodyLocal(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, bool, unsigned int, unsigned short)+1295

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547c92a5 DoExecuteStmt(Connection*, a_stmt*, a_statement*, a_stmt_identifier*, unsigned short, unsigned int, unsigned int)+c75

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547ca8ba db__execute(Connection*, an_sqlpres_receive*)+11a

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547e0d96 RequestProcedure::call()+f06

I. 08/11 23:19:23. 0000039253 pc: 0x7fc454585fb1 Worker::spawn(Procedure*)+31

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547e4be6 EngStream::handle_ind(unsigned char, unsigned int)+156

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547e671f EngStream::execute()+7ff

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547e689d RQConnItem::do_request()+d

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547de68e RQBaseItem::do_work(Worker*)+1e

I. 08/11 23:19:23. 0000039253 pc: 0x7fc454822677 RequestQueue::worker_body()+77

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4547dfa49 request_task(void*)+89

I. 08/11 23:19:23. 0000039253 pc: 0x7fc454c6a91e run_task_body+1e

I. 08/11 23:19:23. 0000039253 pc: 0x7fc4548242d8 UnixTask::pre_body(void*)+78

I. 08/11 23:19:23. 0000039253 pc: 0x7fc453fe41ca <unknown>

I. 08/11 23:19:23. 0000039253 pc: 0x7fc453324953 clone+43

I. 08/11 23:19:23. 0000039253 ******************* End of STACKTRACE ******************

I. 08/11 23:19:23. 0000039253     **

I. 08/11 23:19:23. 0000039253     **       End of stack trace from Non-Fatal IQ Internal Error slib/s_dpidx.cxx:7768

I. 08/11 23:19:23. 0000039253     **

I. 08/11 23:19:23. 0000039253     ********************************************************

I. 08/11 23:19:23. 0000039253    

I. 08/11 23:19:23. 0000039253  I. 08/11 23:19:23. Exception Thrown from slib/s_dpidx.cxx:7768, Err# 16, tid 140440899499776 origtid 140440899499776

I. 08/11 23:19:23. 0000039253    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23

I. 08/11 23:19:23. 0000039253 [20238]: IQ Internal error. Please report this to SAP IQ support.

-- (slib/s_dpidx.cxx 7768)

I. 08/11 23:19:23. 0000039253  I. 08/11 23:19:23. Exception Thrown from slib/s_dpidx.cxx:7768, Err# 16, tid 140440899499776 origtid 140440899499776

I. 08/11 23:19:23. 0000039253    O/S Err#: 0, ErrID: 2068 (hs_idxexception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23

I. 08/11 23:19:23. 0000039253 [20238]: IQ Internal error. Please report this to SAP IQ support.

-- (slib/s_dpidx.cxx 7768)

• So far issue was observed against versions below:
• IQ Version:  SAP IQ/16.1.050/13565/P/SP05.10
• IQ Version: SAP IQ/16.1.050/16610/P/SP05.16

internal error 10047, hs_idxexception, token count mismatch, CheckIndexConsistency, slib/s_dpidx.cxx, fp index, index corruption, sp_iqcheckfpconsistency, sp_iqcheckdb, sp_iqrebuildindex, SQLCode -100600, SQLState QBA004, s_readexception, QSA44, multiplex , KBA , BC-SYB-IQ , Sybase IQ , Problem