SAP Knowledge Base Article - Preview

2680547 - query fails internal error at opt_Union.cxx - regression since SP02 PL06 - SAP IQ 16.1

Symptom

  • SQL statements like INSERTS working fine prior to IQ 16.1 SP02 PL07 now fail with Non-Fatal error detected at opt_Union.cxx:1212

  • These queries will contain UNION ALL views and outer joins.

  • accompanying messages seen in the iqmsg file

ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00'

  • stack trace produced...
    opt_Union::EliminateUnneededUnionArms(df_Heap*)
    opt_QueryExp::OptimizeQueryBlockTree
    opt_Select::OptimizeQueryBlockTree
    opt_QueryExp::OptimizeQueryBlockTree
    dfo_Root*opt_Driver::GenerateTree
    db_InsertRoot::Execute()
    st_command::DoCmdThroughResourceGate()

Read more...

Environment

  • SAP IQ 16.1 SP02 PL07 any platform
  • SAP IQ 16.1 SP02 PL08 any platform
  • SAP IQ 16.1 SP02 PL09 and platform

Product

SAP IQ 16.1

Keywords

sybase, abort, fail, error, regression, bug, CR814789, CR#814789, 814789, update, nonfatal, outerjoin, unionall, upgrade, broken, mpx, multiplex, 'stack trace', stktrc , 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.