SAP Knowledge Base Article - Preview

2513084 - Query fails with Non-Fatal IQ Internal Error at optlib/opt_JoinNode.cxx:10768 -- SAP IQ

Symptom

A query with any predicate on complex view fails with following non-fatal stack trace frames and messages in .iqmsg.
Simple select * from same view without any predicates returns all the rows.

******************* End of STACKTRACE ******************
**
**       End of stack trace from Non-Fatal IQ Internal Error optlib/opt_JoinNode.cxx:10768
**
********************************************************

Exception Thrown from optlib/opt_JoinNode.cxx:10768, Err# 0, tid 23 origtid 23
   O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
[20238]: IQ Internal error. Please report this to SAP IQ support.

----
opt_JoinNode::IdentifyBestBasisForSemiJoin
opt_JoinNode::GetProjectionReduction
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::InsertSemiJoinsInSavingsOrder
opt_QueryTree::ProcessQueryTree
opt_Select::GenerateDFOs
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


Read more...

Environment

  • SAP IQ 16.0

Product

SAP IQ 16.0

Keywords

join_preference , opt_JoinNode::IdentifyBestBasisForSemiJoin , opt_JoinNode::GetProjectionReduction , opt_QueryTree::CollectSemiJoinsForOrdering , optlib/opt_JoinNode.cxx , 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.