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