Symptom
A complex query with a lot of sub-queries generates a Non-Fatal IQ Internal Error from "dflib/dfp_MColEquality" on a secondary node.
[Stacktrace]
_Z13ucstkgentraceii
_Z23StackTraceForThisThreadPKciS0_S0_S0_
_ZN12df_ExceptionC1EPKciNS_12df_ErrorCodeES1_S1_PK3dfoPK12df_Evaluable
_ZN12df_Exception16ThrowException_0EPKciNS_12df_ErrorCodeE
_ZN16dfp_MColEqualityC1ERK18hos_vector_noerrorP7s_index
_ZN13opt_TableNode28ReplaceWithMultiColumnEqPredER18hos_vector_noerrorP7s_index
_ZN13opt_TableNode28FindUsableMultiColumnEqPredsER18hos_vector_noerror
_ZN13opt_TableNode25AnalyzeMultiColumnIndexesEi
_ZN13opt_QueryNode25AnalyzeMultiColumnIndexesEi
_ZN13opt_QueryNode25AnalyzeMultiColumnIndexesEi
_ZNK13opt_QueryTree15GetOwningSelectEv at /cm/iqa/include/opt_QueryTree.h:111
_ZN13opt_QueryTree16ProcessQueryTreeEv
_ZN10opt_Select12GenerateDFOsEP7df_HeapP12opt_QueryExp
_ZN10opt_Select12GenerateDFOsEP7df_HeapP12opt_QueryExp
...
******************* End of STACKTRACE ******************
** End of stack trace from Non-Fatal IQ Internal Error dflib/dfp_MColEquality.cxx:97
********************************************************
Exception Thrown from dflib/dfp_MColEquality.cxx:97, Err# 0, tid 23 origtid 23
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.
Read more...
Environment
SAP IQ/16.0.102.6.1386/20147/P/sp10.15/ITANIUM/HP-UXi 11.31/64bit/2016-04-26 16:06:19
Multiplex 5 node
Product
Keywords
SAP IQ, IQ, dflib/dfp_MColEquality,dfp_MColEquality, _ZN16dfp_MColEqualityC1ERK18hos_vector_noerrorP7s_index, CR 810860, CR#810860, CR810860 , 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.