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

• 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',

IQ 16.0 SP11 PL22

819051, cr  819051, cr # 819051, 'dfo.cxx:14381' , , KBA , BC-SYB-IQ , Sybase IQ , Problem