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
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.