SAP Knowledge Base Article - Preview

3079985 - Non-Fatal IQ Internal Error Detected dflib/dfo.cxx:13814 - SAP IQ

Symptom

Encountered issue below even applying : DML_Options6:  16777216

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at dflib/dfo.cxx:13814 on thread 140718970767104 (TID 3)
** with Query_Name: dfo.cxx.13814
** Error detected at DFO #03 Union All (shadow 0)
** for expression: SWITCH(XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX]
**
** Please report this to SAP IQ support
** with the following diagnostic information,
** and, if possible, with the user's command.
**
** Error from IQ connection: SA connHandle: 112 SA connID: 6 IQ connID: 0000133394 User: DBA
** Time of error: 2021-07-16 11:49:33
** IQ Version: SAP IQ/16.1.040/15175/P/SP04.09
** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/XXXXXXXXX/3.12.74-60.64.40-default/#1 SMP Wed May 10 05:07:16 UTC 2017 (4eb35ec)/x86_64
** Command status when error occurred: CURSOR ACTIVE
** Command text: ...........................................

===== Thread Number 140718970767104 (IQ connID: 0000133394) =====
pc: 0x7ffbab130cd8 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x38
pc: 0x7ffbab131531 ucstkgentrace(int, int)+0x141
pc: 0x7ffbab132469 StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x299
pc: 0x7ffbaa98f4a5 df_Exception::df_Exception(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x13e5
pc: 0x7ffbaa9902f7 df_Exception::ThrowException(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x37
pc: 0x7ffbaab5ccf4 dfo::ValidateLocalInternalConsistency()+0x204
pc: 0x7ffbaab51766 dfo::ValidateInternalConsistency()+0x36
pc: 0x7ffbaab51766 dfo::ValidateInternalConsistency()+0x36
pc: 0x7ffbaab51766 dfo::ValidateInternalConsistency()+0x36
pc: 0x7ffbaab51766 dfo::ValidateInternalConsistency()+0x36
pc: 0x7ffbaab51766 dfo::ValidateInternalConsistency()+0x36
pc: 0x7ffbaac10ff5 dfo_Root::Prepare()+0x3f5
pc: 0x7ffbabd78c0c st_cursorIQtoSA::Prepare()+0x15c
pc: 0x7ffbaa9e6beb df_OpenCursor::Prepare()+0x5b
pc: 0x7ffbabd7290b st_command::DoCmdThroughResourceGate()+0x5b
pc: 0x7ffbabdcaa32 st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x32
pc: 0x7ffbaa981375 UIQDML_OpenCursor+0x25
pc: 0x7ffbabdd344b st_SAIQInterfaceInfo::callFunction()+0x1b
pc: 0x7ffbabe39752 st_SAIQInterface::RunIQFunc(st_SAIQInterfaceInfo*)+0x222
pc: 0x7ffbabdd390b st_SAIQInterface::Execute(int, void*, unsigned int (*)+0x36b
pc: 0x7ffbab142cbb saint_iqthresholddml::OpenCursor(a_statement*, IConnection*, ICursor*, a_cursor_spec*, a_cursor_orientation)+0x8b
pc: 0x7ffff6ecbd0e df_OmniRowScan::Restart(a_cursor_orientation)+0x1ce
pc: 0x7ffff6ead438 dfo_Scan::DoFetch(a_cursor_orientation)+0xb8
pc: 0x7ffff6eacf9b dfo_Scan::DoFirstFetch(a_cursor_orientation)+0x9b
pc: 0x7ffff6e92927 dfo_Base::Fetch(a_cursor_orientation)+0xa7
pc: 0x7ffff6e9b3e4 dfo_Root::DoFetch(a_cursor_orientation)+0x44
pc: 0x7ffff6e9b5f0 dfo_Root::DoFirstFetch(a_cursor_orientation)+0x30
pc: 0x7ffff6e92927 dfo_Base::Fetch(a_cursor_orientation)+0xa7
pc: 0x7ffff6e93b1d dfo_Root::DoFetchRelative(int, int*)+0xbd
pc: 0x7ffff6e96b81 dfo_Root::FetchRelative(int, int*)+0x91
pc: 0x7ffff6a76735 DB_Search_fetch(a_db_cursor*, unsigned int, int, int*)+0x65
pc: 0x7ffff6c0e7f2 dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+0xe2
pc: 0x7ffff6d75df2 db__fetch(Connection*, an_sqlpres_receive*)+0x1b2
pc: 0x7ffff6d94e56 RequestProcedure::call()+0xe76
pc: 0x7ffff6b3e451 Worker::spawn(Procedure*)+0x31
pc: 0x7ffff6d98d56 EngStream::handle_ind(unsigned char, unsigned int)+0x156
pc: 0x7ffff6d9a8af EngStream::execute()+0x81f
pc: 0x7ffff6d9aa2d RQConnItem::do_request()+0xd
pc: 0x7ffff6d927de RQBaseItem::do_work(Worker*)+0x1e
pc: 0x7ffff6dd63e7 RequestQueue::worker_body()+0x77
pc: 0x7ffff6d93b99 request_task(void*)+0x89
pc: 0x7ffff7212d7e run_task_body+0x1e
pc: 0x7ffff6dd8031 UnixTask::pre_body(void*)+0x71
pc: 0x7ffff63880a4 <unknown>
pc: 0x7ffff582f02d <unknown>
I. 07/16 11:49:33. 0000133394
**
** End of stack trace from Non-Fatal IQ Internal Error dflib/dfo.cxx:13814
**
********************************************************

Exception Thrown from dflib/dfo.cxx:13814, Err# 0, tid 3 origtid 3
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006001, SQLState: 'QBA01', Severity: 23
[20239]: IQ Internal error. Please report this to SAP IQ support.
Generating HTML Query plan: /opt/sybase/iq_extracts/DBA_dfo_cxx_13814_L_0__20210716-114933_1085.html
Query dfo.cxx.13814 executed in: 2228572631.067 second(s)


Read more...

Environment

SAP IQ 16.1 SP04 PL09

Product

SAP IQ 16.1

Keywords

dflib/dfo, union, union all , KBA , BC-SYB-IQ , Sybase IQ , 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.