Symptom
A query that contained both an EXISTS subquery and a reference to a view within a FROM clause returns a Non-Fatal IQ Internal Error at optlib/opt_QueryTree.cxx.
IQ Internal error. Please report this to SAP IQ support.
--
(optlib/opt_QueryTree.cxx 10929)
SQLCODE=-1006000, ODBC 3 State="HY000"
-
--.iqmsg
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at optlib/opt_QueryTree.cxx:10929 on thread 140608181876480 (TID 3)
**
** 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: 5 SA connID: 5 IQ connID: 0000000261 User: DBA
** Time of error: 2018-06-01 19:07:08
** IQ Version: SAP IQ/16.0.110/10526/P/sp11.10
** OS info: IQ built on: Enterprise Linux64 - x86_64 - 2.6.18-194.el5, Executed on: Linux/VM02/4.8.6-300.fc25.x86_64/#1 SMP Tue Nov 1 12:36:38 UTC 2016/x86_64
** Command status when error occured: CURSOR ACTIVE
** Command text:
...
-
stacktrace
pcstkwalk
ucstkgentrace
StackTraceForThisThread
df_Exception::df_Exception
df_Exception::ThrowException_0
opt_QueryTree::RecursiveSetInVariance
opt_QueryTree::ResetViewNodeAfterFlattenSubq
opt_QueryTree::FlattenExistsSubqueryBefore
opt_Select::FlattenExistsSubquery
opt_Select::AnalyzeSubQueries
opt_Driver::OptimizeQueryExp
opt_Driver::GenerateTree
st_cursorIQtoSA::Parse
df_OpenCursor::Parse
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor+0x25
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::OpenCursor
df_OmniRowScan::Restart
dfo_Scan::DoFetch
dfo_Scan::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetch
dfo_Root::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetchRelative
dfo_Root::FetchRelative
DB_Search_fetch
do_move_cursor
dbi_fetch
db__fetch
RequestProcedure::call
Context::call
Worker::call_on_stack
TopProcedure::call
Worker::spawn
EngStream::handle_ind
EngStream::execute
RQBaseItem::do_work
RequestQueue::worker_body
request_task
run_task_body+0x2d
UnixTask::pre_body
_fini+0x514cbae6
_fini+0x5097138b
Read more...
Environment
- SAP IQ 16.0 SP11 PL10
Product
Keywords
"opt_QueryTree.cxx"; "RecursiveSetInVariance"; "ResetViewNodeAfterFlattenSubq"; "FlattenExistsSubqueryBefore"; "FlattenExistsSubquery"; "CR813582"; "813582"; "CR 813582"; "169164"; "Bug 169164"; "bugzilla 169164"; , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.