Symptom
- 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 - 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
:::
(
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.