SAP Knowledge Base Article - Preview

2023306 - [SAP IQ] A SQL with rollup clause might cause a non-fatal error(dfo.cxx:11252).

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

SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4

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.