SAP Knowledge Base Article - Preview

2803209 - Client copy failed with error "Search result size limit exceeded"

Symptom

The client copy from client 100 to 200 finished with error, with Table_1 having issues during read or select statements. 

1. indexserver
===
...
EppConnectionId=5CD2FF09EC4C88ABE10000000A616D3D, EppConnectionCounter=1, EppComponentName=QE8/gsqe82vr_QE8_31, EppAction=CLIENTCOPY 100 -> 200 (SAP_UCSV), StatementExecutionID=844438015185667

[121986]{305675}[81/-1] 2019-06-05 01:56:51.105948 e EmbeddedAPI Statement.cc(05289) : unhandled ltt exception was caught: conn_id=305675, stmt_id=1312864622547199, stmt_hash=cf0ec191bde7ae513acad8611533cea9, error=Search result size limit exceeded: $rs$, sql=SELECT * FROM "Table_1" WHERE "MANDT" = ? AND "BUKRS" > ? ORDER BY "MANDT" , "BUKRS" , "KEYPP" , "SRCDOC_COMP" , "SRCDOC_LOGSYS" , "SRCDOC_TYPE" , "SRCDOC_ID" , "TIMESTAMP_UTC" , "POB_ID"
[121986]{305675}[-1/-1] 2019-06-05 01:56:51.106184 e EmbeddedAPI Connection.cc(02095) : internal error: message=exception 1: no.10001001 (ims_search_api/Search/Utils.cpp:197)
Search result size limit exceeded: 4006137007
exception throw location:
1: 0x00007f865da6a3e1 in TRexAPI::Search::ResultBuilderContext::materializeItab(TRexAPI::Search::TableHandleProxy const&, TRexCommonObjects::MdVBV const&, ltt::vector<TrexBase::IndexName> const&, unsigned int)+0x480 at Utils.cpp:196 (libhdbcsapi.so)
2: 0x00007f865da956ac in TRexAPI::PartSearchImpl::doSearch(Execution::Context&, TRexAPI::PreparedQuery const&, TRexAPI::QueryRuntime&, ltt::array<TRexAPI::Search::PartIx> const&, ltt::smartptr_handle<TRexCommonObjects::InternalTableBase>&)+0x16a8 at PartSearchImpl.cpp:592 (libhdbcsapi.so)
3: 0x00007f865d405b43 in TRexAPI::DistributedSearchImpl::performSearch(Execution::Context&, TRexAPI::PreparedQuery const&, TRexAPI::QueryRuntime&, ltt::smartptr_handle<TRexCommonObjects::InternalTableBase>&)+0x400 at DistributedSearchImpl.cpp:298 (libhdbcsapi.so)
4: 0x00007f865da973c4 in TRexAPI::SearchAPI::extractResults(Execution::Context&, TRexAPI::Search::RowProjectors*, TRexAPI::Search::RawResultContext*)+0x8c0 at SearchAPI.cpp:478 (libhdbcsapi.so)
5: 0x00007f865da97db1 in TRexAPI::SearchAPI::open(Execution::Context&, unsigned int&, TRexAPI::Search::RowProjectors*, TRexAPI::Search::RawResultContext*)+0x40 at SearchAPI.cpp:1017 (libhdbcsapi.so)
===

2. Application Error
- Database error 129 with SEL access to table Table_1 > transaction rolled back by an internal error: Search result size limit exceeded: 4006137007

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


Read more...

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

HANA, Client Copy, Search result size limit exceeded, limit, Database error 129 , KBA , BC-DB-HDB-SYS , Database Interface/DBMS for SAP HANA , HAN-DB , SAP HANA Database , BC-CTS-CCO , Client Copy (For ByD issues select BC-TLM-CP) , 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.