2334808 - An "dflib/dfo.cxx:15432" error happened when setting a DML_OPTIONS14 to 512. | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2334808 - An "dflib/dfo.cxx:15432" error happened when setting a DML_OPTIONS14 to 512.

Symptom

A specific query got aborted with a "dflib/dfo.cxx15432" error.
  
I. 06/09 13:25:25. 0000708512     **       Non-Fatal IQ Internal Error Detected
I. 06/09 13:25:25. 0000708512     **       at dflib/dfo.cxx:15432  on thread 139970609903360 (TID 8)
 
[Stacktace]
StackTraceForThisThread(..................
df_Exception::df_Exception(..................
df_Exception::ThrowException_0(..................
dfo::GetGroupByBestFactorEstimate(..................
dfo_GroupBy::GetCardinalityEstimate(..................
opt_GroupNode::SelectGroupingAlgorithm()+..................
opt_GroupNode::GatherMetaDataAndSelectGroupingAlgorithm()+..................
opt_Union::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_Select::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_QueryExp::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_Union::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_Select::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_QueryExp::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_Union::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_Select::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................
opt_QueryExp::GenerateDFOs(df_Heap*, opt_QueryExp*)+..................

The error happens only when setting DML_OPTIONS14 to 512 at PUBLIC level for resolving another performance problem.
If Cognos is being used as a reporting tool, it's not possible to set the option to its default value.


Read more...

Environment

SAP IQ 16.0 SP 10 PL01

Product

SAP IQ 16.0

Keywords

IQ, dflib/dfo.cxx:15432, GetGroupByBestFactorEstimate, dfo_GroupBy, GetCardinalityEstimate , 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.