SAP Knowledge Base Article - Preview

2710136 - Querying table with data in SAP Dynamic Tiering results in "Search result size limit exceeded"

Symptom

Executing a query with data in HANA and SAP Dynamic Tiering results in following error thrown in HANA

SAP DBTech JDBC: [686]: start task error: column store error: [2617] caught unexpected error code 10001001: exception 1: no.10001001 (ims_search_api/Search/Utils.cpp:197)
Search result size limit exceeded: 56769533165
exception throw location:
1: 0x00007f5e46cb9f7f in TRexAPI::Search::ResultBuilderContext::materializeItab(TRexAPI::Search::TableHandleProxy const&, TRexCommonObjects::MdVBV const&, ltt::vector<TrexBase::IndexName> const&, unsigned int)+0x5db at Utils.cpp:196 (libhdbcsapi.so)
2: 0x00007f5e46c6fa77 in TRexAPI::PartSearchImpl::doSearch(Execution::Context&, TRexAPI::PreparedQuery const&, TRexAPI::QueryRuntime&, ltt::array<TRexAPI::Search::PartIx> const&, ltt::smartptr_handle<TRexCommonObjects::InternalTableBase>&)+0xc03 at PartSearchImpl.cpp:591 (libhdbcsapi.so)
...


Read more...

Environment

  • SAP HANA Dynamic Tiering 2.0 Revision 024.05
  • Linux on X86_64 64bit

Product

SAP HANA dynamic tiering 2.0

Keywords

DYT , DT , HANA , FlowGraph , KBA , HAN-DYT , SAP HANA Dynamic Tiering , 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.