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