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, for UPDATE or INSERT queries the server may return the following error:

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." 

  • 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
  • The 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 

Product

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

Keywords

sybase, abort, fail, crash, joins, CR806424, CR#806424, 806424, StackTraceForThisThread, parallel, max_query_parallelism, dml_options2, 8388608 , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.