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.