2116329 - Error at "optlib/opt_JoinNode.cxx:2666" - SAP IQ

Symptom

SAP IQ 16 returns an error at "optlib/opt_JoinNode.cxx:2666" when running a specific query.

I. 11/11 14:42:21. 0000200547 ** Non-Fatal IQ Internal Error Detected
I. 11/11 14:42:21. 0000200547 ** at optlib/opt_JoinNode.cxx:2666 on thread 275 (TID 44)
I. 11/11 14:42:21. 0000200547 ** with Query_Name: Optjoin_trc

.StackTraceForThisThread(.............
.df_Exception::df_Exception(.............
.df_Exception::ThrowException_0(.............
.opt_JoinNode::ReSelectBinaryJoinAlgorithm(opt_JoinNode::opt_JoinTime)+.............
.opt_QueryNode::DropLocalRedundantEQPreds()+.............
.opt_QueryNode::RecursivelyDropRedundantEQPreds()+.............
.opt_QueryNode::RecursivelyDropRedundantEQPreds()+.............
.opt_QueryNode::RecursivelyDropRedundantEQPreds()+.............
.opt_QueryNode::RecursivelyDropRedundantEQPreds()+.............
.opt_QueryTree::OptimizeJoinTree(opt_QueryNode*)+.............
.opt_QueryTree::ProcessQueryTree()+.............
.opt_Select::GenerateDFOs(df_Heap*,opt_QueryExp*)+.............
.opt_Driver::GenerateTree(QueryNode*,.............

Environment

SAP IQ 16.0 SP08.x

Product

SAP IQ 16.0

Keywords

774221, CR 774221, 785079, CR 785079, opt_JoinNode, ReSelectBinaryJoinAlgorithm, opt_QueryNode, DropLocalRedundantEQPreds , KBA , BC-SYB-IQ , Sybase IQ , 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.