Symptom
1. IQ server returns an error "dflib/dfo_cOrderBy.cxx:343" against a select statement having a RANK
SELECT T1.COL001, T1.COL002
,ROW_NUMBER() OVER (PARTITION BY T1.COL001, T1.COL002 ORDER BY T1.COL003 DESC) AS SEQ
FROM TAB_1 T1 , TAB_2 T2
WHERE T1.COL001 = T2.COL001 ;
2. Error messages
** Non-Fatal IQ Internal Error Detected
** at dflib/dfo_cOrderBy.cxx:343 on thread 194 (TID 21)
** Error detected at DFO #15 Order By (Per-Work-Unit) (shadow 1 of #07)
............
............
_Z13ucstkgentraceii + ..........................................
_Z23StackTraceForThisThreadPKciS0_S0_S0_ + ..........................................
_ZN12df_ExceptionC1EPKciNS_12df_ErrorCodeES1_S1_PK3dfoPK12df_Evaluable + ..........................................
_ZN12df_Exception14ThrowExceptionEPKciNS_12df_ErrorCodeES1_S1_PK3dfoPK12df_Evaluable + ..........................................
_ZNK11dfo_OrderBy32ValidateLocalInternalConsistencyEv + ..........................................
_ZNK12dfo_cOrderBy32ValidateLocalInternalConsistencyEv + ..........................................
_ZNK3dfo27ValidateInternalConsistencyEv + ..........................................
_ZNK3dfo27ValidateInternalConsistencyEv + ..........................................
_ZNK3dfo27ValidateInternalConsistencyEv + ..........................................
_ZN8dfo_Root7PrepareEv + ..........................................
............
Read more...
Environment
SAP IQ 16.0 SP02, SP03
Product
Keywords
CR 765098, dflib/dfo_cOrderBy, dfo_cOrderBy, ValidateLocalInternalConsistency, _ZNK11dfo_OrderBy32ValidateLocalInternalConsistencyEv , 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.
SAP Knowledge Base Article - Preview