fatal error: Error in the generated plan. See error trace for details

[giuseppe_moglia5]

Hi Guys

do you have an hint for me?

This query gives me the error

fatal error: Error in the generated plan. See error trace for details

here the query:

select "orpa_flg_status" , "orpb_c_part"

from "flusso_orpa" , "flusso_orpb" , "flusso_mrpa"

where "orpa_tst_doc"="orpb_tst_doc" and

"orpa_prf_doc"="orpb_prf_doc" and

"orpa_a_doc"="orpb_a_doc" and

"orpa_n_doc"="orpb_n_doc" and

"orpa_c_ditta"="orpb_c_ditta" and

"orpb_c_part"="mrpa_c_part" and

"orpb_c_ditta"="mrpa_c_ditta" and

( "mrpa_tst_doc"='PAA' or

"mrpa_tst_doc"='RAA' or

"mrpa_tst_doc"='PLE' ) and

"orpa_c_ditta"='01' and

"orpa_tst_doc"='ROA' and

"orpa_dt_ini_val" <={d '2016-07-08' } and

"orpa_dt_fin_val" >={d '2016-07-08' } and

"mrpa_c_part" >='' and

"mrpa_c_part" <= 'zzzzzzzzzz'

If I try just some clause I've no error

How can I see error trace?

Thanks in advance

[lucas_oliveira]

Ciao Giuseppe,

You will get more information about this error in the indexserver trace files (HANA Studio -> Admin -> Diagnosis files).

As of now, the description is quite unclear so having that information might help us understand better whats going on. So share your last trace information right after executing the query.

Regards,

Lucas de Oliveira

[giuseppe_moglia5]

Thanks Lucas

Here the trace:

[47945]{400767}[102/-1] 2016-07-20 17:25:35.318345 i TraceContext     TraceContext.cpp(00721) : UserName=SYSTEM, ApplicationUserName=moglia_g, ApplicationName=HDBStudio, ApplicationSource=csns.sql.editor.SQLExecuteFormEditor$2$1.run(SQLExecuteFormEditor.java:831);

[47945]{400767}[102/-1] 2016-07-20 17:25:35.318334 e Row_Engine       qo_algebra.h(00498) : Error in the generated plan. DicVal(1000130,4) not found. Please report this error with the CALL STACK below:

1066252[thr=47945]: SqlExecutor at

1: 0x00007f8b0ed91e54 in Execution::ContextFunctions::dumpInfo(Execution::Context&, ltt::basic_ostream<char, ltt::char_traits<char> >&, bool, bool, bool, bool, bool)+0x2c0 at ContextFunctions.cpp:629 (libhdbbasis.so)

2: 0x00007f8b00db5159 in ptime::qo_TrexSearch::gen_exec_trex_join_index(ptime::qo_Env&)+0xb35 at qo_algebra.h:498 (libhdbrskernel.so)

3: 0x00007f8b00dbc57f in ptime::qo_TrexSearch::gen_exec_plan_node(ptime::qo_Rel::GenTask&, ltt_adp::stack<ptime::qo_Rel::GenTask, ltt::deque<ptime::qo_Rel::GenTask, ltt::deque_buffer_size<ptime::qo_Rel::GenTask, 512> > >&)+0x9eb at qo_trex_search.cc:4831 (libhdbrskernel.so)

4: 0x00007f8b00dc2856 in ptime::qo_TrexSearch::gen_exec_plan(ptime::qo_Rel::GenTask&, ltt_adp::stack<ptime::qo_Rel::GenTask, ltt::deque<ptime::qo_Rel::GenTask, ltt::deque_buffer_size<ptime::qo_Rel::GenTask, 512> > >&, ltt_adp::stack<ptime::qo_Rel::GenTask, ltt::deque<ptime::qo_Rel::GenTask, ltt::deque_buffer_size<ptime::qo_Rel::GenTask, 512> > >&)+0x312 at qo_trex_search.cc:4136 (libhdbrskernel.so)

5: 0x00007f8b00cdcc83 in ptime::qo_Rel::gen_exec_plan(ptime::qo_Rel::GenTask&)+0x140 at qo_gen_exec_plan_rel.cc:900 (libhdbrskernel.so)

6: 0x00007f8b00ce73bc in ptime::qo_Project::gen_exec_plan(ptime::qo_Rel::GenTask&)+0x148 at qo_gen_exec_plan_rel.cc:2773 (libhdbrskernel.so)

7: 0x00007f8b00ccf20c in ptime::qo_Rel::evaluate_opt_plan(ptime::qo_Env&)+0xa8 at qo_gen_exec_plan_rel.cc:877 (libhdbrskernel.so)

8: 0x00007f8b01046736 in ptime::Query::_evaluate(ptime::qo_Env&, ptime::qo_Rel*)+0xe2 at query.cc:4348 (libhdbrskernel.so)

