SAP Knowledge Base Article - Preview

2708510 - INSERT constantly fails in s_bm::SetBits - SAP IQ 

Symptom

  • INSERT would fail with a Non-Fatal error on s_bm::SetBits. Bitmap failed internal checks. You may have a damaged index.
  • DBCC returns no error
  • After hitting this error, INSERT would always fail for that table

Excerpt of IQMSG

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at slib/s_bm.cxx:2098 on thread 1187 (TID 1178)
** Bitmap result bitcount not in legal range.
** this=fffffffe58080888,error={num=1,os=0,id=2049,msg=-1009045},bmec=1
**

** Command text:

INSERT INTO T ( "c1", "c2", "c3", ... "cn" ) 
SELECT ("c1", "c2", "c3", ... "cn") FROM TempTable

***************** This is the STACKTRACE ***************

sbm_exception::sbm_exception
void s_bm::SetBits
void dfiio_FP::FetchOpus
int dfo_IndexInsert::FetchOpus
const s_packedRecDesc*CombinerFetchCallback
void hc_dfrun::FillRun
int hc_dmfrun::InitNextWorkUnit
void workAllocator::DoWork
int hos_thread::Main
int hos_lwtask::Start
void IQWorkerStarter
void*UnixTask::pre_body


Exception Thrown from slib/s_bm.cxx:2098, Err# 1, tid 1178 origtid 1178
O/S Err#: 0, ErrID: 2049 (sbm_exception); SQLCode: -1009045, SQLState: 'QSA45', Severity: 14

Bitmap failed internal checks. You may have a damaged index. Please check your IQ message file for additional information.


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

CR817086, CR#817086, 817086,  CR814021, CR#814021, 814021, s_bm::SetBits, "Bitmap result bitcount not in legal range", Bitmap, bitcount, legal, range, Non-Fatal, Cr805776, 805776, -1009045, 2049, damaged, sbm_exception, stacktrace, stktrc , stack trace , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.