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.
SAP Knowledge Base Article - Preview