Symptom
A complex query causes a non-fatal stack trace and fires the error: Can not evaluate expression: USER1.collateral_reuse_summary.as_of_dt
Non-Fatal IQ Internal Error Detected
at dflib/dfo.cxx:14974 on thread 140280627721984 (TID 5)
with Query_Name: IQ complex Sql
Internal error at node: #05 Can not evaluate expression: USER1.collateral_reuse_summary.as_of_dt
Error detected at DFO #05 Join (Hash)
....
Command text:
select "collateral_reuse_summary"."legal_entity_name" as "legal_entity_name"
from "USER1"."collateral_reuse_summary" as "collateral_reuse_summary"
join(select "collateral_reuse_summary"."fyr_actg_prd" as "fyr_actg_prd","MAX"("collateral_reuse_summary"."as_of_dt") as "X_measure__0"
from "USER1"."collateral_reuse_summary" as "collateral_reuse_summary"
group by "collateral_reuse_summary"."fyr_actg_prd") as "t0"
on("collateral_reuse_summary"."fyr_actg_prd" = "t0"."fyr_actg_prd")
where((case when "collateral_reuse_summary"."as_of_dt" = "t0"."X_measure__0" then '1' else '0' end) = '1')
group by "collateral_reuse_summary"."legal_entity_name"
dfo::ValidateOutputVectors
dfo::ValidateOutputVectors
dfo::ValidateOutputVectors
dfo::ValidateOutputVectors
dfo::ValidateOutputVectors
dfo::ValidateOutputVectors
dfo_Root::Prepare
st_cursorIQtoSA::Prepare
df_OpenCursor::Prepare
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor
st_SAIQInterfaceInfo::callFunction
st_SAIQInterface::RunIQFunc
st_SAIQInterface::Execute
saint_iqthresholddml::OpenCursor
df_OmniRowScan::Restart
dfo_Scan::DoFetch
dfo_Scan::DoFirstFetch
Read more...
Environment
SAP IQ 16.1 SP04 PL 12
Product
Keywords
ValidateOutputVectors, CR827075 , 827075, , 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