SAP Knowledge Base Article - Preview

2531559 - Inconsistent DTTM index - SAP IQ

Symptom







    

  • Depending on timestamp values, DTTM index may become inconsistent
    • 

  • Sp_iqcheckdb reports errors below
    • 





** Inconsistent Index,DBA.testdttm.testdttm_a,******


** Extra Index RIDs,70,******


** Missing Index RIDs 70, ******


    

  • There are thousands rows having timestamp value '0001-01-01 00:00:00.000'.
    • 



            

         

           
              Read more...
           
        

      



Environment



   

SAP IQ 16.0 SP11 PL10







Product



  SAP IQ 16.0





Keywords



   
 
CR810618, CR#810618, 810618, Sybase, Extra Index RIDs, Missing Index RIDs, DTTM, Timestamp, DateTime, Inconsistent Index , 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.