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