2035615 - [ SAP IQ16 ] IQ16 crash issue , due to FP index corruption, happened in lower version of IQ16. Key stack : s_TokenCountTable , GetTokenCount

Symptom

A certain customers, who are using low SP level in IQ16, may encounter server crash issue.
This issue can be produced when DB was created in < IQ16 SP4.1.

Stack dump =>

      hos_ABORT() ...
      s_TokenCountTable::GetTokenCount() ...
      dfe_BaseColumn::GetFPLTokenCount() ...
      dfe_BaseColumn::HasOneToOneFPLOrdinalMapping() ...
      ...

When DBA ran check table which was relevant with customer's query, it reported like below.

  sp_iqcheckdb 'check table ...' =>

     ===================   ==============================
     DBCC Verify Mode Report
     ===================   ==============================
     ** DBCC Status                     Errors Detected
     ...
     Index Statistics
     ===================   =============================
     ** Inconsistent Index           xxxx.ASIQ_IDX_T104076_C30_FP
     ** Inconsistent Index           xxxx.ASIQ_IDX_T104076_C36_FP

Environment

Lower version of IQ : IQ16 GA or SP01 ~ SP04.

Product

SAP IQ 16.0

Keywords

s_TokenCountTable , GetTokenCount , "Inconsistent Index" ; , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.