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 for Me (Login required).

Search for additional results

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