SAP Knowledge Base Article - Preview

2683932 - Query Error 'Can not evaluate expression... 'dfo.cxx 13925' -- SAP IQ

Symptom

A complex GROUP BY query encountered an error "Can not evaluate expression... dfo.cxx 13925".

 >> Problem Query (Simplified Query):
 
  SELECT cast ... AS "86400",
     COALESCE(SUM(USER_NUM),0) AS COMMON_USER_COUNTER , D_TERM."203010101" AS "203010101"
     FROM ST_SUBS_575 LEFT JOIN
        (SELECT TAC AS "203050101", TBRAND_NM AS "203010101", TBRAND_NM AS N_203010101
           FROM D_TERM GROUP BY TAC, TBRAND_NM) D_TERM
             ON TAC = D_TERM."203050101" LEFT JOIN (
         SELECT ..., L1REGIONNAME AS NAME_2250110101
           FROM D_REGION GROUP BY L1REGIONNAME, L1REGIONID) H_REGION
             ON LAYER1_ID = H_REGION."225010101"
    WHERE H_REGION.NAME_2250110101 IS NOT NULL
      AND D_TERM.N_203010101 IS NOT NULL
    GROUP BY "86400", D_TERM."203010101" ;

 >> Error & Stack :

     Report to SAP IQ Support. Query 'Internal error at node: #01 Can not
     evaluate expression: D_TERM_3__.TBRAND_NM', -- (dflib/dfo.cxx 13925)
     SQLCODE=-1001043, ODBC 3 State="HY000" Line 1, column 1

     ===== Thread Number  140310575228672  ...
     ..
     .. StackTraceForThisThread ..
     .. df_Exception::df_Exception ..
     .. df_Exception::ThrowException ..
     .. dfo::ValidateOutputVectors ..
     .. dfo::ValidateOutputVectors ..
     .. dfo::ValidateOutputVectors ..
     .. dfo::ValidateOutputVectors ..
     .. dfo::ValidateOutputVectors ..
     .. dfo::ValidateOutputVectors ..
     .. dfo::ValidateOutputVectors ..
     .. dfo_Root::Prepare ..
     .. st_cursorIQtoSA::Prepare ..
     ..


Read more...

Environment

SAP IQ 16.0 SP11.x

Product

SAP IQ 16.0

Keywords

ValidateOutputVectors, CR815186, CR#815186, 815186, 'dfo.cxx', , 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 ONE Support launchpad (Login required).

Search for additional results

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