SAP Knowledge Base Article - Preview

2996867 - Frequent 'BITMAP ASSERTION REPORT' & 's_bm::SetBits' while loading data to a table -- SAP IQ

Symptom

When loading to same table, 'BITMAP ASSERTION ' & 's_bm::SetBits' error has been produced. DBCC check on existing table always reports 'No error detected'. Therefore it looks the bitmap error is detected at new insertion while verifying Bitmap check step in loading processing.

Following condition is reported after the problem, 
  - Sp_iqcheckdb (allocation and verify modes) reported no error
  - Re-build all indexes on the reported table, but same bitmap error was reported again when trying to loading again
    It caused additional loading failure.

*iqmsg & Stack =>

.. 10500000 Rows, 0 Seconds
.. 10600000 Rows, 1 Seconds
.. BITMAP ASSERTION REPORT slib/s_bm.cxx:5304
.. Internal method: s_bm::SetBits(const hos_recid* list, hos_uint nbits, hos_uint maxnbits, hos_boolean contrflg)
.. this = b899e028
.. list = 7ffedeb0b000
.. nbits = 10485
.. maxnbits = 10485
.. contrflg = 1
.. Check values:
.. endingCount = 10622326
.. startingCount = 10621305
.. startingCount nbits = 10631790
.. ASSERT(endingCount == startingCount + nbits) = FALSE
.. {709} Column EBM RecId Dump (this = d84f70c8, main Bufman uid=58121031, Count = 236321839)
.. BM will be checked for the new range (+/- buffer of recids) : 335543290 - 9474
..
.. ********************************************************
.. **
.. ** Non-Fatal IQ Internal Error Detected
.. ** at /home/iqabuild/views/links/r16.1.0_sp04_nbld_sunx_64/gitsrc/cm/iqa/include/s_bm.h:1047 on thread 715 (TID 709)
.. ** this=7fff7a5311e0,error={num=16,os=0,id=2049,msg=-1006000},bmec=16
...
...** Command text:
load into table ...
...
===== Thread Number 715 (IQ connID: 0001464000) =====
..
.. void StackTraceForThisThread(const char*, ..
.. sbm_exception::sbm_exception(const char*, ..
.. unsigned long long s_bm::FindBit(unsigned ..
.. void s_bm::PrintWithinRecIdRange(unsigned ..
.. void s_dpBitInsert::Insert(const s_ColumnVector*)+ ..
.. void dfiio_FP::FetchOpus()+ ..
.. int dfo_IndexInsert::FetchOpus()+ ..
.. int dfo_Sequencer::FetchOpus()+ ..
.. int dfo_Scheduler::ExecWork(int&, ..
.. void workAllocator::DoWork(unsigned)+ ..
.. int hos_thread::Main()+ ..
.. int hos_lwtask::Start(hos_lwtask*) ..
.. void IQWorkerStarter(void*) ..
.. void*UnixTask::pre_body(void*) ..
.. _fini ..
...
.. Exception Thrown from /home/iqabuild/views/links/r16.1.0_sp04_nbld_sunx_64/gitsrc/cm/iqa/include/s_bm.h:1047, Err# 16, tid 317 origtid 709
.. O/S Err#: 0, ErrID: 2049 (sbm_exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
.. [20238]: IQ Internal error. Please report this to SAP IQ support.
-- (/home/iqabuild/views/links/r16.1.0_sp04_nbld_sunx_64/gitsrc/cm/iqa/include/s_bm.h 1047)
.. Cleaning pending errors from slib/s_bmCur.cxx:972 (tid 317, cursor 0x0)


Read more...

Environment

SAP IQ16.1 SP04.XX

Product

SAP IQ 16.0

Keywords

'BITMAP ASSERTION REPORT' ,  's_bm::SetBits' , 'SetBits' , 's_bm::FindBit' , 's_dpBitInsert::Insert' , , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.