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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.