2169727 - Nbit index corrupt, Garray blockmap page link mismatch - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2169727 - Nbit index corrupt, Garray blockmap page link mismatch - SAP IQ

Symptom

  • Query fails without stack trace.  NBit index corrupt on a varchar (20) column.
    The only error message is from sp_iqcheckdb verify on the table.
    This Nbit index was the default index that has existed from the table creation, it has never been flattened.


    Excerpt of sp_iqcheckdb output
    ** Inconsistent Index owner.tabke.ASIQ_IDX_T514751_C416_FP ******

    ** Non-Completed Index owner.tabke..ASIQ_IDX_T514751_C416_FP ******
       FP Indexes Checked 429
    ** FP Lookup Table Inconsistencies 1 ******
       HG Indexes Checked 12
    ** Garray blockmap page link mismatch 1 ******
       DATE Indexes Checked 31


Read more...

Environment

SAP IQ 16

Product

SAP IQ 16.0

Keywords

dbcc , 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.