9: 0x00007f8b0103f0c3 in ptime::Query::compile_parse_tree(ptime::Transaction&, char const*, bool, char const*, void*, ptime::Query::Plan*, ptime::ptl::stp_heap*, ptime::qo_Context&, ptime::Query::PlanVizQueryFlag&, ptime::IdTable*, bool, bool, bool, unsigned long, bool, bool)+0xe60 at query.cc:2263 (libhdbrskernel.so)

10: 0x00007f8b01042273 in ptime::Query::compile(ptime::Transaction&, char const*, bool, char const*, char const*, ptime::Query::PlanHandle&, ptime::IdTable*, bool, bool, bool, bool, unsigned long*, ptime::qo_Context*, bool, char const*, bool, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const*, bool)+0x870 at query.cc:1084 (libhdbrskernel.so)

11: 0x00007f8b0108086a in ptime::Query::QueryCache::compile_(ptime::Transaction&, char const*, char const*, bool, char const*, ptime::Query::PlanHandle&, unsigned long*, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const*)+0x296 at query_cache.cc:831 (libhdbrskernel.so)

12: 0x00007f8b01087394 in ptime::Query::QueryCache::compile_and_insert_(ptime::Transaction&, char const*, char const*, bool, char const*, ptime::Query::PlanHandle&, ltt_adp::basic_string<char, ltt::char_traits<char>, ltt::integral_constant<bool, true> > const*)+0x100 at query_cache.cc:552 (libhdbrskernel.so)

13: 0x00007f8b01088264 in ptime::Query::QueryCache::lookup_or_compile_(ptime::Transaction&, char const*, char const*, bool, char const*, ptime::Query::PlanHandle&)+0x380 at query_cache.cc:494 (libhdbrskernel.so)

14: 0x00007f8b008f2efe in ptime::Query::QueryCache::lookup_or_compile(ptime::Transaction&, char const*, char const*, bool, char const*, ptime::Query::PlanHandle&)+0x4a at query_cache.h:438 (libhdbrskernel.so)

15: 0x00007f8b0122326a in ptime::Statement::lookupOrCompileCode_()+0x116 at Statement.cc:910 (libhdbrskernel.so)

16: 0x00007f8b012318d3 in ptime::Statement::compile_(Execution::Context&, char const*, bool, bool, bool)+0x660 at Statement.cc:1014 (libhdbrskernel.so)

17: 0x00007f8b0124ddbb in ptime::PreparedStatement::compile_(Execution::Context&, char const*, bool, bool, bool)+0x97 at PreparedStatement.cc:310 (libhdbrskernel.so)

18: 0x00007f8b011ee16d in ptime::Connection::prepareStatement(char const*, char const*, char const*, int, int, bool, bool, bool, bool, bool, bool)+0x489 at Connection.cc:2588 (libhdbrskernel.so)

19: 0x00007f8b011d5ddf in ptime::Connection::prepareStatement(char const*, bool, bool, bool, bool, bool)+0x4b at Connection.cc:2368 (libhdbrskernel.so)

20: 0x00007f8b0134a6de in ptime::SessionCodecNewdb::dExecuteString(Communication::Protocol::RequestPacket&, ptime::Action*)+0x6aa at sm_codec_newdb.cc:2113 (libhdbrskernel.so)

21: 0x00007f8b0135c5a2 in ptime::SessionCodecNewdb::dVendorMessage(ptime::orawstream&)+0x470 at sm_codec_newdb.cc:631 (libhdbrskernel.so)

22: 0x00007f8b013307df in ptime::SessionCodec::decodeMessage(ptime::orawstream&)+0x3b at sm_codec.cc:237 (libhdbrskernel.so)

23: 0x00007f8b01377a6a in ptime::SessionHandler::receiveMessage(ptime::CommEvent*)+0x966 at sm_handler.cc:517 (libhdbrskernel.so)

24: 0x00007f8b0138dff7 in ptime::TcpReceiver::doWork(ptime::CommMgr*)+0x1033 at tcp_receiver.cc:489 (libhdbrskernel.so)

25: 0x00007f8b0138f51e in ptime::TcpReceiver::run(void*)+0x1aa at tcp_receiver.cc:558 (libhdbrskernel.so)

26: 0x00007f8b1994fc52 in TrexThreads::PoolThread::run()+0x850 at PoolThread.cpp:265 (libhdbbasement.so)

27: 0x00007f8b199517b8 in TrexThreads::PoolThread::run(void*&)+0x14 at PoolThread.cpp:124 (libhdbbasement.so)

28: 0x00007f8b0eddff27 in Execution::Thread::staticMainImp(void**)+0xa93 at Thread.cpp:476 (libhdbbasis.so)

29: 0x00007f8b0ede046d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:546 (libhdbbasis.so)

[lucas_oliveira]

Hi,

Good chances this is a bug already corrected in SP10 (Rev 102+). See SAP Note

2193110 for it.

If you're below that revision, upgrade. If not, create an SAP incident.

BRs,

Lucas de Oliveira