SAP Knowledge Base Article - Preview

2092150 - sp_iqcheckdb 'verify database' (DBCC) error messages Related to Extra/missing/Duplicate Index RIDs.

Symptom

Sometimes sp_iqcheckdb 'verify database' can list the following error related to Extra/missing/Duplicate Index RIDs:

** Extra Index RIDs 57    
If all inconsistent indexes in DBCC report were fixed and an error does not show anymore, than it has been fixed also. But, when all other errors listed in sp_iqcheckdb report have been fixed and DBCC 'verify database' does not show any other errors, but it becomes more difficult to figure out which object(s) row ID list has a mismatch.
** Extra Index RIDs
 ==================================================    ==============================
 DBCC Verify Mode Report                                                            
 ==================================================    ==============================
 ** DBCC Status                                        Errors Detected                                                                                              
 ==================================================    ==============================
 Index Summary                                                                      
 ==================================================    ==============================
    Verified Index Count                               8910                                                                                  <-------   No errors                                                                                  
 ==================================================    ==============================
 Allocation Summary                                                                
  Verified Index                                     xxxxxxxxxxxxxxxxxxxxx.ASIQ_IDX_T776_C4_FP
  Verified Index                                     xxxxxxxxxxxxxxxxxxxxx.adCreativeCode_HG 
....................................
....................................
    Verified Index                                     xxxxxxxxx.ASIQ_IDX_T1361_C13_FP
    Verified Index                                     xxxxxxxxx.ASIQ_IDX_T1361_C17_FP
    Verified Index                                     xxxxxxxxx.ASIQ_IDX_T1361_C20_FP
    Verified Index                                     xxxxxxxxx.ASIQ_IDX_T1361_C24_FP
 ** Extra Index RIDs                                   57  
    FP Indexes Checked                                 5932
    HNG Indexes Checked                                103 
    LF Indexes Checked                                 963 
    HG Indexes Checked                                 1470
    WD Index Count                                     44  
    DATE Indexes Checked                               190 
    TIME Indexes Checked                               10  
    DTTM Indexes Checked                               198                                                            
 ==================================================    ==============================
 Container Statistics                                                               
 ==================================================    ==============================
.......................
.......................


Read more...

Environment

  • SAP IQ 15.x
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

Keywords

Missing Index RIDs, Duplicate Index RIDs, row ID, RID, Extra Index RIDs , 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.