Symptom
When a sql with rollup clause failed to execute due to below internal error.
[SQL]
SELECT COL001, COL002, COL003 ,STAGE_COUNT FROM
(
SELECT COL001, COL002, COL003,COUNT(*) AS STAGE_COUNT
FROM TAB001 T1
GROUP BY COL001, COL002, COL003
WITH ROLLUP) T1
[Error]
********************************************************
**
** Non-Fatal IQ Internal Error Detected at dfo.cxx:11252
** on thread 3278518016 (TID 39)
** Internal error at node: #04 Can not evaluate expression: FPORDINAL(T1.COL001, 1)
** Error detected at DFO #04 RollUp (Sort)
dfo::ValidateOutputVectors...
dfo::ValidateOutputVectors...
dfo_Root::Prepare()...
db_cursorIQtoIQ::Prepare()...
db_sqlinsert::SPrepare()...
db_sqlinsert::Prepare()...
st_command::DoCmdThroughResourceGate()...
st_iqdml::Insert...
Read more...
Environment
SAP IQ 15.2 all, 15.4 less than ESD3
Product
Keywords
dfo.cxx:11252, RollUp, 688117, Non-Fatal, Internal , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.