Symptom
A select statement with many aggregate functions and a group by clause generate a stacktrace with the following error:
** Non-Fatal IQ Internal Error Detected ** at dflib/dfo_GroupBy.cxx:2761
*******************STACKTRACE ***************
pc: 0x7f2c3265fa48 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x38
pc: 0x7f2c3266027d ucstkgentrace(int, int)+0x13d
pc: 0x7f2c32661159 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x299
pc: 0x7f2c31e2d225 df_Exception::df_Exception(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x1315
pc: 0x7f2c31e2e1bb df_Exception::ThrowException_0(char const*, int, df_Exception::df_ErrorCode)+0x3b
pc: 0x7f2c320356a8 dfo_GroupBy::CreateTopGBAggFuncs(hos_vector_noerror*, hos_vector_noerror*, dfo*, hos_vector_noerror*)+0xca8
pc: 0x7f2c322f9659 opt_Driver::ApplyGroupBySuperAggregateTransform(dfo*)+0x419
pc: 0x7f2c322f92ca opt_Driver::ApplyGroupBySuperAggregateTransform(dfo*)+0x8a
pc: 0x7f2c3222dd2d opt_Driver::GenerateTree(QueryNode*, st_cursor*, a_statement const*, UITable*, UIIndex*, s_bm*, unsigned int*, db_RebuildIndexInfo**, int, a_table*, hos_vector_noerror*, hs_store*, int, db_IQParallelIndexInfo*, rv_MergeCmdState*)+0x739d
pc: 0x7f2c33209eff st_cursorIQtoSA::Parse()+0x50f
pc: 0x7f2c31e83c11 df_OpenCursor::Parse()+0xc1
pc: 0x7f2c3320123f st_command::DoCmdThroughResourceGate()+0x2f
pc: 0x7f2c33257212 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x32
pc: 0x7f2c31e1f6e5 UIQDML_OpenCursor+0x25
pc: 0x7f2c3325f4eb st_SAIQInterfaceInfo::callFunction()+0x1b
pc: 0x7f2c332c7df7 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x1df
pc: 0x7f2c3325f9ab st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x36b
pc: 0x7f2c3267199b saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+0x8b
pc: 0x7f2d169408be df_OmniRowScan::Restart(a_cursor_orientation)+0x1ce
pc: 0x7f2d16922048 dfo_Scan::DoFetch(a_cursor_orientation)+0xb8
pc: 0x7f2d16921bab dfo_Scan::DoFirstFetch(a_cursor_orientation)+0x9b
pc: 0x7f2d16907367 dfo_Base::Fetch(a_cursor_orientation)+0xa7
pc: 0x7f2d1690fe54 dfo_Root::DoFetch(a_cursor_orientation)+0x44
pc: 0x7f2d16910060 dfo_Root::DoFirstFetch(a_cursor_orientation)+0x30
pc: 0x7f2d16907367 dfo_Base::Fetch(a_cursor_orientation)+0xa7
pc: 0x7f2d1690855d dfo_Root::DoFetchRelative(int, int*)+0xbd
pc: 0x7f2d1690b611 dfo_Root::FetchRelative(int, int*)+0x91
pc: 0x7f2d164f55e5 DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+0x65
pc: 0x7f2d16687582 dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+0xe2
pc: 0x7f2d167ebba2 db__fetch(Connection*, an_sqlpres_receive*)+0x1b2
pc: 0x7f2d1680a426 RequestProcedure::call()+0xe76
pc: 0x7f2d165ba7e1 Worker::spawn(Procedure*)+0x31
pc: 0x7f2d1680e306 EngStream::handle_ind(unsigned char, unsigned int)+0x156
pc: 0x7f2d1680fe3f EngStream::execute()+0x81f
pc: 0x7f2d1680ffbd RQConnItem::do_request()+0xd
pc: 0x7f2d16807d4e RQBaseItem::do_work(Worker*)+0x1e
pc: 0x7f2d1684b1d7 RequestQueue::worker_body()+0x77
pc: 0x7f2d1680915d request_task(void*)+0xdd
pc: 0x7f2d16c8028e run_task_body+0x1e
pc: 0x7f2d1684cc41 UnixTask::pre_body(void*)+0x71
pc: 0x7f2d15e0fdd5 __do_global_dtors_aux_fini_array_entry+0xe0acd8c5
pc: 0x7f2d1532bead __do_global_dtors_aux_fini_array_entry+0xdffe999d
******************* End of STACKTRACE ******************
**
** End of stack trace from Non-Fatal IQ Internal Error dflib/dfo_GroupBy.cxx:2761
**
********************************************************
Exception thrown from dflib/dfo_GroupBy.cxx:2761, Err# 0, tid 85 origtid 85 O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23 IQ Internal error. Please report this to SAP IQ support. -- (dflib/dfo_GroupBy.cxx 2761)
Read more...
Environment
SAP IQ 16.1 SP03 PL02, simplex platform on RedHat Linux
Product
Keywords
dflib/dfo_GroupBy, 818775, cr 818775, cr#818775,dfo_GroupBy::CreateTopGBAggFuncs , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
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.