3226932 - message: Anchortable hint is required if not all requested attributes are from the anchor table

An Enterprise Search query on a HANA Database dumps in error. The following is observed in the indexserver trace file :

indexserver_host.30xx0.001.trc

[130577]\{332304\}[-1/-1] 2022-07-01 12:10:03.692589 i TraceContext     TraceContext.cpp(01269) : UserName=SAPHANADB, ApplicationUserName=<>, ApplicationName=ABAP:<>, ApplicationSource=CL_SQL_STATEMENT==============CP:698, Client=200, StatementHash=56f534ace83a8219ba9018e96731699d, EppRootContextId=97BF81D902884118BE44044355596178, EppTransactionId=7FE9C5CAC75B45C7B54DB0192480E924, EppConnectionId=62BEB9522F7E4C08E10000000A7B1330, EppConnectionCounter=1, EppComponentName=<>, EppAction=shell-header_keyup_6, StatementExecutionID=844437985632851
[130577]\{332304\}[-1/-1] 2022-07-01 12:10:03.692579 e join_eval        MetaModel.cpp(01844) : Assertion failed: ((ltt::all_of(relevantReqAttrs.begin() + 1, relevantReqAttrs.end(), [ixId](QueryInfo::ResolvedReqAttr const& attr) { return attr._ra.ixId == ixId; })) == true); lhs: 0; rhs: 1; 
 message: Anchortable hint is required if not all requested attributes are from the anchor table
