SAP Knowledge Base Article - Preview

2939727 - "Cannot find DFO operator for NonDeterministc function" error during extracting data using "number()" function

Symptom

Following error returns during extracting data using "number()" function.

There was an error reading the results of the SQL statement.
The displayed results may be incorrect or incomplete.
IQ Internal error. Please report this to SAP IQ support. Cannot find DFO
operator for NonDeterministc function
-- (optlib/opt_Driver.cxx 1336)
SQLCODE=-1006001, ODBC 3 State="HY000"

--.iqmsg & stacktrace

********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at optlib/opt_Driver.cxx:1352 on thread 139857856456448 (TID 10)
** Cannot find DFO operator for NonDeterministc function
...
** IQ Version: SAP IQ/16.1.030/13560/P/sp03.08
** OS info: IQ built on: Linux/Linux64 - x86_64 - 3.10.0-327, Executed on: Linux/HOSTNAME/4.8.6-300.fc25.x86_64/#1 SMP Tue Nov 1 12:36:38 UTC 2016/x86_64
** Command status when error occured: CURSOR ACTIVE
** Command text:
select "Surname","GivenName","NUMBER"() from "Contacts"

***************** This is the STACKTRACE ***************

===== Thread Number 139857856456448 (IQ connID: 0000000106) =====
pcstkwalk
ucstkgentrace
StackTraceForThisThread
df_Exception::df_Exception
df_Exception::ThrowException
opt_Driver::VectorAssignment
opt_Driver::ApplyDFOTreeTransforms
opt_Driver::GenerateTree
st_cursorIQtoSA::Parse
df_OpenCursor::Parse
st_command::DoCmdThroughResourceGate
st_iqdml::OpenCursor
UIQDML_OpenCursor+0x25
...

******************* End of STACKTRACE ******************
** End of stack trace from Non-Fatal IQ Internal Error optlib/opt_Driver.cxx:1352
********************************************************
Exception Thrown from optlib/opt_Driver.cxx:1352, Err# 1048, tid 10 origtid 10
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006001, SQLState: 'QBA01', Severity: 23
[20239]: IQ Internal error. Please report this to SAP IQ support. Cannot find DFO operator for NonDeterministc function
-- (optlib/opt_Driver.cxx 1352)

 


Read more...

Environment

  • SAP IQ 16.1 SP02
  • SAP IQ 16.1 SP03/SP03.07/SP03.08
  • SAP IQ 16.1 SP04.04 

Product

SAP IQ 16.1

Keywords

opt_Driver.cxx, NUMBER(*), VectorAssignment, ApplyDFOTreeTransforms, , KBA , BC-SYB-IQ , Sybase IQ , BW-SYS-DB-IQ , BW on HANA with Sybase IQ Near-line Storage , 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.