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.