[130577]\{332304\}[-1/-1] 2022-07-01 12:10:03.692604 e join_eval        MetaModel.cpp(01844) : 
152369792[thr=130577][parent thr=94233]: JobWrk0710 at 
 1: 0x00007f92a9f3c89b in Diagnose::impl::dumpInfoSelfCtx(ltt::basic_ostream<char, ltt::char_traits<char> >&, bool, bool, bool, bool, bool, bool, unsigned long)+0x67 at Trace.cpp:32 (libhdbbasis.so)
 2: 0x00007f92bdbef67f in JoinEvaluator::MetaModel::resolveQuery(ltt_adp::vector<TRexCommonObjects::QueryEntry, ltt::integral_constant<bool, true> >&, ltt_adp::vector<TRexCommonObjects::REQUESTED_ATTRIBUTE, ltt::integral_constant<bool, true> >&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<TRexAPI::SORT_ATTRIBUTE, ltt::integral_constant<bool, true> >&, JoinEvaluator::QueryInfo&)::{lambda()#4}::operator()() const [clone .isra.0] [clone .lto_priv.0]+0x1ad at MetaModel.cpp:1844 (libhdbcsapi.so)
 3: 0x00007f92bdbf71c0 in JoinEvaluator::MetaModel::resolveQuery(ltt_adp::vector<TRexCommonObjects::QueryEntry, ltt::integral_constant<bool, true> >&, ltt_adp::vector<TRexCommonObjects::REQUESTED_ATTRIBUTE, ltt::integral_constant<bool, true> >&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >, ltt::integral_constant<bool, true> > const&, ltt_adp::vector<TRexAPI::SORT_ATTRIBUTE, ltt::integral_constant<bool, true> >&, JoinEvaluator::QueryInfo&) [clone .cold]+0x191a at string.hpp:1461 (libhdbcsapi.so)
 4: 0x00007f92bcfc3fdb in TRexAPI::TRexApiSearch::searchJoinIndex(TRexAPI::QueryContext&, TRexAPI::TRexApiSearchTableResult&, ltt_adp::vector<TRexAPI::FSTermAttributeInfo, ltt::integral_constant<bool, true> > const*, ltt_adp::vector<TRexConfig::TableOrView, ltt::integral_constant<bool, true> > const&)+0x4007 at TRexApiSearch.cpp:8898 (libhdbcsapi.so)
 5: 0x00007f92bcfe1e7b in TRexAPI::TRexApiSearch::doSearch(TRexAPI::TRexApiSearchTableResult&)+0x4d57 at TRexApiSearch.cpp:5844 (libhdbcsapi.so)
 6: 0x00007f92bcfedeef in TRexAPI::TRexApiSearch::search(TRexAPI::TRexApiSearchTableResult&)+0x5b at TRexApiSearch.cpp:4938 (libhdbcsapi.so)
 7: 0x00007f92bd3f6e5a in TRexAPI::JoinSearchImpl::executeSearch(Execution::Context&, TRexAPI::PreparedQuery const&, TRexAPI::QueryRuntime&, ltt::smartptr_handle<TRexCommonObjects::InternalTableBase>&)+0x9e6 at JoinSearchImpl.cpp:311 (libhdbcsapi.so)
 8: 0x00007f92bd3b4f89 in TRexAPI::SearchAPI::extractResults(Execution::Context&, TRexAPI::Search::RowProjectors*, TRexAPI::Search::RawResultContext*)+0x135 at SearchAPI.cpp:331 (libhdbcsapi.so)
 9: 0x00007f92bd3aaaea in TRexAPI::SearchAPI::fetchAll(Execution::Context&, bool)+0x26 at SearchAPI.cpp:960 (libhdbcsapi.so)
10: 0x00007f92bf54068e in ptime::TrexOltpSearch::search(Execution::Context&, bool)+0xaa at trex_oltp_query.cc:228 (libhdbcswrapper.so)
11: 0x00007f92b83e3ada in ptime::Trex_oltp_search::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x416 at qe_trex_search.cc:3440 (libhdbrskernel.so)
12: 0x00007f92b84a8747 in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0x1c3 at qe_table.cc:234 (libhdbrskernel.so)
13: 0x00007f92b846c5f8 in ptime::Table::open_child(ptime::Env&, ptime::Table const*, ptime::QEParams&, int, bool) const+0x34 at qe_base.h:639 (libhdbrskernel.so)
14: 0x00007f92b8372547 in ptime::Itab_materializer::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x223 at qe_itab_materializer.cc:40 (libhdbrskernel.so)
15: 0x00007f92b84a8747 in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0x1c3 at qe_table.cc:234 (libhdbrskernel.so)
16: 0x00007f92b846c5f8 in ptime::Table::open_child(ptime::Env&, ptime::Table const*, ptime::QEParams&, int, bool) const+0x34 at qe_base.h:639 (libhdbrskernel.so)
17: 0x00007f92b83ea89e in ptime::Trex_search::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x12a at qe_trex_search.cc:1912 (libhdbrskernel.so)
18: 0x00007f92b84a8747 in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0x1c3 at qe_table.cc:234 (libhdbrskernel.so)
19: 0x00007f92b846c5f8 in ptime::Table::open_child(ptime::Env&, ptime::Table const*, ptime::QEParams&, int, bool) const+0x34 at qe_base.h:639 (libhdbrskernel.so)
20: 0x00007f92b845f99e in ptime::Project::do_open(ptime::OperatorEnv&, ptime::QEParams, int) const+0x31a at qe_project.cc:442 (libhdbrskernel.so)
21: 0x00007f92b84a8747 in ptime::Table::open(ptime::Env&, ptime::QEParams, int) const+0x1c3 at qe_table.cc:234 (libhdbrskernel.so)
22: 0x00007f92b7c7b907 in ptime::Query::result_t::open(ptime::Query::Plan*, bool, bool, ptime::Statement*, bool, bool)+0x15b3 at query_result.cc:728 (libhdbrskernel.so)
23: 0x00007f92b7a5c054 in ptime::ResultSet::open_(bool, bool, bool, bool, bool)+0x360 at ResultSet.cc:433 (libhdbrskernel.so)
24: 0x00007f92b7a28a12 in ptime::Statement::executeQuery_(Execution::Context&, EAPI::CursorHoldability const&, bool, bool, bool, bool, bool, bool, bool)+0x810 at Statement.cc:2894 (libhdbrskernel.so)
25: 0x00007f92b7a7bf1a in ptime::PreparedStatement::executeQuery(Execution::Context&, EAPI::CursorHoldability const&, bool, bool, bool, bool, ptime::Statement::BatchProcessingState, bool, bool, bool, bool)+0x2c6 at PreparedStatement.cc:618 (libhdbrskernel.so)
26: 0x00007f92b7a77cfe in .LTHUNK336.lto_priv.0+0x9a at PreparedStatement.cc:200 (libhdbrskernel.so)
27: 0x00007f92aa7386b6 in EAPI::PreparedStatementHandle::executeQuery(Execution::Context&, EAPI::StatementProperty const&)+0x52 at PreparedStatementHandle.cpp:149 (libhdbeapi.so)
28: 0x00007f92b65e4a5d in sqlscript::ExecuteFunction<EAPI::ResultSetHandle, EAPI::PreparedStatementHandle>::executePreparedStatement(EAPI::PreparedStatementHandle const&, EAPI::StatementProperty&, EAPI::ResultSetHandle (EAPI::PreparedStatementHandle::*)(Execution::Context&, EAPI::StatementProperty const&)) [clone .constprop.0]+0x109 at se_eapi_proxy.cc:613 (libhdbrskernel.so)
29: 0x00007f92b7d5bcd8 in sqlscript::SePreparedStatementProxy::executeQuery(EAPI::PreparedStatementHandle const&, EAPI::StatementProperty&)+0x14 at se_eapi_proxy.cc:666 (libhdbrskernel.so)
30: 0x00007f92b073c84e in sqlscript::SeFacade::execExecuteQuery(EAPI::PreparedStatementHandle const&, EAPI::StatementProperty&)+0x1a at SeFacade.cpp:126 (libhdbsqlscriptutil.so)
31: 0x00007f92ba82d73d in sqlscript::exe::executeQuery(EAPI::PreparedStatementHandle&, EAPI::StatementProperty&, sqlscript::SeOpSQL const&, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > > const&, bool)+0x49 at SeOperatorUtil.cpp:357 (libhdbsqlscriptexecutor.so)
32: 0x00007f92ba7d1f99 in sqlscript::(anonymous namespace)::operate(sqlscript::SeOpSQLSelectTableAssign const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > > const&, ltt::shared_ptr<sqlscript::Context, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::SeOpRuntime*, bool) [clone .constprop.0]+0x205 at SeOperatorImpl.cpp:1928 (libhdbsqlscriptexecutor.so)
33: 0x00007f92ba85822e in sqlscript::SeOperatorImpl::operate(sqlscript::SeOp const&, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > > const&, ltt::shared_ptr<sqlscript::Context, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::SeOpRuntime*)+0x99a at SeOperatorImpl.cpp:1970 (libhdbsqlscriptexecutor.so)
34: 0x00007f92ba91eb07 in sqlscript::SeEvaluatorImpl::eval(ltt::smart_ptr<sqlscript::SeOp, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > > const&, sqlscript::exe::Env&, sqlscript::SeOpRuntime&)+0x73 at SeEvaluatorImpl.cpp:604 (libhdbsqlscriptexecutor.so)
35: 0x00007f92ba90607f in sqlscript::SeEvaluatorImpl::eval(ltt::smart_ptr<sqlscript::SeOp, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > > const&, sqlscript::exe::Env&)+0x6b at SeEvaluatorImpl.cpp:2862 (libhdbsqlscriptexecutor.so)
36: 0x00007f92ba91e515 in sqlscript::SeEvaluatorImpl::evalSeOp(ltt::smart_ptr<sqlscript::SeOp, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::exe::Env&)+0xa1 at SeEvaluatorImpl.cpp:895 (libhdbsqlscriptexecutor.so)
37: 0x00007f92ba91e9f8 in sqlscript::SeEvaluatorImpl::dispatch(ltt::smart_ptr<sqlscript::SeOp, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::exe::Env&)+0x414 at SeEvaluatorImpl.cpp:884 (libhdbsqlscriptexecutor.so)
38: 0x00007f92ba91ea56 in sqlscript::SeEvaluatorImpl::eval(ltt::smart_ptr<sqlscript::SeOp, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::exe::Env&)+0x42 at SeEvaluatorImpl.cpp:740 (libhdbsqlscriptexecutor.so)
39: 0x00007f92ba9106d6 in sqlscript::SeEvaluatorImpl::eval(sqlscript::exe::SequentialOp const&, sqlscript::exe::Env&)+0x82 at SeEvaluatorImpl.cpp:1728 (libhdbsqlscriptexecutor.so)
40: 0x00007f92ba91e889 in sqlscript::SeEvaluatorImpl::dispatch(ltt::smart_ptr<sqlscript::SeOp, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::exe::Env&)+0x2a5 at SeEvaluatorImpl.cpp:873 (libhdbsqlscriptexecutor.so)
41: 0x00007f92ba91ea56 in sqlscript::SeEvaluatorImpl::eval(ltt::smart_ptr<sqlscript::SeOp, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::exe::Env&)+0x42 at SeEvaluatorImpl.cpp:740 (libhdbsqlscriptexecutor.so)
42: 0x00007f92ba91f725 in sqlscript::SeEvaluatorImpl::evalPlan(ltt::shared_ptr<sqlscript::SePlan, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::exe::Env&)+0xe1 at SePlan.h:257 (libhdbsqlscriptexecutor.so)
43: 0x00007f92ba922821 in sqlscript::SeEvaluatorImpl::prepareAndEval(ltt::shared_ptr<sqlscript::SePlan, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, sqlscript::exe::Env&, ltt::shared_ptr<sqlscript::Context, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&)+0x80 at SeEvaluatorImpl.cpp:459 (libhdbsqlscriptexecutor.so)
44: 0x00007f92ba922d23 in sqlscript::SeEvaluatorImpl::eval(ltt::shared_ptr<sqlscript::SePlan, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > > const&, ltt::shared_ptr<sqlscript::exe::Env, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >&, ltt::shared_ptr<sqlscript::Context, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&)+0x4b0 at SeEvaluatorImpl.cpp:437 (libhdbsqlscriptexecutor.so)
45: 0x00007f92ba92c5db in sqlscript::SeEvaluator::eval(ltt::shared_ptr<sqlscript::SePlan, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > > const&, ltt::shared_ptr<sqlscript::Context, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&)+0x97 at shared_ptr.hpp:235 (libhdbsqlscriptexecutor.so)
46: 0x00007f92ba8c1042 in sqlscript::exe::ExecutableImpl::executeImpl(ptime::Env*, ltt::vector<ltt::shared_ptr<sqlscript::SeArg, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > >&, sqlscript::SeEvaluator&, ltt::shared_ptr<sqlscript::Context, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> > const&, ltt::shared_ptr<sqlscript::exe::Env, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >*) const+0x530 at ExecutableImpl.cpp:1408 (libhdbsqlscriptexecutor.so)
47: 0x00007f92ba8cba46 in sqlscript::exe::ExecutableImpl::execute(ptime::Env&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ptime::fastvector<ptime::ProcParamBase*, 16ul>&, sqlscript::SeEvaluator&, bool) const+0x252 at ExecutableImpl.cpp:361 (libhdbsqlscriptexecutor.so)
48: 0x00007f92ba8ccab1 in sqlscript::exe::ExecutableImpl::execute(ptime::Env&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ptime::fastvector<ptime::ProcParamBase*, 16ul>&) const+0x50 at ExecutableImpl.cpp:294 (libhdbsqlscriptexecutor.so)
49: 0x00007f92ba8b9fb3 in sqlscript::exe::ExecutableWrapper::execute(ptime::Env&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ltt::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<int, 64> > const&, ptime::fastvector<ptime::ProcParamBase*, 16ul>&) const+0x170 at ExecutableWrapper.cpp:53 (libhdbsqlscriptexecutor.so)
50: 0x00007f92b84abc43 in ptime::Proc_call::executeSQLScriptExecutable_(ptime::Env&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> >&) const+0x50 at qe_proc_call.cc:376 (libhdbrskernel.so)
51: 0x00007f92b84abf7a in ptime::Proc_call::executeSQLScriptExecutable(ptime::Env&, char const*) const+0x296 at qe_proc_call.cc:454 (libhdbrskernel.so)
52: 0x00007f92b84ad54b in ptime::Proc_call::execute(ptime::Env&) const+0x6d7 at qe_proc_call.cc:336 (libhdbrskernel.so)
53: 0x00007f92b84b2ae4 in ptime::Proc_call::operator()(ptime::Env&) const+0x690 at qe_proc_call.cc:182 (libhdbrskernel.so)
54: 0x00007f92b7cb974e in ptime::Query::_execute(Execution::Context&, ptime::Transaction&, char const*, ptime::Query::Plan*, ptime::Query::param_t*, ptime::Query::result_t*, bool, bool)+0x57a at query.cc:4649 (libhdbrskernel.so)
55: 0x00007f92b7ccf4a6 in ptime::Query::execute(ptime::Transaction&, char const*, ptime::Query::param_t*, ptime::Query::Plan*, ptime::Query::result_t*, ptime::Statement*, bool, bool, char const*, ptime::QueryExecutor*)+0x612 at query.cc:801 (libhdbrskernel.so)
56: 0x00007f92b7a29a04 in ptime::Statement::execute_(Execution::Context&, EAPI::CursorHoldability const&, bool, bool, bool)+0x710 at Statement.cc:2726 (libhdbrskernel.so)
57: 0x00007f92b7a7c654 in ptime::PreparedStatement::execute(Execution::Context&, EAPI::CursorHoldability const&, bool, bool, bool, ptime::Statement::BatchProcessingState, bool, bool, bool)+0x270 at PreparedStatement.cc:544 (libhdbrskernel.so)
58: 0x00007f92b7a77dcd in .LTHUNK335.lto_priv.0+0x89 at PreparedStatement.cc:178 (libhdbrskernel.so)
59: 0x00007f92a3afef79 in esh::executeESHQuery(ptime::PreparedStatement*)+0x45 at ESH_EAPIHandler.cpp:23 (libhdbeshrt.so)
60: 0x00007f92a39e35eb in esh::runtime::Processor::execute()+0x197 at Processor.cpp:217 (libhdbeshrt.so)
61: 0x00007f92a3a184e3 in esh::runtime::BuiltinProcedureSearch::executeSearchJob(esh::runtime::BuiltinProcedureRequest&, esh::BuiltinProcedureResult&, ltt::shared_ptr<esh::cds::ESHModel, ltt::default_deleter, ltt::integral_constant<bool, false>, ltt::integral_constant<bool, false> >&)+0x780 at BuiltinProcedureSearch.cpp:807 (libhdbeshrt.so)
62: 0x00007f92a3a093f0 in esh::SimpleEshJob<esh::runtime::BuiltinProcedureSearch::search()::{lambda(unsigned int)#1}, TRexUtils::Parallel::SimpleBlockPartitioner<unsigned int> >::run(Execution::Context&, esh::SimpleEshJob<esh::runtime::BuiltinProcedureSearch::search()::{lambda(unsigned int)#1}, TRexUtils::Parallel::SimpleBlockPartitioner<unsigned int> >::JobObject&) [clone .lto_priv.0]+0x50 at BuiltinProcedureSearch.cpp:683 (libhdbeshrt.so)
63: 0x00007f92a9ea65a6 in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x2372 at JobExecutorImpl.cpp:1220 (libhdbbasis.so)
64: 0x00007f92a9e8fa8a in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x336 at JobExecutorThreads.cpp:384 (libhdbbasis.so)
65: 0x00007f92a9e84ca8 in Execution::JobWorker::run(void*&)+0x764 at JobExecutorThreads.cpp:1284 (libhdbbasis.so)
66: 0x00007f92a9e47bd5 in Execution::Thread::staticMainImp(Execution::Thread*)+0x531 at Thread.cpp:522 (libhdbbasis.so)
67: 0x00007f92a9e37858 in Execution::pthreadFunctionWrapper(Execution::Thread*)+0x1e4 at ThreadInterposition.cpp:639 (libhdbbasis.so)
68: 0x00007f92a94854f9 in start_thread+0xd5 (libpthread.so.0)
69: 0x00007f92a7b3fecf in __GI___clone+0x3b (libc.so.6)
[130577]\{314807\}[84/-1] 2022-07-01 12:10:03.817329 e esh              Processor.cpp(00317) : Failed to execute stmt=
'DO (

. . . . . . . . . . . . 

END' : column store error: "SAPHANADB"."(DO statement)": line 19 col 1 (at pos 696): search table error:  [23057] exception 70023057: Internal error during join: invalid input
[130577]\{314807\}[84/-1] 2022-07-01 12:10:03.817356 e esh              Processor.cpp(00320) : bind values: _client:200 --- _constraintValue1:E --- _contains_0:(("DOCUMENTTEXT" "FILEDESCRIPTION" "FILENAME" "INVGCSMACTIVITYLOCATIONDESC" "INVGCSMORDERDESCRIPTION" "INVGCSMORDERID" "PERSONFULLNAME" "PLAINLONGTEXT" "RELATIONNOTE"):IW32)
[130577]\{314807\}[84/-1] 2022-07-01 12:10:03.817479 e esh              BuiltinProcedureSearch.cpp(00932) : ESH_SEARCH URI: /v6/$all?$top=10&$skip=0&$count=true&estimate=true&$select=BUSINESSACTIVITYCATEGORYNAME,DOCUMENTTEXT,INVGCSMACTIVITYLOCATIONDESC,INVGCSMACTIVITYPROCESSTYPETEXT,INVGCSMACTIVITYSTATUSTEXT,INVGCSMORDERDESCRIPTION,INVGCSMORDERID,INVGCSMORDERUUID,INVGCSMSECURITYLVLDESC,PERSONFULLNAME,PLAINLONGTEXT,RELATIONNOTE,SERVICEDOCUMENTPRIORITYNAME&$apply=filter(Search.search(query='SCOPE:ESH_U_ICMINC %28IW32%29'))&wherefound=true&whyfound=true View:"SAPHANADB"."ESH_U_ICMINC"
[130577]\{314807\}[84/-1] 2022-07-01 12:10:03.817489 e esh              BuiltinProcedureSearch.cpp(00933) : ESH_SEARCH error: exception 9620008: Query execution failed 

SAP HANA, platform edition 2.0

KBA , HAN-DB-ENG-ESH , SAP HANA Enterprise Search Engine , HAN-DB-ENG , SAP HANA DB Engines , Problem