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.

----
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

******************* 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.


Read more...

Environment

SAP IQ 16.X

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

Search for additional results

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