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.
SAP Knowledge Base Article - Preview