SAP Knowledge Base Article - Preview

2651478 - SAP IQ - Non-Fatal IQ Internal Error at optlib/opt_QueryTree.cxx with a query that contained both an EXISTS subquery and a reference to a view within a FROM clause

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

SAP IQ 16.0 ; SAP IQ 16.1

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.