SAP Knowledge Base Article - Preview

2281876 - IQ Internal Error "optlib/opt_QueryTree.cxx" in opt_QueryTree::InferScalarSubQuery- SAP IQ

Symptom

  • After migrated to IQ16 SP10.8, a specific query constantly generates a Non-Fatal IQ Internal Error with optlib/opt_QueryTree.cxx.
  • The problematic query had worked fine on IQ 12.7.
  • This is reproducible issue with just DDL.

Excerpt of stack trace

opt_QueryTree::GenerateInferredPredicates
opt_QueryTree::GenerateInferredPredicates
opt_QueryTree::GenerateInferredPredicates
opt_QueryTree::ProcessPredicates
opt_Select::ProcessPredicates
opt_DML::ProcessPredicates
opt_Driver::OptimizeQueryExp
opt_Driver::GenerateTree
db_InsertRoot::Execute


Read more...

Environment

SAP IQ 16.0 SP10 and later

Product

SAP IQ 16.0

Keywords

CR 795897 ; CR#795897 ; 795897 ; "opt_QueryTree..InferScalarSubQuery" ; 'opt_QueryTree.cxx" ; "opt_QueryTree" ; , 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.