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; sp_iqcheckdb ; CR#783283; CR783283; 783283 ; corruption, Nbit ; , 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.