SAP Knowledge Base Article - Preview

3725277 - Bitmap result bitcount not in legal range error during Nbit rollover - SAP IQ

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

SAP IQ 16.1

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.