bitmap failed internal checks. you may have a damaged index

[Former Member]

Hi Experts!

I have a problem with certain queries sent to IQ, I get the following error: bitmap failed internal checks. May you have a damaged index.

When i run the stored procedure sp_iqcheckdb 'verify table xxxx' on the tables involved in the query tells me that there are no errors.

Has anyone had a similar error?

I hope you can help me.

[tayeb_hadjou]

Hi Edgae,

Please post your exact IQ version (select @@version).

[Former Member]

Hi HADJOU,

The Version is: SAP IQ/16.0.0.807/140617/P/sp08.01

[jong-kil_park]

Hi Edgae,

If the error messages you encountered are similar with below, please refer to a KBA 207774 - https://i7p.wdf.sap.corp/sap(bD1rbyZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3....

     ...********************************************************                                                                                                                           

     ...**       Non-Fatal IQ Internal Error Detected                                                                 

     ...**       at /cm/iqa/include/s_bm_priv.h:1215  on thread 1196 (TID 1187)                                       

     ...**       Bitmap failed verify checks.                                                                                                      

     ...********************************************************           

      ..v2s_bmcontext..bmselfcpytail ..

      ..v2s_bmcontext .. bmselfsetrngE ...

      ..s_bm..SetBitsEyyi ...

      ..s_bmTSCursor..FlushEv ...

      ..hs_dpInsert..Insert..s_IndexIteratoriiPKc...

      ..hs_dpUpdate..Update... s_IndexIterator_UpdatePageSetiPK ...

      ...

      ...

      Exception Thrown from /cm/iqa/include/s_bm_priv.h:1215, Err# 19, tid 1187 origtid 1187                                                                                  

           O/S Err#: 0, ErrID: 2049 (sbm_exception); SQLCode: -1009045, SQLState: 'QSA45', Severity: 14                                                                         

      [20066]: Bitmap failed internal checks. You may have a damaged index. Please check your IQ message file

           for additional information.  -- (/cm/iqa/include/s_bm_priv.h 1215)

Best Regards

Jerry

[tayeb_hadjou]

Are the impacted queries using same tables ?

Please attach the non-fatal stacktrace generated.

get output of

select * from sp_iqstatus() where lower(name) like '%page size%' ;