SAP Knowledge Base Article - Preview

3241081 - Cannot evaluate expression and non-fatal stack trace in dfo::ValidateOutputVectors on a complex SQL error

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

SAP IQ 16.0

Keywords

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.