2530849 - GROUP BY from child not ordered as required non-fatal abort at dfo.cxx - SAP IQ | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2530849 - GROUP BY from child not ordered as required non-fatal abort at dfo.cxx - SAP IQ

Symptom

  • In some circumstances, the server may return the SQL error code -1006001 "IQ Internal error. Please report this to SAP IQ support. Input to <note type> #<nn> from child #<mm> not ordered as required." for update or insert queries.

  • Non fatal error messages at dfo.cxx seen in the iqmsg file...
    ** Non-Fatal IQ Internal Error Detected
    ** at dflib/dfo.cxx:13225 on thread 205 (TID 8)
    ** Input to GROUP BY #07 from child #05 not ordered as required. Key: xxxx
    ** Error detected at DFO #05 SubQuery PreFilter

  • Statement fails with this stack trace ...
    df_Exception::ThrowException
    dfo::ValidateOutputOrdering()
    dfo::ValidateInputOrderings() ... repeated a number of times
    dfo_Root::Prepare()
    db_dmlcommand::ExecuteDFOTree()
    db_InsertRoot::Execute()
    st_command::DoCmdThroughResourceGate()
    st_iqdml::Insert
    UIQDML_Insert
    st_SAIQInterfaceInfo::callFunction()

Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.4 

on all platforms

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

sybase, abort, fail, crash, query, joins,  nonfatal, 'Non-Fatal', CR806424, CR#806424, 806424, 'dfo::ValidateOutputOrdering', 'df_Exception::df_Exception', 'StackTraceForThisThread', , 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.