SAP Knowledge Base Article - Preview

2504716 - Query fails with Non-Fatal IQ Internal Error at optlib/opt_TreeTransform.cxx:7841 -- SAP IQ

Symptom

After upgrading to IQ 16.x from 15.x, working query fails with following non-fatal stack trace frames and messages in .iqmsg

----
opt_Driver::SubqEagerDistinctTransform
opt_Driver::ApplySubqEagerDistinctTransform
opt_Driver::ApplySubqEagerDistinctTransform
opt_Driver::ApplySubqEagerDistinctTransform
opt_Driver::ApplySubqEagerDistinctTransform
opt_Driver::ApplySubqEagerDistinctTransform
opt_Driver::ApplyDFOTreeTransforms
opt_Driver::GenerateTree
db_cursorIQUpdate::Parse
db_sqlinsert::UpdateParse
db_sqlinsert::Parse
st_command::DoCmdThroughResourceGate
----

******************* End of STACKTRACE ******************
**
**       End of stack trace from Non-Fatal IQ Internal Error optlib/opt_TreeTransform.cxx:7841
**
********************************************************
Exception Thrown from optlib/opt_TreeTransform.cxx:7841, Err# 0, tid 2 origtid 2
   O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
[20238]: IQ Internal error. Please report this to SAP IQ support.
-- (optlib/opt_TreeTransform.cxx 7841)


Read more...

Environment

SAP IQ 16.X

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

opt_Driver::SubqEagerDistinctTransform , opt_Driver::ApplySubqEagerDistinctTransform , Non-Fatal IQ Internal Error , optlib/opt_TreeTransform.cxx:7841 , dml_options12 , 2147483648 , 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.