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.
SAP Knowledge Base Article - Preview