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 ONE Support launchpad (Login required).

Search for additional results

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