Symptom
A SELECT query on one table with a combination of 3 conditions and with a CMP index would cause non-fatal failure in vpp::CreateShadow.
The table has a CMP index.
The SELECT would succeed if:
- one the 3 conditions is removed.
- or the CMP index is removed
- or add the LF index suggested by the index advisor.
Excerpt of IQMSG
Advice: Add LF index on T.CHANNEL_GENRE Predicate: (T.CHANNEL_GENRE = 'Kids')
Advice: Add LF index on T.previous_channel_genre Predicate: (master_events_build.P83_Viewing_201510.previous_channel_genre = 'Kids')
********************************************************
**
** Non-Fatal IQ Internal Error Detected
** at vplib/vpp.cxx:260 on thread 3359471360 (TID 30)
vpp::CreateShadow
vpp_Boolean::CreateShadow
vpp_Combiner::CreateShadowVppTree
vpp_Combiner::SetupParallelFind
vpp_Combiner::ExecuteOpus
vpp::Execute
vp_Predicates::PreExecute
Exception Thrown from vplib/vpp.cxx:260, Err# 0, tid 30 origtid 30
O/S Err#: 0, ErrID: 9216 (df_Exception); SQLCode: -1006000, SQLState: 'QBA00', Severity: 23
Read more...
Environment
SAP IQ 16 SP 4.11
Product
Keywords
vpp_Boolean::CreateShadow ; vpp_Combiner::CreateShadowVppTree ; vpp_Combiner::SetupParallelFind ; vpp_Boolean ; vpp_Combiner ; CreateShadow ; CreateShadowVppTree ; SetupParallelFind; CR#793001 ; CR793001 ; 793001 ; , 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.