SAP Knowledge Base Article - Preview

3514803 - Error "IndexDSValue(): for<table_name>(<column_name>)[0]" reoccurring every interval in indexserver trace

Symptom

  1. Indexserver.trc shows repeated error "IndexDSValue()" from various tables and columns every certain interval, but all from component datastatisticsad of source file DSValue.cpp, e.g.

    2024-06-20 03:45:39.934741 e datastatisticsad DSValue.cpp(00938) : IndexDSValue(): forVARI(MANDT)[0]: { "theRequestedData" : "0011000000", "theCollectedData" : "0011000000", 
    "theTypeDefinition" : "unknown0.0.0", 
    "theCount" : 0, 
    "theDistinctCount" : 0, 
    "theNullCount" : 0
    , "theImplementationFlagsMain" : 1048593
    , "theImplementationFlagsDelta" : 17
    }
    size 1 set 0
    :::
    2024-06-20 04:57:40.373557 e datastatisticsad DSValue.cpp(00938) : IndexDSValue(): forBUFF_PRELOAD_SAV(TEST_MODE)[0]: { "theRequestedData" : "0011000000", "theCollectedData" : "0011000000", 
    "theTypeDefinition" : "unknown0.0.0", 
    "theCount" : 0, 
    "theDistinctCount" : 0, 
    "theNullCount" : 0
    , "theImplementationFlagsMain" : 17
    , "theImplementationFlagsDelta" : 17
    }
    size 1 set 0

  2. Upon check of INI configuration, find both indexserver.ini [cache] datastatistics_adviser and datastatisticsadvisercache_enabled are set to true, e.g.

    --- indexserver.ini
    [cache]
    datastatistics_adviser = true
    datastatisticsadvisercache_enabled = true
    datastatisticsadvisercache_clear_reconfig = false
    cs_statistics_cache_invalidation_by_shrinking_tables = false
    :::


()[0]" reoccurring every interval in indexserver trace"> Read more...

Environment

  • SAP HANA, platform edition 1.0
  • SAP HANA, platform edition 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

IndexDSValue, datastatisticsad, datastatistics_adviser, datastatisticsadvisercache_enabled, Data Statistics Advisor , KBA , HAN-DB , SAP HANA Database , 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.