SAP Knowledge Base Article - Preview

2782247 - IQ Internal Error Detected at dflib/dfo.cxx:14381, -- " .. Can not evaluate expression.." -- SAP IQ16

Symptom

  • There was an error reading the results of the SQL statement.  The displayed results may be incorrect or incomplete.  Report to SAP IQ Support. Query 'Internal error at node: #03  Can not  evaluate expression: CAST(COUNT(DISTINCT  FPVALUE(FPORDINAL(RANDOM_00013220.D2X023_2015`(1), 3))) AS INT',  --  (dflib/dfo.cxx 14381)  SQLCODE=-1001043, ODBC 3 State="HY000"

  Non-Fatal IQ Internal Error Detected
  at dflib/dfo.cxx:14381 on thread 140722702857984 (TID 4)
  with Query_Name: Options6
  Internal error at node: #03 Can not evaluate expression: CAST(COUNT(DISTINCT FPVALUE(FPORDINAL(RANDOM_00013220.D2X023_2015`(1), 3))) AS INT64)
  Error detected at DFO #03 Group By (Sort) (shadow 0)

  •   Command status when error occurred: CURSOR ACTIVE

  Command text:
  015`(1), 3))) AS INT',
  006"."SUBQUERY_00000002") as "_CTE___CT4CTE___C1A951A9FA8D40EA946A1FDACF4F8DFA_",
 "EMPTY_00000501" as "SUBQUERY_00000000",
  _00000005"
  NDOM_00013217"
  SUBQUERY_00013218"
  "_CTE___CT4CTE___NIU_" asc,"_CTE___CT4CTE___D2X023_" asc
  Query Plan:
  0 #09: Root
  CAUTIONARY NOTE:
=====

  ...
  pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+0x32
  ucstkgentrace(int, int)+0x121
  StackTraceForThisThread(char const*, int, char const*, char const*, char const*)+0x341
  df_Exception::df_Exception(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x576
  df_Exception::ThrowException(char const*, int, df_Exception::df_ErrorCode, char const*, char const*, dfo const*, df_Evaluable const*)+0x35
  dfo::ValidateOutputVectors(hos_vector_noerror&, hos_vector_noerror&)+0x11b1
  dfo::ValidateOutputVectors(hos_vector_noerror&, hos_vector_noerror&)+0xe9
  dfo::ValidateOutputVectors(hos_vector_noerror&, hos_vector_noerror&)+0xe9
  dfo::ValidateOutputVectors(hos_vector_noerror&, hos_vector_noerror&)+0xe9
  dfo_Root::Prepare()+0x5a1
  st_cursorIQtoSA::Prepare()+0x133
  df_OpenCursor::Prepare()+0x60
  st_command::DoCmdThroughResourceGate()+0x78
  st_iqdml::OpenCursor(a_statement*, UIConnection*, UICursor*, a_cursor_spec*, a_cursor_orientation)+0x78
  ... 
 
  Exception Thrown from dflib/dfo.cxx:14381, Err# 1057, tid 4 origtid 4
  O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1001043, SQLState: 'QFA39', Severity: 14
  Report to SAP IQ Support. Query 'Internal error at node: #03 Can not evaluate expression: CAST(COUNT(DISTINCT FPVALUE(FPORDINAL(RANDOM_00013220.D2X023_2015`(1), 3))) AS INT',


Read more...

Environment

IQ 16.0 SP11 PL22

Product

SAP IQ 16.0

Keywords

819051, cr  819051, cr # 819051, 'dfo.cxx:14381' , , 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 ONE Support launchpad (Login required).

Search for additional results

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