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 for Me (Login required).

Search for additional results

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