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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.