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.
SAP Knowledge Base Article - Preview