SAP Knowledge Base Article - Preview

3310388 - IQ 16.1 Stack trace on dfo::ValidateOutputVectors when executing some complex query - SAP IQ

Symptom

A complex query continues to hit in the following stack trace:

**       Non-Fatal IQ Internal Error Detected
**       at dflib/dfo.cxx:14970 on thread xxxxxxxxxxxxxxxx (TID xx)
**       Internal error at node: #23  Can not evaluate expression: TRIM(XXXXXXX)
**       Error detected at DFO #23 Order By 

dfo::ValidateOutputVectors
dfo::ValidateOutputVectors
dfo::ValidateOutputVectors
dfo_Root::Prepare
st_cursorIQtoSA::Prepare
df_OpenCursor::Prepare
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::OpenCursor
df_OmniRowScan::Restart
dfo_Scan::DoFetch
dfo_Scan::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetch
dfo_Root::DoFirstFetch
dfo_Base::Fetch
dfo_Root::DoFetchRelative
dfo_Root::FetchRelative
DB_Search_fetch
dbi_fetch
db__fetch

    **
    **       End of stack trace from Non-Fatal IQ Internal Error dflib/dfo.cxx:14970
    **
    ********************************************************
    
 Exception Thrown from dflib/dfo.cxx:14970, Err# 1057, tid xx origtid xx
   O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1001043, SQLState: 'QFA39', Severity: 14
[99999]: Report to SAP IQ Support. Query 'Internal error at node: #23  Can not evaluate expression: TRIM(XXXXXXX)', 


Read more...

Environment

  • SAP IQ 16.1 SP04 PL14
  • SAP IQ 16.1 SP05 PL07
  • Linux

Keywords

"Can not evaluate", "dfo::ValidateOutputVectors", 827790, "Order By", TRIM , 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.