SAP Knowledge Base Article - Preview

2771985 - Query fails with Non-Fatal IQ Internal Error optlib/opt_JoinNode.cxx:10794 - SAP IQ

Symptom

Stacktrace shows following function calls:

 ********************************************************
 **
 ** Non-Fatal IQ Internal Error Detected
 ** at optlib/opt_JoinNode.cxx:10998 on thread 139877522167552 (TID 16)
 **
 ** 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: 131438 SA connID: 16 IQ connID: 0001049523 User: ACTIMIZE_ETL
 ** Time of error: 2019-12-23 01:37:30
 ** IQ Version: SAP IQ/16.1.020/11410/P/sp02.10
 ** OS info: IQ built on: Linux/Linux64 - x86_64 - 2.6.18-194, Executed on: Linux/db61w112m3.etrade.com/3.10.0-862.11.6.el7.x86_64/#1 SMP Fri Aug 10 16:55:11 UTC 2018/x86_64
 ** Command status when error occured: CURSOR ACTIVE

df_Exception::ThrowException_0
opt_JoinNode::IdentifyBestBasisForSemiJoin
opt_JoinNode::GetProjectionReduction()
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering
opt_QueryTree::CollectSemiJoinsForOrdering


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.0

Keywords

CR818850, CR#818850, 818850, 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.