SAP Knowledge Base Article - Preview

2267757 - SAP IQ 16: A SELECT query with a combination of conditions and with a CMP index would cause non-fatal failure in vpp::CreateShadow.

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

SAP IQ 16.0

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.