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