3234593 - Error while creating M_EXPENSIVE_STATEMENTS from traces in memory

When you execute "HANA_SQL_StatementHash_DataCollector_<version info>+.txt",
"HANA_Configuration_MiniChecks_<version info>+.txt",
"HANA_SQL_ExpensiveStatements_<version_info>+.txt" and so on.
As long as selecting from view M_EXPENSIVE_STATEMENTS, it will fail with "Error while creating M_EXPENSIVE_STATEMENTS from traces in memory". 

In HANA trace files (Like indexserver, xsengine), you will find error like below.
<service>_<host>.<port>.<num>.trc:
===========================
[15793]\{301018\}[6/-1] 2022-08-10 16:25:45.971658 e ExpensiveStateme ExpensiveStatementsMonitor.cc(00932) : Could not create trace records in memory: line=142, lineRequested=9223372036854775807, error=exception  1: no.1000013  (Expression/Wrapper/DateTime.h:222) TID: 15793
    error in DATE/TIME conversion
exception throw location:
 1: 0x00007f85c360536a in TrexTypes::LongdateAttributeValue expr::types::Convert<TrexTypes::LongdateAttributeValue>(UnifiedTable::DateRepresentation const&) [clone .part.0] [clone .lto_priv.0]+0x25 at Exception.h:28 (libhdbrskernel.so)
 2: 0x00007f85c381a385 in TrexTypes::LongdateAttributeValue expr::types::Convert<TrexTypes::LongdateAttributeValue, unsigned long>(unsigned long) [clone .cold]+0x1 at LicensePluginRegistry.cpp:45 (libhdbrskernel.so)
 3: 0x00007f85c239f0d5 in ptime::ExpensiveStatementsMonitor::create_objects_ringBuffer(ptime::Monitor::ListEntry*, ptime::mo_Env*, ptime::fastvector<ptime::Monitor::PredicateInfo, 16ul> const*, ptime::Monitor::LimitInfo const*)+0xd01 at ExpensiveStatementsMonitor.cc:866 (libhdbrskernel.so)
 4: 0x00007f85c23a34be in ptime::ExpensiveStatementsMonitor::create_objects(ptime::Monitor::ListEntry*, ptime::mo_Env*, ptime::fastvector<ptime::Monitor::PredicateInfo, 16ul> const*, ptime::Monitor::LimitInfo const*)+0x3a at ExpensiveStatementsMonitor.cc:261 (libhdbrskernel.so)
 5: 0x00007f85c1c7e65f in ptime::Monitor_search::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x2cb at qe_monitor_search.cc:174 (libhdbrskernel.so)
 ...........
 ...........
===========================

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

 

• SAP HANA Platform Edition 1.0
• SAP HANA Platform Edition 2.0

M_EXPENSIVE_STATEMENTS,  error in DATE/TIME conversion, exception  1: no.1000013 , KBA , HAN-DB , SAP HANA Database , Problem