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 1.0 dynamic tiering ; SAP HANA dynamic tiering 2.0 ; SAP NetWeaver 7.5

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.