Symptom
- When loading data via an INSERT … SELECT statement, the query execution fails and produces the following stack trace while an NBit FP index is being rolled over to a Flat FP index.
[.iqmsg file]
0x7ff6458dd248 Debug: Checking FP index before rollover
Table: TableA
Column: Column17
Index: dba.TableA.ASIQ_IDX_T1710_C17_FP
** Non-Fatal IQ Internal Error Detected
** at slib/s_bm.cxx:1470 on thread 140712792290880 (TIX 1771)
** Bitmap result bitcount not in legal range.
** this=0x7ffa3fffcf10,error={num=1,os=0,id=2049,msg=-1009045},bmec=1***************** This is the STACKTRACE ***************
===== Thread Number 140712792290880 (IQ connID: 0000000026) =====
pc: 0x400e81 backtrace+21
pc: 0x7ff608b020d4 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34
pc: 0x7ff608b02800 ucstkgentrace(int, int)+190
pc: 0x7ff608b03726 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+2c6
pc: 0x7ff608c12bec sbm_exception::sbm_exception(char const*, unsigned int, sbm_exception::bmerrors)+43c
pc: 0x7ff608c27e37 s_bm::SetBits(unsigned long long, unsigned long long, int)+6c7
pc: 0x7ff609663f19 s_RidMapCursor::RemoveNBitPagesForRollover(s_bm*, s_bm*, s_mergeFINALWriter*)+319
pc: 0x7ff608bacf32 s_mergeFINALWriter::PrepareForRollover(s_bm*)+a2
pc: 0x7ff608daa125 hs_dpInsert::Rollover()+1d5
pc: 0x7ff608717de5 df_FPRolloverIterator::ExecWork(int&, unsigned int)+135
pc: 0x7ff608ad7b14 workAllocator::DoWork(unsigned int)+c4
pc: 0x7ff608af6653 hos_team::StartWork(void (*)(void*, void*), void*)+83
pc: 0x7ff608ad7551 hos_team::Exec(hos_workIter&)+41
pc: 0x7ff608710da2 dfiio_FP::RolloverIfNeeded()+1d2
pc: 0x7ff608716630 dfiio_FP::PostFetchOpus()+1b0
pc: 0x7ff60871618a dfo_IndexInsert::PostFetchOpus()+9a
pc: 0x7ff6085a2961 df_CombinerFinalFetchHelper::ExecWork(int&, unsigned int)+be1
pc: 0x7ff608ad7b14 workAllocator::DoWork(unsigned int)+c4
pc: 0x7ff608af7759 hos_thread::Main()+209
pc: 0x7ff608a6aaf9 hos_lwtask::Start(hos_lwtask*)+69
pc: 0x7ffff6d576de IQWorkerStarter(void*)+3e
pc: 0x7ffff746e91e run_task_body+1e
pc: 0x7ffff70282d8 UnixTask::pre_body(void*)+78
pc: 0x7ffff628b2ea <unknown>
pc: 0x7ffff63103d0 <unknown>
******************* End of STACKTRACE ******************
**
** End of stack trace from Non-Fatal IQ Internal Error slib/s_bm.cxx:1470
**
******************************************************** - sp_iqcheckdb 'verify table <table_name>' doesn't report an error message.
Read more...
Environment
- SAP IQ 16.1
Product
Keywords
bitmap failed internal checks, nbit rollover, FP index, flat style FP, ETL_LAST_UPDATED_TIME, Sybase IQ, SQLCODE=-1009045, QSA45, index rebuild, sp_iqrebuildindex, sp_iqcolumnmetadata, insertion error, rollover error. , 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